[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Zhao, Susan, L,25122 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nara, Lindsay, M,25247 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cai, Vincent, L,11757 | 58.05 | 0.00 | 0.00 | 24.49 | 33.56 |
| Shen, Katrina,15801 | 4381.38 | 0.00 | 0.00 | 2049.10 | 2332.28 |
| Luo, Mario, L,25711 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Gutierrez, Darren, A,25714 | 1308.06 | 0.00 | 699.10 | 0.00 | 608.96 |
| Luo, Roger, J,18728 | 56.71 | 0.00 | 0.00 | 0.00 | 56.71 |
Generated 2026-07-22 18:56:23.483 UTC