[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 |
|---|---|---|---|---|---|
| Subram, Kari,12682 | 227.96 | 0.00 | 0.00 | 68.96 | 159.00 |
| Andersen, Calvin,22920 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| Raman, Deanna, H,17053 | 123.96 | 0.00 | 0.00 | 69.97 | 53.99 |
| Kapoor, Pedro, H,24229 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Ruiz, Adrienne,13523 | 67.26 | 0.00 | 0.00 | 67.26 | 0.00 |
| Pal, Arturo, P,29303 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Sai, Rachael,11912 | 8095.32 | 0.00 | 3374.99 | 2319.99 | 2400.34 |
| Hill, James, S,29317 | 2438.06 | 0.00 | 0.00 | 2438.06 | 0.00 |
| Zhou, Trisha, B,12686 | 6864.46 | 0.00 | 2071.42 | 2354.98 | 2438.06 |
| Gutierrez, Lawrence, M,19564 | 5293.24 | 0.00 | 3578.27 | 1714.97 | 0.00 |
| Goel, Alejandro, K,13077 | 6766.63 | 0.00 | 2049.10 | 2294.99 | 2422.54 |
| Andersen, Warren,11919 | 8171.52 | 0.00 | 3374.99 | 2334.98 | 2461.55 |
| Pal, Tasha,22853 | 39.99 | 0.00 | 0.00 | 39.99 | 0.00 |
| Ye, Leah,11077 | 8169.03 | 3374.99 | 0.00 | 4794.04 | 0.00 |
| Mehta, Brett,11450 | 8173.26 | 3374.99 | 0.00 | 4798.27 | 0.00 |
Generated 2026-07-22 07:12:36.629 UTC