[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 65 > < TAKE 24 >
24 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Alonso, Theresa,25155 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Yanagishima, Daisuke,26011 | 5768.05 | 0.00 | 3374.99 | 0.00 | 2393.06 |
| Anderson, Zachary,11324 | 5945.23 | 0.00 | 3578.27 | 0.00 | 2366.96 |
| Sanchez, Molly,14811 | 36.93 | 0.00 | 0.00 | 0.00 | 36.93 |
| Wang, Christian,27226 | 2049.10 | 0.00 | 0.00 | 2049.10 | 0.00 |
| Rai, Kenneth, S,13207 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
| Rogers, Jeremy, G,19323 | 1584.76 | 0.00 | 0.00 | 782.99 | 801.77 |
| Diaz, Meghan, J,14714 | 5386.28 | 0.00 | 0.00 | 2443.35 | 2942.93 |
| Morgan, Grace, E,25601 | 583.97 | 0.00 | 0.00 | 0.00 | 583.97 |
| Turner, Kyle, C,26835 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Beck, Alvin,19314 | 2730.41 | 0.00 | 0.00 | 1000.44 | 1729.97 |
| Moreno, Desirée, E,24479 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Price, Edward,21438 | 561.48 | 0.00 | 0.00 | 561.48 | 0.00 |
| Johnson, Ashley, S,14411 | 3360.42 | 0.00 | 0.00 | 1000.44 | 2359.98 |
| Walker, James, C,12108 | 5946.20 | 0.00 | 3578.27 | 0.00 | 2367.93 |
| Hill, Robert, L,12935 | 4794.31 | 0.00 | 2443.35 | 0.00 | 2350.96 |
| Lopez, Blake, R,21444 | 22.93 | 0.00 | 0.00 | 0.00 | 22.93 |
| Cox, Jan, D,26781 | 110.46 | 0.00 | 0.00 | 0.00 | 110.46 |
| Rodriguez, Olivia, A,15285 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Bailey, Jessica, L,12945 | 102.95 | 0.00 | 0.00 | 0.00 | 102.95 |
| Huang, Jaclyn,18148 | 1518.58 | 0.00 | 699.10 | 0.00 | 819.48 |
| Guo, Jeffery, C,20926 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Sanders, Garrett,13737 | 39.25 | 0.00 | 0.00 | 0.00 | 39.25 |
| Patterson, Elizabeth, E,13322 | 85.48 | 0.00 | 0.00 | 0.00 | 85.48 |
Generated 2025-12-24 05:59:52.305 UTC