[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 219 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|---|
| Perry, Alexia, J,11792 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 | 0.00 |
| Miller, Tyler, E,11940 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 | 0.00 |
| Jai, Barbara, K,11782 | 151.75 | 0.00 | 0.00 | 0.00 | 151.75 | 0.00 |
| Wang, Brent,20274 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 | 0.00 |
| Lewis, Samuel, H,17155 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 | 0.00 |
| Chen, Leah, E,16577 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 | 0.00 |
| Cox, Grace,14649 | 1601.56 | 0.00 | 699.10 | 0.00 | 902.46 | 0.00 |
| Morris, Timothy, M,18111 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 | 0.00 |
| Hall, Mackenzie, A,20146 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 | 0.00 |
| Sanchez, Douglas, M,25521 | 30.48 | 0.00 | 0.00 | 0.00 | 30.48 | 0.00 |
| Subram, Janelle,25672 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 | 0.00 |
| Lal, Jose,11819 | 96.27 | 0.00 | 0.00 | 0.00 | 96.27 | 0.00 |
| Diaz, Alexia,22281 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 | 0.00 |
| Harris, James, M,25064 | 2447.05 | 0.00 | 0.00 | 0.00 | 2447.05 | 0.00 |
Generated 2026-01-04 05:40:27.307 UTC