[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 251 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Mr., Solanki, Ajay,18295 | 144.27 | 0.00 | 0.00 | 0.00 | 144.27 |
| Vazquez, Marvin, K,21953 | 35.00 | 0.00 | 0.00 | 0.00 | 35.00 |
| Sanz, Walter, J,18195 | 94.47 | 0.00 | 0.00 | 0.00 | 94.47 |
| Deng, Grant, C,16625 | 81.81 | 0.00 | 0.00 | 0.00 | 81.81 |
| Prasad, Ross,28963 | 2398.05 | 0.00 | 0.00 | 0.00 | 2398.05 |
| Sara, Marco, L,15641 | 96.75 | 0.00 | 0.00 | 0.00 | 96.75 |
| Madan, Bruce, G,18206 | 65.96 | 0.00 | 0.00 | 0.00 | 65.96 |
| Deng, Tracy, E,21978 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Prasad, Dominic, D,19962 | 46.75 | 0.00 | 0.00 | 0.00 | 46.75 |
| Madan, Kristi, I,29184 | 2420.34 | 0.00 | 0.00 | 0.00 | 2420.34 |
| Malhotra, Pedro,21559 | 4900.68 | 0.00 | 0.00 | 2443.35 | 2457.33 |
| Nara, Dale, L,21226 | 4659.80 | 0.00 | 0.00 | 2181.56 | 2478.24 |
| Zhu, Candice, S,21219 | 4696.49 | 0.00 | 0.00 | 2181.56 | 2514.93 |
| Lal, Kate,21557 | 4886.70 | 0.00 | 0.00 | 2443.35 | 2443.35 |
| Fernandez, Kristina, A,12581 | 2646.40 | 0.00 | 0.00 | 2071.42 | 574.98 |
Generated 2025-12-23 06:55:46.173 UTC