[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 62 > TITLE Top 1000 Australian Internet customers for 2020
62 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Ortega, Joanna,17909 | 4761.74 | 3578.27 | 0.00 | 0.00 | 1183.47 |
| Raje, Grant, S,24162 | 3004.83 | 0.00 | 0.00 | 2443.35 | 561.48 |
| Yuan, Keith, N,22926 | 3936.54 | 0.00 | 2181.56 | 0.00 | 1754.98 |
| Mehta, Chelsea,22951 | 4242.31 | 0.00 | 2443.35 | 1798.96 | 0.00 |
| Diaz, Briana,13131 | 6737.15 | 0.00 | 2049.10 | 0.00 | 4688.05 |
| Sanz, Jamie,26549 | 1361.45 | 0.00 | 782.99 | 0.00 | 578.46 |
| Wu, Clarence, L,13115 | 6779.42 | 0.00 | 2049.10 | 0.00 | 4730.32 |
| Foster, Lucas,13519 | 4492.45 | 0.00 | 2049.10 | 2443.35 | 0.00 |
| Long, Isabelle, W,23104 | 3490.03 | 0.00 | 2181.56 | 1308.47 | 0.00 |
| Raman, Brett, L,22930 | 4900.68 | 0.00 | 2443.35 | 0.00 | 2457.33 |
| Baker, Jose, A,22937 | 4179.33 | 0.00 | 2443.35 | 0.00 | 1735.98 |
| West, Colleen, C,13128 | 6817.14 | 0.00 | 2049.10 | 0.00 | 4768.04 |
| Garcia, Martin, l,23332 | 4144.34 | 0.00 | 2443.35 | 1700.99 | 0.00 |
| Arun, Brenda,13630 | 6824.73 | 0.00 | 2071.42 | 0.00 | 4753.31 |
| Perez, Ivan, S,23408 | 4218.82 | 0.00 | 2443.35 | 1775.47 | 0.00 |
| Lin, Damien, L,23414 | 3391.03 | 0.00 | 2181.56 | 1209.47 | 0.00 |
| Zhang, Glenn, A,13967 | 5721.91 | 0.00 | 2049.10 | 0.00 | 3672.81 |
| Moreno, Dwayne, T,23103 | 85.48 | 0.00 | 0.00 | 85.48 | 0.00 |
| Raje, Raul, L,26785 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Guo, Leah, R,19562 | 5314.25 | 0.00 | 3578.27 | 1735.98 | 0.00 |
| Alvarez, Stacy,11901 | 8248.01 | 0.00 | 3399.99 | 2374.98 | 2473.04 |
| Anand, Tamara,29088 | 756.33 | 0.00 | 0.00 | 0.00 | 756.33 |
| Zhao, Bianca,13971 | 6772.13 | 0.00 | 0.00 | 2049.10 | 4723.03 |
| Zeng, Ernest, M,12992 | 158.51 | 0.00 | 0.00 | 36.27 | 122.24 |
| Hughes, Lucas, E,26657 | 1357.97 | 0.00 | 782.99 | 574.98 | 0.00 |
| Allen, Kaylee,26653 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Munoz, Theresa, M,13953 | 6840.75 | 0.00 | 0.00 | 2071.42 | 4769.33 |
| Rodriguez, Jarrod,13636 | 6831.76 | 0.00 | 0.00 | 2071.42 | 4760.34 |
| Dominguez, Kristi, M,13644 | 6864.46 | 0.00 | 0.00 | 2071.42 | 4793.04 |
| Sai, Emmanuel,23417 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Suarez, Rebekah,13649 | 6812.13 | 0.00 | 0.00 | 2049.10 | 4763.03 |
| Hall, Amanda,26656 | 1345.95 | 0.00 | 0.00 | 1345.95 | 0.00 |
| Li, Wesley,23322 | 3042.82 | 0.00 | 0.00 | 2443.35 | 599.47 |
| Munoz, Cheryl, C,13632 | 6838.46 | 0.00 | 0.00 | 2071.42 | 4767.04 |
| Yuan, Terry, R,13646 | 6843.60 | 0.00 | 0.00 | 2049.10 | 4794.50 |
| Nara, Gregory,26651 | 1957.47 | 0.00 | 0.00 | 782.99 | 1174.48 |
| Ramos, Juan,13633 | 6803.14 | 0.00 | 0.00 | 2049.10 | 4754.04 |
| Cooper, Victoria, S,13637 | 6777.13 | 0.00 | 0.00 | 2049.10 | 4728.03 |
| Munoz, Craig, V,13076 | 6862.14 | 0.00 | 2049.10 | 2428.97 | 2384.07 |
| Raji, Grant, R,16185 | 28.98 | 0.00 | 0.00 | 28.98 | 0.00 |
| Morgan, Nathaniel, E,16626 | 71.57 | 0.00 | 0.00 | 71.57 | 0.00 |
| Gutierrez, Diana,19676 | 67.97 | 0.00 | 0.00 | 67.97 | 0.00 |
| Rana, Whitney, A,13006 | 6762.15 | 0.00 | 2049.10 | 2319.99 | 2393.06 |
| Ray, Bobby,23575 | 3302.05 | 0.00 | 0.00 | 3302.05 | 0.00 |
| Romero, Walter, A,25020 | 1549.42 | 0.00 | 0.00 | 1000.44 | 548.98 |
| Xu, Karl,23321 | 3060.82 | 0.00 | 0.00 | 2443.35 | 617.47 |
| Fernandez, Cassandra, C,14134 | 3835.07 | 0.00 | 0.00 | 3835.07 | 0.00 |
| Xu, Cara,23526 | 3563.84 | 0.00 | 0.00 | 3563.84 | 0.00 |
| Zhu, Omar,25033 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Serrano, Rebekah,14130 | 3814.06 | 0.00 | 0.00 | 3814.06 | 0.00 |
| Martin, Anne, V,25034 | 2164.91 | 0.00 | 0.00 | 2164.91 | 0.00 |
| Martinez, Brett,23532 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Adams, Amber,26746 | 2001.45 | 0.00 | 0.00 | 782.99 | 1218.46 |
| Ramos, Tanya, R,14045 | 6804.13 | 0.00 | 0.00 | 2049.10 | 4755.03 |
| Zhang, Lacey, L,14127 | 3809.57 | 0.00 | 0.00 | 3809.57 | 0.00 |
| Nath, Rafael,23533 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Chande, Derek,26743 | 1371.95 | 0.00 | 0.00 | 1371.95 | 0.00 |
| Adams, Sydney,27367 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Xu, Calvin, E,27583 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Yang, Connor,17735 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Yuan, Rafael, J,20625 | 6029.57 | 0.00 | 3578.27 | 0.00 | 2451.30 |
| Jimenez, Jaime, E,29095 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
Generated 2026-07-21 19:41:01.667 UTC