[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 30 > TITLE Top 1000 Australian Internet customers for 2020
30 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Wang, Martha, D,24272 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Chander, Melvin, L,24266 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| Murphy, Seth, A,25704 | 1239.09 | 699.10 | 0.00 | 0.00 | 539.99 |
| He, Gilbert,15589 | 4416.38 | 0.00 | 0.00 | 2071.42 | 2344.96 |
| Navarro, Stacy, C,12688 | 6867.44 | 0.00 | 2071.42 | 2376.96 | 2419.06 |
| Edwards, Evan, L,21888 | 4925.58 | 0.00 | 2443.35 | 0.00 | 2482.23 |
| Li, David, A,21894 | 4624.91 | 0.00 | 2181.56 | 0.00 | 2443.35 |
| Rubio, Philip, P,21876 | 4663.38 | 0.00 | 2181.56 | 0.00 | 2481.82 |
| Suarez, Renee, L,12703 | 6891.12 | 0.00 | 2049.10 | 2448.96 | 2393.06 |
| Coleman, Paige, L,15263 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Chander, Lindsay, R,19972 | 49.70 | 0.00 | 0.00 | 0.00 | 49.70 |
| Yuan, Bradley,17920 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Chen, Crystal, M,26566 | 2016.95 | 0.00 | 782.99 | 0.00 | 1233.96 |
| Patel, Arthur, B,26671 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Serrano, Natasha,25563 | 1239.09 | 699.10 | 0.00 | 0.00 | 539.99 |
| Blanco, Krista, L,27580 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Guo, Cara, R,15721 | 118.96 | 0.00 | 0.00 | 83.97 | 34.99 |
| Dominguez, Neil, K,23663 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Carlson, Jill,21886 | 4696.49 | 0.00 | 2181.56 | 0.00 | 2514.93 |
| Madan, Roy,15716 | 4467.06 | 0.00 | 0.00 | 2049.10 | 2417.96 |
| Goel, Carly, C,12989 | 6817.12 | 0.00 | 2049.10 | 2369.97 | 2398.05 |
| Johnson, Sydney,19571 | 90.95 | 0.00 | 0.00 | 33.98 | 56.97 |
| Raman, Veronica, R,12359 | 95.74 | 0.00 | 0.00 | 0.00 | 95.74 |
| Jimenez, Jill,11028 | 6474.62 | 3374.99 | 0.00 | 2357.28 | 742.35 |
| Lopez, Summer,12036 | 69.55 | 0.00 | 0.00 | 29.57 | 39.98 |
| Martinez, Virginia,13136 | 62.27 | 0.00 | 0.00 | 27.28 | 34.99 |
| Serrano, Deanna, W,15144 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| White, Taylor, D,25011 | 1589.40 | 0.00 | 0.00 | 1000.44 | 588.96 |
| Jai, Melvin, M,27722 | 564.21 | 0.00 | 0.00 | 0.00 | 564.21 |
| Xu, Kelvin,18305 | 160.55 | 0.00 | 0.00 | 36.59 | 123.96 |
Generated 2026-07-22 20:45:50.153 UTC