[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 68 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Simmons, Olivia, Z,21689 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Lal, James, M,26241 | 3320.25 | 0.00 | 2071.42 | 0.00 | 1248.83 |
| Nath, Kathryn,28632 | 74.98 | 0.00 | 0.00 | 0.00 | 74.98 |
| Huang, Louis, L,23778 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Clark, Blake,21269 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Shan, Caleb, A,15467 | 1631.46 | 0.00 | 0.00 | 782.99 | 848.47 |
| Cook, Morgan, G,19403 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
Generated 2025-12-23 12:19:29.528 UTC