[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 24 > < TAKE 6 >
6 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Shen, Kelsey, R,22921 | 4647.88 | 0.00 | 0.00 | 2181.56 | 2466.32 |
| Chandra, Andre, L,25262 | 35.72 | 0.00 | 0.00 | 0.00 | 35.72 |
| Tang, Nina,27485 | 1354.71 | 0.00 | 0.00 | 782.99 | 571.72 |
| Ferrier, Linda, D,13149 | 64.97 | 0.00 | 0.00 | 0.00 | 64.97 |
| Shan, Drew,23659 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Gomez, Armando, S,21175 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
Generated 2025-12-22 05:08:52.016 UTC