[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 2 > < TAKE 6 >
6 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Vazquez, Mallory, M,18283 | 119.95 | 0.00 | 0.00 | 0.00 | 119.95 |
| Raji, Michele,15183 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Zeng, Warren, R,24477 | 3302.05 | 0.00 | 0.00 | 2181.56 | 1120.49 |
| Lin, Rafael,14099 | 200.26 | 0.00 | 0.00 | 0.00 | 200.26 |
| Raje, Dale, H,27746 | 628.97 | 0.00 | 0.00 | 0.00 | 628.97 |
| Raje, Lacey, T,12358 | 6787.76 | 0.00 | 2071.42 | 0.00 | 4716.34 |
Generated 2025-12-21 20:25:30.448 UTC