Spreadsheet: 154641d1336501424-dynamic-sumif-with-pivot-table-example
Sheet: Sheet1

request_id | document_id | voucher_date | request_name | preparer_user_name | request_status_name | request_submitted | request_type_name | request_type_name_short | payee_id | payee_first | payee_last | payee_comment | payee_trip_purpose | comment_1 | comment_2 | division_name | created | fund | dpa | prog | fy
1135 | PQA1135 | 2010-11-29 10:23:32 | ADVERTISING | [NAME] | Submitted & Pending | 2010-11-29 10:23:32 | U5-2 | C | 21230321 |  | [NAME] |  | PLEASE REIMBURSE |  |  | 1 | 2010-11-29 00:00:00
1135 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30022 | 444941
1136 | PQA1136 | 2010-11-29 10:27:09 | U5-2: 11/29/2010 | [NAME] | Submitted & Pending | 2010-11-29 10:27:09 | U5-2 | C | 02-4476418 |  | jones |  | PLEASE REIMBURSE |  |  | 2 | 2010-11-29 00:00:00
1136 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33868 | 404941
1137 | PQA1137 | 2010-11-29 10:30:40 | U5-2: 11/29/2010 | [NAME] | Submitted & Pending | 2010-11-29 10:30:40 | U5-2 | C | 25163809 |  | ray |  | PLEASE REIMBURSE |  |  | 3 | 2010-11-29 00:00:00
1137 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18111 | 541125
1137 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18111 | 541125
1084 | PQA1084 | 2010-11-18 11:36:55 | U5-2: 11/18/2010 | [NAME] | Submitted & Pending | 2010-11-18 11:36:55 | U5-2 | C | 30056581 |  | CRAIGSLIST |  | PLEASE PAY FOR THE COST TO ADVERTISE FOR A RESEARCH ANALYST AND [NAME] POSITIONS ON CRAIGSLIST |  |  | ADOL | 2010-11-18 00:00:00
1084 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9545 | 416343
show look like
request_id | document_id | voucher_date | request_name | preparer_user_name | request_status_name | request_submitted | request_type_name | request_type_name_short | payee_id | payee_first | payee_last | payee_comment | payee_trip_purpose | comment_1 | comment_2 | division_name | created | fund | dpa | prog | fy
1135 | PQA1135 | 2010-11-29 10:23:32 | ADVERTISING | [NAME] | Submitted & Pending | 2010-11-29 10:23:32 | U5-2 | C | 21230321 |  | [NAME] |  | PLEASE REIMBURSE |  |  | 1 | 2010-11-29 00:00:00
1135 | PQA1135 | 2010-11-29 10:23:32 | ADVERTISING | [NAME] | Submitted & Pending | 2010-11-29 10:23:32 | U5-2 | C | 21230321 |  | [NAME] |  | PLEASE REIMBURSE |  |  | 1 | 2010-11-29 00:00:00 | 30022 | 444941
1136 | PQA1136 | 2010-11-29 10:27:09 | U5-2: 11/29/2010 | [NAME] | Submitted & Pending | 2010-11-29 10:27:09 | U5-2 | C | 02-4476418 |  | jones |  | PLEASE REIMBURSE |  |  | 2 | 2010-11-29 00:00:00
1136 | PQA1136 | 2010-11-29 10:27:09 | U5-2: 11/29/2010 | [NAME] | Submitted & Pending | 2010-11-29 10:27:09 | U5-2 | C | 02-4476418 |  | jones |  | PLEASE REIMBURSE |  |  | 2 | 2010-11-29 00:00:00 | 33868 | 404941
1137 | PQA1137 | 2010-11-29 10:30:40 | U5-2: 11/29/2010 | [NAME] | Submitted & Pending | 2010-11-29 10:30:40 | U5-2 | C | 25163809 |  | ray |  | PLEASE REIMBURSE |  |  | 3 | 2010-11-29 00:00:00
1137 | PQA1137 | 2010-11-29 10:30:40 | U5-2: 11/29/2010 | [NAME] | Submitted & Pending | 2010-11-29 10:30:40 | U5-2 | C | 25163809 |  | ray |  | PLEASE REIMBURSE |  |  | 3 | 2010-11-29 00:00:00 | 18111 | 541125
1137 | PQA1137 | 2010-11-29 10:30:40 | U5-2: 11/29/2010 | [NAME] | Submitted & Pending | 2010-11-29 10:30:40 | U5-2 | C | 25163809 |  | ray |  | PLEASE REIMBURSE |  |  | 3 | 2010-11-29 00:00:00 | 18111 | 541125
1084 | PQA1084 | 2010-11-18 11:36:55 | U5-2: 11/18/2010 | [NAME] | Submitted & Pending | 2010-11-18 11:36:55 | U5-2 | C | 30056581 |  | CRAIGSLIST |  | PLEASE PAY |  |  | 4 | 2010-11-18 00:00:00
1084 | PQA1084 | 2010-11-18 11:36:55 | U5-2: 11/18/2010 | [NAME] | Submitted & Pending | 2010-11-18 11:36:55 | U5-2 | C | 30056581 |  | CRAIGSLIST |  | PLEASE PAY |  |  | 4 | 2010-11-18 00:00:00 | 9545 | 416343