[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 13 > < TAKE 6 >
6 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| She, Clarence, L,24901 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Jai, Maurice,22932 | 4169.33 | 0.00 | 0.00 | 4169.33 | 0.00 |
| He, Eugene, L,13645 | 6817.12 | 0.00 | 0.00 | 2049.10 | 4768.02 |
| Vazquez, Victor, R,29453 | 742.35 | 0.00 | 0.00 | 0.00 | 742.35 |
| Zhao, Jaclyn, D,26167 | 1903.48 | 0.00 | 0.00 | 782.99 | 1120.49 |
| Thompson, Justin,22954 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
Generated 2025-12-22 00:52:53.712 UTC