[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Yang, Warren, F,17908 | 35.72 | 0.00 | 0.00 | 35.72 | 0.00 |
| Serrano, Jésus, B,12991 | 5641.90 | 0.00 | 2049.10 | 1237.82 | 2354.98 |
| Andersen, Ashlee, J,11059 | 116.93 | 0.00 | 0.00 | 116.93 | 0.00 |
| Vazquez, Latasha,21952 | 99.47 | 0.00 | 0.00 | 99.47 | 0.00 |
| Hayes, Alexis,13048 | 190.23 | 0.00 | 0.00 | 111.25 | 78.98 |
| Saunders, Patricia, J,19565 | 5308.24 | 0.00 | 3578.27 | 1729.97 | 0.00 |
| Zhang, Damien, C,26758 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Hill, Adam,18740 | 6056.61 | 3578.27 | 0.00 | 2478.34 | 0.00 |
| Rana, Carla, K,19593 | 5306.54 | 0.00 | 3578.27 | 1728.27 | 0.00 |
| Raman, Harold, F,28484 | 778.62 | 0.00 | 0.00 | 778.62 | 0.00 |
| Luo, Warren,23562 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Sanchez, Francisco, D,21172 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Liu, Clayton, L,21373 | 15.23 | 0.00 | 0.00 | 15.23 | 0.00 |
| Raman, Candace, M,11766 | 8280.48 | 0.00 | 3399.99 | 2419.46 | 2461.03 |
| Gutierrez, Meredith, T,11111 | 8137.00 | 3399.99 | 0.00 | 2318.96 | 2418.05 |
Generated 2026-07-22 16:49:30.074 UTC