[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 953 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Yuan, Colin,11758 | 58.05 | 0.00 | 0.00 | 0.00 | 58.05 |
| Chandra, Veronica,14681 | 5178.40 | 0.00 | 0.00 | 2049.10 | 3129.30 |
| Chapman, Patricia,12037 | 7107.10 | 0.00 | 3374.99 | 0.00 | 3732.11 |
| Kumar, Katie, P,12341 | 6840.62 | 0.00 | 2049.10 | 0.00 | 4791.52 |
| Martin, Tabitha,25269 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Kapoor, Troy, E,24610 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| He, Aimee, A,11093 | 8180.00 | 0.00 | 3399.99 | 2360.95 | 2419.06 |
Generated 2025-12-23 11:57:24.790 UTC