[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1173 > < TAKE 7 >
7 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gomez, Hector, A,29337 | 49.99 | 0.00 | 0.00 | 0.00 | 49.99 |
| Nara, Tony, L,16713 | 6090.59 | 0.00 | 3578.27 | 0.00 | 2512.32 |
| Sanz, Kari, V,27341 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Romero, Paula, B,16691 | 4471.74 | 0.00 | 3578.27 | 0.00 | 893.47 |
| Suarez, Renee, L,12703 | 6891.12 | 0.00 | 0.00 | 2049.10 | 4842.02 |
| Raje, Carly, J,15576 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Li, Barbara,15788 | 4443.38 | 0.00 | 0.00 | 2071.42 | 2371.96 |
Generated 2025-12-23 11:53:17.011 UTC