[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 35 > < TAKE 8 >
8 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Munoz, Briana,23437 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Ramos, Jerome, L,29187 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Kumar, Yolanda, J,18194 | 85.96 | 0.00 | 0.00 | 0.00 | 85.96 |
| Mehta, Marie, L,29102 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Zhu, Jamie, J,13140 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Deng, Colin, B,18299 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Ruiz, Naomi,23649 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Guo, Ernest,25717 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
Generated 2025-12-22 01:08:40.472 UTC