[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 219 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Shan, Jordan, C,16207 | 7226.37 | 0.00 | 0.00 | 2443.35 | 4783.02 |
| Watson, Zoe, W,26515 | 89.46 | 0.00 | 0.00 | 0.00 | 89.46 |
| Vazquez, Micheal,25258 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Pal, Edwin, M,13573 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Martinez, Kaitlyn, S,20072 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Vazquez, Tanya,27167 | 1203.46 | 0.00 | 0.00 | 0.00 | 1203.46 |
| Hall, Aaron, K,27246 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Saunders, Brenda, Q,27954 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Shan, Leonard, E,25617 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Cooper, Melanie, A,23034 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Gonzalez, Marcus, A,27754 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Simmons, Melanie, T,24449 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Mr., Lee, Blake, D,24677 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| James, Cole, S,20411 | 69.47 | 0.00 | 0.00 | 0.00 | 69.47 |
| Edwards, Jordan, R,16107 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
Generated 2025-12-23 12:09:33.170 UTC