[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 9 > < TAKE 28 >
28 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Walker, Noah, E,20009 | 1184.46 | 0.00 | 0.00 | 0.00 | 1184.46 |
| Flores, Kayla, O,28574 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Kapoor, Toni, K,26295 | 3298.94 | 0.00 | 0.00 | 2049.10 | 1249.84 |
| Jenkins, Alexis,28294 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Patterson, Elijah, A,26070 | 5768.05 | 0.00 | 3374.99 | 0.00 | 2393.06 |
| Gomez, Julio, E,23771 | 82.95 | 0.00 | 0.00 | 0.00 | 82.95 |
| Guo, Mandy,17018 | 93.97 | 0.00 | 0.00 | 0.00 | 93.97 |
| Ward, Jeremy, D,24951 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Lewis, Anthony,18672 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Perez, Marcus,20786 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Carlson, Randall, T,13829 | 801.77 | 0.00 | 0.00 | 0.00 | 801.77 |
| Chande, Cristina,26233 | 48.97 | 0.00 | 0.00 | 48.97 | 0.00 |
| Diaz, Ebony,17845 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Deng, Katrina,28277 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Wang, Jack, L,17152 | 12.94 | 0.00 | 0.00 | 0.00 | 12.94 |
| Howard, Nathaniel, C,15502 | 1587.47 | 0.00 | 0.00 | 782.99 | 804.48 |
| Gutierrez, Sheila,18405 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Campbell, Mackenzie, T,11696 | 5873.26 | 0.00 | 3578.27 | 0.00 | 2294.99 |
| Brown, Nicholas, S,11506 | 72.96 | 0.00 | 0.00 | 0.00 | 72.96 |
| Alvarez, Naomi,28820 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Arun, Edgar,20298 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Carlson, Paula, M,13292 | 4478.84 | 0.00 | 0.00 | 2181.56 | 2297.28 |
| Sanchez, Devin, J,14369 | 46.47 | 0.00 | 0.00 | 0.00 | 46.47 |
| Chapman, Nancy, E,11276 | 148.17 | 0.00 | 0.00 | 0.00 | 148.17 |
| Evans, Haley,18584 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Yang, Zachary, F,14726 | 1483.57 | 0.00 | 699.10 | 0.00 | 784.47 |
| Dominguez, Frank, M,15049 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Patterson, Angela,21619 | 556.26 | 0.00 | 0.00 | 0.00 | 556.26 |
Generated 2025-12-21 23:16:46.301 UTC