Spreadsheet: 759752d1639701985-issue-using-getpivotdata-in-formula-cr-sheet
Sheet: Add Accounts

Row Labels | Sum of Total Creditor Add |  | Date Created | Sales Agent - Name | Client First Name | Client Last Name | Total Creditor Add | Total Creditor Remove | Total Debt Amount Added | Total Debt Amount Change | System Finalized Date
[NAME] | 0 |  | 2021-09-01 13:45:00 | [NAME] | Mario | Maldonado | 0 | 0 |  |  | 2021-09-01 00:00:00
[NAME] | 1 |  | 2021-09-02 13:43:00 | [NAME] | Manuel | [NAME] | 0 | 3 |  | -1796 | 2021-09-02 00:00:00
Chrisovalanto Prelia | 0 |  | 2021-09-02 18:01:00 | [NAME] | [NAME] | Haskins | 0 | 1 |  | -6762 | 2021-09-02 00:00:00
[NAME] | 2 |  | 2021-09-15 18:49:00 | [NAME] | Eva | Dukerschein | 0 | 3 |  | -8614 | 2021-09-15 00:00:00
Eva Gonzales | 0 |  | 2021-09-23 10:33:00 | [NAME] | [NAME] | COVARRUBIAS | 0 | 1 |  | -2165.43 | 2021-09-23 00:00:00
[NAME] | 2 |  | 2021-09-23 10:36:00 | [NAME] | [NAME] | COVARRUBIAS | 0 | 0 |  | 0 | 2021-09-23 00:00:00
[NAME] | 0 |  | 2021-09-23 10:37:00 | [NAME] | [NAME] | COVARRUBIAS | 0 | 0 |  |  | 2021-09-23 00:00:00
[NAME] | 1 |  | 2021-09-23 10:46:00 | [NAME] | [NAME] | COVARRUBIAS | 0 | 0 |  |  | 2021-09-23 00:00:00
Sage Roles | 0 |  | 2021-09-24 12:48:00 | [NAME] | [NAME] | Bartley | 0 | 1 |  | -2929 | 2021-09-24 00:00:00
[NAME] | 5 |  | 2021-09-24 18:14:00 | [NAME] | [NAME] | Sandoval | 0 | 2 |  | -11883 | 2021-09-24 00:00:00
[NAME] | 0 |  | 2021-09-02 16:29:00 | [NAME] | [NAME] | Larabee | 0 | 0 |  |  | 2021-09-02 00:00:00
Grand Total | 11 |  | 2021-09-09 11:57:00 | [NAME] | Agatha | Nava | 0 | 1 |  | -1009 | 2021-09-09 00:00:00
 |  |  | 2021-09-13 09:43:00 | [NAME] | [NAME] | Spicer | 0 | 1 |  | -20070 | 2021-09-13 00:00:00
 |  |  | 2021-09-14 16:31:00 | [NAME] | [NAME] | [NAME] | 0 | 0 |  |  | 2021-09-14 00:00:00
 |  |  | 2021-09-23 15:10:00 | [NAME] | [NAME] | Flores | 0 | 0 |  |  | 2021-09-23 00:00:00
 |  |  | 2021-09-23 15:11:00 | [NAME] | [NAME] | Flores | 0 | 0 |  |  | 2021-09-23 00:00:00
 |  |  | 2021-09-24 11:36:00 | [NAME] | Treva | Hodge | 1 | 0 | 2843 | 2843 | 2021-09-24 00:00:00
 |  |  | 2021-09-01 11:03:00 | Chrisovalanto Prelia | Rebecca | [NAME] | 0 | 1 |  | -1271 | 2021-09-01 00:00:00
 |  |  | 2021-09-01 16:06:00 | Chrisovalanto Prelia | [NAME] | Dawson-Horton | 0 | 1 |  | -2280 | 2021-09-01 00:00:00
 |  |  | 2021-09-01 16:50:00 | Chrisovalanto Prelia | Maureen | Bongard | 0 | 2 |  | -3317 | 2021-09-01 00:00:00
 |  |  | 2021-09-13 11:54:00 | Chrisovalanto Prelia | [NAME] | [NAME] | 0 | 0 |  |  | 2021-09-13 00:00:00
 |  |  | 2021-09-13 11:55:00 | Chrisovalanto Prelia | [NAME] | [NAME] | 0 | 1 |  | -9999 | 2021-09-13 00:00:00
 |  |  | 2021-09-15 16:25:00 | Chrisovalanto Prelia | Emil | Darling | 0 | 1 |  | -12537 | 2021-09-15 00:00:00
 |  |  | 2021-09-15 17:08:00 | Chrisovalanto Prelia | [NAME] | Hubbard | 0 | 1 |  | -1238 | 2021-09-15 00:00:00
 |  |  | 2021-09-20 14:16:00 | Chrisovalanto Prelia | [NAME] | [NAME] | 0 | 1 |  | -1103 | 2021-09-20 00:00:00
 |  |  | 2021-09-20 17:29:00 | Chrisovalanto Prelia | [NAME] | Lingley | 0 | 1 |  | -2673 | 2021-09-20 00:00:00
 |  |  | 2021-09-21 10:35:00 | Chrisovalanto Prelia | [NAME] | [NAME] | 0 | 3 |  | -26305.44 | 2021-09-21 00:00:00
 |  |  | 2021-09-21 15:58:00 | Chrisovalanto Prelia | [NAME] | [NAME] | 0 | 1 |  | -867 | 2021-09-21 00:00:00
 |  |  | 2021-09-22 14:31:00 | Chrisovalanto Prelia | Toby | Lisenba | 0 | 1 |  | -4461 | 2021-09-22 00:00:00
 |  |  | 2021-09-23 10:46:00 | Chrisovalanto Prelia | [NAME] | Cimino | 0 | 0 |  |  | 2021-09-23 00:00:00
 |  |  | 2021-09-24 12:23:00 | Chrisovalanto Prelia | [NAME] | moore | 0 | 2 |  | -12620 | 2021-09-24 00:00:00
 |  |  | 2021-09-01 10:47:00 | [NAME] | Skyler | Moorefield | 0 | 1 |  | -1293 | 2021-09-01 00:00:00
 |  |  | 2021-09-13 08:31:00 | [NAME] | [NAME] | Lugo | 0 | 1 |  | -4918 | 2021-09-13 00:00:00
 |  |  | 2021-09-14 11:36:00 | [NAME] | Julie | [NAME] | 0 | 1 |  | -26084 | 2021-09-14 00:00:00
 |  |  | 2021-09-16 10:05:00 | [NAME] | Stuart | [NAME] | 0 | 0 |  |  | 2021-09-16 00:00:00
 |  |  | 2021-09-16 10:07:00 | [NAME] | Stuart | [NAME] | 0 | 0 |  |  | 2021-09-16 00:00:00
 |  |  | 2021-09-16 10:10:00 | [NAME] | Stuart | [NAME] | 0 | 0 |  |  | 2021-09-16 00:00:00
 |  |  | 2021-09-16 10:16:00 | [NAME] | Stuart | [NAME] | 0 | 0 |  |  | 2021-09-16 00:00:00
 |  |  | 2021-09-16 16:39:00 | [NAME] | [NAME] | Rodriguez | 0 | 1 |  | -1288 | 2021-09-16 00:00:00
 |  |  | 2021-09-20 11:43:00 | [NAME] | [NAME] | [NAME] | 0 | 2 |  | -6458 | 2021-09-20 00:00:00
 |  |  | 2021-09-20 15:55:00 | [NAME] | [NAME] | Evans | 0 | 1 |  | -7801 | 2021-09-20 00:00:00
 |  |  | 2021-09-21 13:04:00 | [NAME] | Stuart | [NAME] | 1 | 0 | 3825.62 | 3825.62 | 2021-09-21 00:00:00
 |  |  | 2021-09-21 15:01:00 | [NAME] | Elvin | Heidbreder | 0 | 1 |  | -3691 | 2021-09-21 00:00:00
 |  |  | 2021-09-22 11:11:00 | [NAME] | Kristine | [NAME] | 1 | 0 | 4601.84 | 4601.84 | 2021-09-22 00:00:00
 |  |  | 2021-09-22 11:14:00 | [NAME] | Kristine | [NAME] | 0 | 0 |  |  | 2021-09-22 00:00:00
 |  |  | 2021-09-22 13:58:00 | [NAME] | Melinda | Smith | 0 | 1 |  | -5889 | 2021-09-22 00:00:00
 |  |  | 2021-09-24 10:50:00 | [NAME] | Javana | Quick | 0 | 1 |  | -8082 | 2021-09-24 00:00:00
 |  |  | 2021-09-24 13:14:00 | [NAME] | Javana | Quick | 0 | 0 |  |  | 2021-09-24 00:00:00
 |  |  | 2021-09-27 10:19:00 | [NAME] | Catalina | [NAME] | 0 | 1 |  | -3137 | 2021-09-27 00:00:00
 |  |  | 2021-09-01 16:00:00 | Eva Gonzales | Lloyd w | Shultz | 0 | 0 |  | 0 | 2021-09-01 00:00:00
 |  |  | 2021-09-02 12:56:00 | Eva Gonzales | [NAME] | [NAME] | 0 | 1 |  | -9384 | 2021-09-02 00:00:00
 |  |  | 2021-09-07 10:18:00 | Eva Gonzales | [NAME] | [NAME] | 0 | 1 |  | -11966 | 2021-09-07 00:00:00
 |  |  | 2021-09-07 10:36:00 | Eva Gonzales | [NAME] | Burr | 0 | 1 |  | -1461 | 2021-09-07 00:00:00
 |  |  | 2021-09-07 12:20:00 | Eva Gonzales | [NAME] | [NAME] | 0 | 1 |  | -9983 | 2021-09-07 00:00:00
 |  |  | 2021-09-08 15:29:00 | Eva Gonzales | Will | Moore | 0 | 2 |  | -2067 | 2021-09-08 00:00:00
 |  |  | 2021-09-08 15:38:00 | Eva Gonzales | Will | Moore | 0 | 2 |  | -2135 | 2021-09-08 00:00:00
 |  |  | 2021-09-09 14:51:00 | Eva Gonzales | [NAME] | Parham | 0 | 1 |  | -913 | 2021-09-09 00:00:00
 |  |  | 2021-09-10 11:39:00 | Eva Gonzales | [NAME] | Chaney | 0 | 3 |  | -60628 | 2021-09-10 00:00:00
 |  |  | 2021-09-17 12:46:00 | Eva Gonzales | [NAME] | French | 0 | 0 |  | 0 | 2021-09-17 00:00:00
 |  |  | 2021-09-27 11:42:00 | Eva Gonzales | [NAME] | [NAME] | 0 | 1 |  | -1322 | 2021-09-27 00:00:00
 |  |  | 2021-09-01 10:48:00 | [NAME] | Tami | Hames | 0 | 1 |  | -2355 | 2021-09-01 00:00:00
 |  |  | 2021-09-02 08:26:00 | [NAME] | [NAME] | LaBash | 0 | 2 |  | -9574 | 2021-09-02 00:00:00
 |  |  | 2021-09-07 11:47:00 | [NAME] | Christine | O'Dell | 1 | 0 | 749.32 | 749.32 | 2021-09-07 00:00:00
 |  |  | 2021-09-08 11:43:00 | [NAME] | [NAME] | Batts | 0 | 1 |  | -1584 | 2021-09-08 00:00:00
 |  |  | 2021-09-10 13:03:00 | [NAME] | Mickeen | [NAME] | 0 | 0 |  |  | 2021-09-10 00:00:00
 |  |  | 2021-09-13 09:51:00 | [NAME] | Natasa | To | 0 | 1 |  | -4006.18 | 2021-09-13 00:00:00
 |  |  | 2021-09-13 12:31:00 | [NAME] | [NAME] | West | 0 | 0 |  |  | 2021-09-13 00:00:00
 |  |  | 2021-09-13 14:15:00 | [NAME] | [NAME] | House | 0 | 0 |  |  | 2021-09-13 00:00:00
 |  |  | 2021-09-15 09:46:00 | [NAME] | [NAME] | [NAME] | 0 | 1 |  | -8067 | 2021-09-15 00:00:00
 |  |  | 2021-09-15 13:55:00 | [NAME] | Kenny | Pandey | 0 | 1 |  | -9923 | 2021-09-15 00:00:00
 |  |  | 2021-09-15 14:01:00 | [NAME] | Kenny | Pandey | 0 | 0 |  | 0 | 2021-09-15 00:00:00
 |  |  | 2021-09-16 11:41:00 | [NAME] | [NAME] | Kasky | 0 | 3 |  | -4042 | 2021-09-16 00:00:00
 |  |  | 2021-09-16 12:40:00 | [NAME] | Kimberly | Smith | 0 | 1 |  | -2026 | 2021-09-16 00:00:00
 |  |  | 2021-09-16 18:01:00 | [NAME] | Samantha | Simpson | 0 | 2 |  | -4050.12 | 2021-09-16 00:00:00
 |  |  | 2021-09-17 11:42:00 | [NAME] | [NAME] | Jones | 0 | 0 |  |  | 2021-09-17 00:00:00
 |  |  | 2021-09-17 12:04:00 | [NAME] | Darnell | Evans | 0 | 8 |  | -15721.16 | 2021-09-17 00:00:00
 |  |  | 2021-09-17 12:37:00 | [NAME] | [NAME] | Seward | 0 | 0 |  |  | 2021-09-17 00:00:00
 |  |  | 2021-09-17 13:18:00 | [NAME] | [NAME] | Seward | 0 | 0 |  |  | 2021-09-17 00:00:00
 |  |  | 2021-09-18 12:51:00 | [NAME] | [NAME] | Blevins | 0 | 0 |  |  | 2021-09-18 00:00:00
 |  |  | 2021-09-20 15:29:00 | [NAME] | [NAME] | [NAME] | 1 | 0 | 3410.42 | 3410.42 | 2021-09-20 00:00:00
 |  |  | 2021-09-21 10:42:00 | [NAME] | [NAME] | Macias | 0 | 0 | 34419 | 34419 | 2021-09-21 00:00:00
 |  |  | 2021-09-22 13:40:00 | [NAME] | [NAME] | [NAME] | 0 | 1 |  | -2923 | 2021-09-22 00:00:00
 |  |  | 2021-09-23 14:02:00 | [NAME] | Erika | [NAME] | 0 | 1 |  | -960 | 2021-09-23 00:00:00
 |  |  | 2021-09-27 18:02:00 | [NAME] | Subrina | [NAME] | 0 | 1 |  | -721 | 2021-09-27 00:00:00
 |  |  | 2021-09-01 13:15:00 | [NAME] | Talina | Duke | 0 | 3 |  | -1828 | 2021-09-01 00:00:00
 |  |  | 2021-09-02 10:37:00 | [NAME] | [NAME] | Watson | 0 | 4 |  | -12952 | 2021-09-02 00:00:00
 |  |  | 2021-09-07 12:42:00 | [NAME] | Tonie | [NAME] | 0 | 1 |  | -2047 | 2021-09-07 00:00:00
 |  |  | 2021-09-07 15:46:00 | [NAME] | [NAME] | Daniels | 0 | 10 |  | -11284 | 2021-09-07 00:00:00
 |  |  | 2021-09-13 10:58:00 | [NAME] | KAREN | TINDALL | 0 | 6 |  | -10897 | 2021-09-13 00:00:00
 |  |  | 2021-09-13 12:23:00 | [NAME] | Lyly | Lim | 0 | 1 |  | -1391.11 | 2021-09-13 00:00:00
 |  |  | 2021-09-15 10:01:00 | [NAME] | Charlotte | [NAME] | 0 | 1 |  | -1963 | 2021-09-15 00:00:00
 |  |  | 2021-09-15 12:50:00 | [NAME] | [NAME] | ATNIP | 0 | 1 |  | -9329 | 2021-09-15 00:00:00
 |  |  | 2021-09-17 11:40:00 | [NAME] | [NAME] | Schulman | 0 | 1 |  | -8061 | 2021-09-17 00:00:00
 |  |  | 2021-09-17 12:30:00 | [NAME] | [NAME] | Brett | 0 | 1 |  | -1169 | 2021-09-17 00:00:00
 |  |  | 2021-09-21 13:09:00 | [NAME] | Jasmine | Kelly | 0 | 7 |  | -17006 | 2021-09-21 00:00:00
 |  |  | 2021-09-21 15:10:00 | [NAME] | [NAME] | [NAME] | 0 | 3 |  | -3193 | 2021-09-21 00:00:00
 |  |  | 2021-09-21 16:50:00 | [NAME] | [NAME] | Goshien | 0 | 1 |  | -16111 | 2021-09-21 00:00:00
 |  |  | 2021-09-24 09:52:00 | [NAME] | Jessica | Lopez | 0 | 4 |  | -7448.83 | 2021-09-24 00:00:00
 |  |  | 2021-09-27 10:18:00 | [NAME] | [NAME] | Vu | 0 | 1 |  | -6809 | 2021-09-27 00:00:00
 |  |  | 2021-09-13 09:42:00 | [NAME] | [NAME] | Smith | 0 | 0 |  |  | 2021-09-13 00:00:00
 |  |  | 2021-09-20 10:01:00 | [NAME] | [NAME] | Mills | 0 | 1 |  | -5506 | 2021-09-20 00:00:00
 |  |  | 2021-09-20 10:04:00 | [NAME] | [NAME] | Mills | 1 | 1 | 1015.65 | -4490.35 | 2021-09-20 00:00:00
 |  |  | 2021-09-20 15:02:00 | [NAME] | Holly | Regan | 0 | 0 |  |  | 2021-09-20 00:00:00
 |  |  | 2021-09-21 09:21:00 | [NAME] | [NAME] | Randle | 0 | 2 |  | -4153 | 2021-09-21 00:00:00
 |  |  | 2021-09-22 12:29:00 | [NAME] | Kristie | [NAME] | 0 | 1 |  | -2775 | 2021-09-22 00:00:00
 |  |  | 2021-09-03 19:03:00 | Sage Roles | [NAME] | Norton | 0 | 2 |  | -12454 | 2021-09-03 00:00:00
 |  |  | 2021-09-07 18:17:00 | Sage Roles | Rachel | Ellis | 0 | 1 |  | -4052 | 2021-09-07 00:00:00
 |  |  | 2021-09-10 10:10:00 | Sage Roles | Bridgette | Cherwaty | 0 | 1 |  | -1784 | 2021-09-10 00:00:00
 |  |  | 2021-09-15 13:18:00 | Sage Roles | [NAME] | [NAME] | 0 | 14 |  | -28381 | 2021-09-15 00:00:00
 |  |  | 2021-09-24 17:27:00 | Sage Roles | Pam | McCune | 0 | 1 |  | -5574 | 2021-09-24 00:00:00
 |  |  | 2021-09-27 10:51:00 | Sage Roles | Zuleica | Correia | 0 | 1 |  | -11040 | 2021-09-27 00:00:00
 |  |  | 2021-09-08 12:42:00 | [NAME] | [NAME] | Roddy | 0 | 1 |  | -1361 | 2021-09-08 00:00:00
 |  |  | 2021-09-15 12:54:00 | [NAME] | [NAME] | Dailey | 0 | 1 |  | -8608.03 | 2021-09-15 00:00:00
 |  |  | 2021-09-20 11:04:00 | [NAME] | Rosalia | [NAME] | 0 | 0 |  | 0 | 2021-09-20 00:00:00
 |  |  | 2021-09-20 11:10:00 | [NAME] | Rosalia | [NAME] | 0 | 0 |  |  | 2021-09-20 00:00:00
 |  |  | 2021-09-20 11:45:00 | [NAME] | [NAME] | McGann | 0 | 2 |  | -13496 | 2021-09-20 00:00:00
 |  |  | 2021-09-21 13:05:00 | [NAME] | JENNIFER | [NAME] | 5 | 0 | 3259.1 | 3259.1 | 2021-09-21 00:00:00
 |  |  | 2021-09-22 12:52:00 | [NAME] | [NAME] | Moses | 0 | 1 |  | -4825 | 2021-09-22 00:00:00
 |  |  | 2021-09-14 13:56:00 | [NAME] | Veronica | Vergara | 0 | 3 |  | -24877.75 | 2021-09-14 00:00:00
 |  |  | 2021-09-15 10:58:00 | [NAME] | Beverly | McDonald | 0 | 1 |  | -3311 | 2021-09-15 00:00:00
 |  |  | 2021-09-20 13:52:00 | [NAME] | [NAME] | Holland | 0 | 1 |  | -15159 | 2021-09-20 00:00:00