[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 57 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Kapoor, Candace,18282 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
| Anand, Bradley,19626 | 39.46 | 0.00 | 0.00 | 0.00 | 39.46 |
| Navarro, Dana, J,11125 | 79.69 | 0.00 | 0.00 | 7.95 | 71.74 |
| Carter, Sophia, D,25230 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
| Martin, Reginald,14054 | 210.77 | 0.00 | 0.00 | 0.00 | 210.77 |
| Rana, Meredith,25032 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Alvarez, Pedro, E,28120 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
Generated 2025-12-21 21:19:51.670 UTC