[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 36 > < TAKE 6 >
6 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sun, Suzanne, P,24587 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Raman, Allen, R,25129 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Garcia, Andre, H,12705 | 6854.11 | 0.00 | 0.00 | 2049.10 | 4805.01 |
| Alvarez, Larry, T,14235 | 5682.20 | 0.00 | 0.00 | 2071.42 | 3610.78 |
| Raje, Wayne, A,21372 | 74.96 | 0.00 | 0.00 | 0.00 | 74.96 |
| Shan, Shawna, K,27869 | 2462.55 | 0.00 | 0.00 | 0.00 | 2462.55 |
Generated 2025-12-21 13:34:49.510 UTC