[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'GBP' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 31 > TITLE Top 1000 Australian Internet customers for 2020
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Wright, Amber, L,23924 | 1129.48 | 0.00 | 0.00 | 0.00 | 1129.48 |
| Nara, Roger,26928 | 597.95 | 0.00 | 0.00 | 0.00 | 597.95 |
| Pal, Corey,25774 | 2537.32 | 0.00 | 0.00 | 0.00 | 2537.32 |
| Alonso, Roberto, M,14533 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Collins, Richard, S,16256 | 81.96 | 0.00 | 0.00 | 0.00 | 81.96 |
| He, Cedric, W,25298 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Gutierrez, Daisy,21541 | 149.98 | 0.00 | 0.00 | 0.00 | 149.98 |
| Morgan, Lauren,24217 | 1209.47 | 0.00 | 0.00 | 0.00 | 1209.47 |
| Shen, Carl, L,19190 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Deng, Dustin, F,11422 | 7075.27 | 0.00 | 3399.99 | 2334.98 | 1340.30 |
| Black, Shawn, A,19499 | 3492.76 | 0.00 | 0.00 | 3492.76 | 0.00 |
| Robinson, Nicole,28730 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Smith, Hunter, L,21507 | 24.99 | 0.00 | 0.00 | 24.99 | 0.00 |
| Green, Luke, R,28392 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Pal, Cedric,23235 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Pal, Rafael, J,17715 | 2831.53 | 0.00 | 0.00 | 2831.53 | 0.00 |
| Gray, Devin,16584 | 172.95 | 0.00 | 0.00 | 39.98 | 132.97 |
| Munoz, Roberto,17628 | 106.24 | 0.00 | 0.00 | 7.28 | 98.96 |
| Serrano, Tanya,23750 | 1155.48 | 0.00 | 0.00 | 1155.48 | 0.00 |
| Diaz, Janet, R,25626 | 548.98 | 0.00 | 0.00 | 548.98 | 0.00 |
| Alvarez, Robin, V,11243 | 7164.25 | 3399.99 | 0.00 | 3175.30 | 588.96 |
| Patel, Heidi, R,23225 | 1184.46 | 0.00 | 0.00 | 1184.46 | 0.00 |
| Lin, Lacey,13815 | 114.55 | 0.00 | 0.00 | 33.98 | 80.57 |
| Gonzalez, Preston, L,14156 | 229.57 | 0.00 | 0.00 | 33.98 | 195.59 |
| She, Kelvin, T,27002 | 38.98 | 0.00 | 0.00 | 38.98 | 0.00 |
| Luo, Kara,28903 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Suri, Marco,16454 | 47.26 | 0.00 | 0.00 | 39.98 | 7.28 |
| Ortega, Beth, A,12277 | 5666.52 | 0.00 | 0.00 | 3309.24 | 2357.28 |
| Sai, Adriana, A,16405 | 3262.83 | 0.00 | 2443.35 | 819.48 | 0.00 |
| Vazquez, Stacy,22559 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Ye, Stacey,12568 | 67.46 | 0.00 | 0.00 | 67.46 | 0.00 |
Generated 2025-11-06 11:09:45.094 UTC