[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 9 > < TAKE 56 >
56 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ross, Caleb,20305 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Garcia, Ethan,14738 | 1503.58 | 0.00 | 699.10 | 0.00 | 804.48 |
| Madan, Arthur, D,16408 | 4692.88 | 0.00 | 0.00 | 2181.56 | 2511.32 |
| Chande, Bridget, E,12379 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Carlson, Mallory, A,19281 | 67.97 | 0.00 | 0.00 | 0.00 | 67.97 |
| Flores, Jonathan, H,28615 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Pal, Tommy,13840 | 3010.03 | 0.00 | 0.00 | 2181.56 | 828.47 |
| Pal, Jaclyn,19076 | 3177.96 | 0.00 | 0.00 | 782.99 | 2394.97 |
| Nelson, Angel,24279 | 79.47 | 0.00 | 0.00 | 0.00 | 79.47 |
| Liang, Edwin, W,12327 | 13.98 | 0.00 | 0.00 | 8.99 | 4.99 |
| Jenkins, Haley, L,22337 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Chavez, Jon,13786 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Navarro, Brandi,25535 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Stewart, Sydney,18097 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rivera, Jeremy,16978 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yang, Jack, A,26103 | 32.27 | 0.00 | 0.00 | 0.00 | 32.27 |
| Vazquez, Kristy, L,14550 | 48.97 | 0.00 | 0.00 | 0.00 | 48.97 |
| Malhotra, Tammy, C,22479 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Miller, Seth,20543 | 2492.32 | 0.00 | 0.00 | 0.00 | 2492.32 |
| Sharma, Jordan, R,17393 | 2404.91 | 0.00 | 0.00 | 0.00 | 2404.91 |
| Russell, Blake, A,20657 | 1193.45 | 0.00 | 0.00 | 0.00 | 1193.45 |
| Peterson, Mariah,17432 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Phillips, Mackenzie,12444 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Allen, Bailey, F,27218 | 6.28 | 0.00 | 0.00 | 0.00 | 6.28 |
| Torres, Gabrielle, T,21417 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Rogers, Mariah, K,23851 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Ramos, Renee, K,18005 | 5804.87 | 0.00 | 0.00 | 2181.56 | 3623.31 |
| Vazquez, Reginald,24406 | 195.59 | 0.00 | 0.00 | 0.00 | 195.59 |
| Turner, Edward, S,20474 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Davis, Kayla,16381 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Williams, Grace,28653 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Robinson, Jessica,20012 | 554.97 | 0.00 | 0.00 | 0.00 | 554.97 |
| Diaz, Connor,21623 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Bryant, Jordyn,12766 | 4417.73 | 0.00 | 3578.27 | 0.00 | 839.46 |
| Moreno, Lawrence,24798 | 2407.04 | 0.00 | 0.00 | 0.00 | 2407.04 |
| Chapman, Bryant, G,24404 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Hayes, Melanie, G,25099 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Cooper, Taylor,22105 | 45.22 | 0.00 | 0.00 | 0.00 | 45.22 |
| Lal, Kelvin,15082 | 7068.08 | 0.00 | 0.00 | 2181.56 | 4886.52 |
| Sharma, Jose, R,13244 | 81.46 | 0.00 | 0.00 | 0.00 | 81.46 |
| Parker, Hailey, J,14402 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Tang, Raul,22466 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Jenkins, Cassidy, L,22482 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Wright, Edward,22744 | 54.21 | 0.00 | 0.00 | 0.00 | 54.21 |
| Wilson, Samantha,28229 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Brown, John,20637 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| Martinez, Emily, F,17864 | 1750.98 | 0.00 | 0.00 | 0.00 | 1750.98 |
| Navarro, Paula,28736 | 2071.42 | 0.00 | 0.00 | 2071.42 | 0.00 |
| Walker, Richard, T,19640 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Huang, Laura, P,18185 | 3332.39 | 0.00 | 0.00 | 1000.44 | 2331.95 |
| Roberts, Gabriel, R,28612 | 8.99 | 0.00 | 0.00 | 0.00 | 8.99 |
| Sanchez, Johnathan,24411 | 71.58 | 0.00 | 0.00 | 0.00 | 71.58 |
| Raji, Peter, L,19162 | 563.96 | 0.00 | 0.00 | 0.00 | 563.96 |
| Bryant, Caroline, L,29136 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Murphy, Bryan, L,29127 | 28.98 | 0.00 | 0.00 | 0.00 | 28.98 |
| Brooks, Maria,20422 | 1134.47 | 0.00 | 0.00 | 0.00 | 1134.47 |
Generated 2025-12-23 05:35:14.008 UTC