[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 60 > TITLE Top 1000 Australian Internet customers for 2020
60 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Zhao, Shannon,19807 | 35.47 | 0.00 | 0.00 | 0.00 | 35.47 |
| Zhang, Claudia,13114 | 6807.45 | 0.00 | 2071.42 | 0.00 | 4736.03 |
| Hernandez, Kellie, A,12586 | 2636.41 | 0.00 | 2071.42 | 0.00 | 564.99 |
| Goel, Chad,28219 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Rana, Meagan, M,11914 | 8165.96 | 0.00 | 3374.99 | 2329.98 | 2460.99 |
| Patterson, Antonio, G,11963 | 8068.03 | 0.00 | 3374.99 | 2294.99 | 2398.05 |
| Hu, Leah,11994 | 8169.03 | 0.00 | 3374.99 | 2374.98 | 2419.06 |
| Navarro, Mathew, A,19673 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Lin, Darryl, J,15031 | 41.27 | 0.00 | 0.00 | 32.28 | 8.99 |
| Ramos, Paula, W,21376 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Vazquez, Rodney, M,13047 | 241.93 | 0.00 | 0.00 | 0.00 | 241.93 |
| Morgan, Nathaniel, E,16626 | 71.57 | 0.00 | 0.00 | 71.57 | 0.00 |
| Serrano, Leslie, T,14014 | 62.27 | 0.00 | 0.00 | 34.99 | 27.28 |
| Gutierrez, Natasha,17048 | 4382.75 | 3578.27 | 0.00 | 804.48 | 0.00 |
| Sanz, Hector,27344 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Sara, Ann, A,23576 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Ortega, Danny, K,19794 | 6098.58 | 0.00 | 3578.27 | 2520.31 | 0.00 |
| Kapoor, Patricia, R,21883 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Xu, Roger,27968 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Alonso, Teresa,13138 | 83.97 | 0.00 | 0.00 | 58.98 | 24.99 |
| Sanchez, Denise,16703 | 6090.59 | 3578.27 | 0.00 | 2512.32 | 0.00 |
| James, Evan, V,11119 | 85.22 | 0.00 | 0.00 | 35.23 | 49.99 |
| Xie, Alvin, M,16617 | 160.55 | 0.00 | 0.00 | 69.97 | 90.58 |
| Zhou, Cedric,17514 | 4142.23 | 3578.27 | 0.00 | 563.96 | 0.00 |
| Chen, Erica, P,18308 | 6037.89 | 3578.27 | 0.00 | 2459.62 | 0.00 |
| Jiménez, Brandi,24378 | 4173.32 | 0.00 | 0.00 | 2443.35 | 1729.97 |
| Xu, Kristen,15751 | 4446.40 | 0.00 | 0.00 | 2071.42 | 2374.98 |
| Raji, Dale,19265 | 42.28 | 0.00 | 0.00 | 0.00 | 42.28 |
| Ramos, Jaime,15720 | 70.22 | 0.00 | 0.00 | 35.23 | 34.99 |
| Kapoor, Kaitlin, M,17072 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| 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 |
| Zhu, Wesley, L,19624 | 23.78 | 0.00 | 0.00 | 0.00 | 23.78 |
| Suarez, Leslie, C,22955 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Alvarez, Adrienne, L,17067 | 113.96 | 0.00 | 0.00 | 0.00 | 113.96 |
| Alvarez, Marc, B,18221 | 45.95 | 0.00 | 0.00 | 0.00 | 45.95 |
| Ruiz, Naomi,23649 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Chen, Alisha, J,14225 | 5603.92 | 0.00 | 0.00 | 2049.10 | 3554.82 |
| Serrano, Joy, L,14069 | 173.94 | 0.00 | 0.00 | 0.00 | 173.94 |
| Navarro, Rodney, L,29309 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Martinez, Kari,19609 | 6093.20 | 0.00 | 3578.27 | 2514.93 | 0.00 |
| Barnes, Taylor,14279 | 5137.71 | 0.00 | 0.00 | 2800.44 | 2337.27 |
| Gonzalez, Ruth,12693 | 6820.47 | 0.00 | 2071.42 | 2329.99 | 2419.06 |
| Mehta, Mayra,12998 | 5694.90 | 0.00 | 2049.10 | 1249.84 | 2395.96 |
| Zhu, Jenny, J,17078 | 186.94 | 0.00 | 0.00 | 186.94 | 0.00 |
| Vazquez, Neil, K,28719 | 2384.07 | 0.00 | 0.00 | 2384.07 | 0.00 |
| Sharma, Dustin, M,18484 | 6093.20 | 3578.27 | 0.00 | 2514.93 | 0.00 |
| Ferrier, Leslie, M,28535 | 2433.04 | 0.00 | 0.00 | 2433.04 | 0.00 |
| Zhou, Steve, C,20263 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Jai, Ethan,15217 | 41.26 | 0.00 | 0.00 | 31.27 | 9.99 |
| Sai, Bruce,22194 | 4633.90 | 0.00 | 2181.56 | 0.00 | 2452.34 |
| Zhao, Susan, L,25122 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Nara, Lindsay, M,25247 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cai, Vincent, L,11757 | 58.05 | 0.00 | 0.00 | 24.49 | 33.56 |
| Shen, Katrina,15801 | 4381.38 | 0.00 | 0.00 | 2049.10 | 2332.28 |
| Luo, Mario, L,25711 | 1274.08 | 0.00 | 699.10 | 0.00 | 574.98 |
| Gutierrez, Darren, A,25714 | 1308.06 | 0.00 | 699.10 | 0.00 | 608.96 |
| Alvarez, Max, M,11986 | 8245.23 | 0.00 | 3399.99 | 2392.20 | 2453.04 |
| Ye, Lacey,29090 | 778.62 | 0.00 | 0.00 | 0.00 | 778.62 |
| Guo, Glenn, J,18712 | 24.27 | 0.00 | 0.00 | 21.98 | 2.29 |
Generated 2026-07-22 19:04:24.280 UTC