[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 343 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| White, Taylor, D,25011 | 1589.40 | 0.00 | 0.00 | 1000.44 | 588.96 |
| Yuan, Terry, R,13646 | 6843.60 | 0.00 | 0.00 | 2049.10 | 4794.50 |
| Sharma, Kelvin, D,26655 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Alvarez, Carrie, W,23410 | 4016.53 | 0.00 | 0.00 | 2181.56 | 1834.97 |
| Zhu, Dawn,26661 | 1912.47 | 0.00 | 0.00 | 782.99 | 1129.48 |
| Gray, Jeremiah,23331 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Sharma, Arturo,13648 | 6765.44 | 0.00 | 0.00 | 2049.10 | 4716.34 |
Generated 2025-12-24 06:18:01.480 UTC