[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 15 > TITLE Top 1000 Australian Internet customers for 2020
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chen, Tamara,12382 | 5606.26 | 0.00 | 0.00 | 2071.42 | 3534.84 |
| Diaz, Neil, C,18181 | 185.92 | 0.00 | 0.00 | 0.00 | 185.92 |
| Yuan, Barbara,21515 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Sharma, Barbara, D,22421 | 58.98 | 0.00 | 0.00 | 0.00 | 58.98 |
| Rodriguez, Matthew,22629 | 59.98 | 0.00 | 0.00 | 0.00 | 59.98 |
| Sanz, Natasha,14839 | 156.25 | 0.00 | 0.00 | 0.00 | 156.25 |
| Malhotra, Dominique,12460 | 5678.91 | 0.00 | 0.00 | 2049.10 | 3629.81 |
| Fernandez, Dominique,12839 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Prasad, Cynthia, L,14808 | 164.20 | 0.00 | 0.00 | 0.00 | 164.20 |
| Torres, Audrey,16571 | 52.92 | 0.00 | 0.00 | 0.00 | 52.92 |
| Alonso, Briana,21830 | 539.99 | 0.00 | 0.00 | 0.00 | 539.99 |
| Collins, Richard, S,16256 | 81.96 | 0.00 | 0.00 | 0.00 | 81.96 |
| Munoz, Rodney,12836 | 68.46 | 0.00 | 0.00 | 0.00 | 68.46 |
| Serrano, Jill,24026 | 1212.97 | 0.00 | 0.00 | 0.00 | 1212.97 |
| Diaz, Philip, J,12855 | 4414.34 | 0.00 | 0.00 | 2071.42 | 2342.92 |
Generated 2025-11-04 15:00:59.768 UTC