[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 54 > < TAKE 6 >
6 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Kumar, Jaime, O,29061 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Chapman, Pamela, L,27145 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Shan, Bethany, L,13973 | 5185.68 | 0.00 | 0.00 | 2071.42 | 3114.26 |
| Sharma, Bonnie, R,25562 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Collins, Andrea,12250 | 3964.98 | 0.00 | 3399.99 | 0.00 | 564.99 |
| Lu, Glenn,12692 | 156.26 | 0.00 | 0.00 | 0.00 | 156.26 |
Generated 2025-12-24 06:40:08.024 UTC