[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > 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 | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Jimenez, Gary, E,16609 | 344.04 | 0.00 | 0.00 | 344.04 | 0.00 |
| Raji, Michele,15183 | 4368.70 | 0.00 | 0.00 | 2071.42 | 2297.28 |
| Sai, Ann,27339 | 1336.96 | 0.00 | 0.00 | 1336.96 | 0.00 |
| Andersen, Tonya, N,13527 | 4529.04 | 0.00 | 2049.10 | 0.00 | 2479.94 |
| Ruiz, Julio,11005 | 8121.33 | 3374.99 | 0.00 | 4746.34 | 0.00 |
| Long, Emily, L,26140 | 1917.46 | 0.00 | 782.99 | 0.00 | 1134.47 |
| Lu, Curtis,11011 | 8133.04 | 3399.99 | 0.00 | 4733.05 | 0.00 |
| Xu, Martha, C,16351 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Raje, Devon,29289 | 2433.04 | 0.00 | 0.00 | 2433.04 | 0.00 |
| Garcia, Ivan, L,17354 | 6029.57 | 3578.27 | 0.00 | 0.00 | 2451.30 |
| Sharma, Terrence, N,17351 | 6117.69 | 3578.27 | 0.00 | 0.00 | 2539.42 |
| Gutierrez, Jonathon, R,16529 | 4752.75 | 3578.27 | 0.00 | 1174.48 | 0.00 |
| Jai, Bonnie,11977 | 8212.50 | 0.00 | 3399.99 | 2350.96 | 2461.55 |
| Munoz, Cheryl, C,13632 | 6838.46 | 0.00 | 0.00 | 2071.42 | 4767.04 |
| Malhotra, Mayra, E,15577 | 143.45 | 0.00 | 0.00 | 83.97 | 59.48 |
Generated 2026-07-22 11:34:36.578 UTC