[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 38 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| She, Melvin,16516 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Subram, Troy, R,19607 | 6054.22 | 0.00 | 3578.27 | 0.00 | 2475.95 |
| Munoz, Deanna,11054 | 8223.02 | 3399.99 | 0.00 | 2403.97 | 2419.06 |
| Moreno, Krista, J,16745 | 6021.62 | 3578.27 | 0.00 | 0.00 | 2443.35 |
| Travers, Danny,12587 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Lu, Jeffery, B,19971 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Jai, Jodi, M,27971 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
Generated 2025-12-21 06:19:26.211 UTC