[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 15 > TITLE Top 1000 Australian Internet customers for 2020
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Dominguez, Darren, M,13966 | 6842.12 | 0.00 | 0.00 | 2049.10 | 4793.02 |
| Ferrier, Leslie, M,28535 | 2433.04 | 0.00 | 0.00 | 2433.04 | 0.00 |
| Nara, Ricardo,28934 | 64.47 | 0.00 | 0.00 | 0.00 | 64.47 |
| Van, Brenda, J,24890 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Zhu, Jorge,26141 | 78.98 | 0.00 | 0.00 | 78.98 | 0.00 |
| Prasad, Gerald, B,12035 | 81.24 | 0.00 | 0.00 | 81.24 | 0.00 |
| Rai, Karl, M,25273 | 1898.07 | 699.10 | 0.00 | 0.00 | 1198.97 |
| Rubio, Juan,16170 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Romero, Roberto, A,18285 | 141.55 | 0.00 | 0.00 | 69.97 | 71.58 |
| Shen, Rafael, J,16689 | 290.46 | 0.00 | 0.00 | 0.00 | 290.46 |
| Alonso, Teresa,13138 | 83.97 | 0.00 | 0.00 | 58.98 | 24.99 |
| Saunders, Brandy,11946 | 4697.31 | 0.00 | 3399.99 | 554.97 | 742.35 |
| Munoz, Monique,24008 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Dominguez, Philip,15730 | 122.96 | 0.00 | 0.00 | 0.00 | 122.96 |
| Ramos, Jaime,15720 | 70.22 | 0.00 | 0.00 | 35.23 | 34.99 |
Generated 2026-07-22 15:40:56.915 UTC