[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 125 > TITLE Top 1000 Australian Internet customers for 2020
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| 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 |
| Jimenez, Kathleen,26654 | 1346.76 | 0.00 | 0.00 | 1346.76 | 0.00 |
| Raji, Sheena, J,18213 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Romero, Lawrence, C,16687 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Jimenez, Felicia, L,11075 | 8068.03 | 3374.99 | 0.00 | 4693.04 | 0.00 |
| Gomez, Felicia, J,18219 | 6038.56 | 3578.27 | 0.00 | 2460.29 | 0.00 |
| Wang, Roger, P,24605 | 3627.81 | 0.00 | 0.00 | 3627.81 | 0.00 |
| Fernandez, Kristopher, O,19271 | 4153.25 | 0.00 | 3578.27 | 574.98 | 0.00 |
| Gutierrez, Larry,25926 | 1308.06 | 0.00 | 699.10 | 0.00 | 608.96 |
| Li, Margaret,15753 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Ramos, Kendra,24896 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Jenkins, Joan,16155 | 4489.57 | 0.00 | 0.00 | 2049.10 | 2440.47 |
| Barnes, Faith, F,15726 | 4393.36 | 0.00 | 0.00 | 2049.10 | 2344.26 |
| Carlson, Alfredo,16178 | 108.85 | 0.00 | 0.00 | 38.88 | 69.97 |
| Gao, Christy, D,26204 | 1967.45 | 0.00 | 782.99 | 0.00 | 1184.46 |
| 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 |
| Ashe, Deanna,20284 | 5328.23 | 0.00 | 3578.27 | 0.00 | 1749.96 |
| Becker, Kara,21167 | 4657.51 | 0.00 | 2181.56 | 0.00 | 2475.95 |
| Serrano, Tyrone,11360 | 5025.80 | 3399.99 | 0.00 | 0.00 | 1625.81 |
| Chen, Kristen, L,22002 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Torres, Mathew, L,18900 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Malhotra, Stanley, H,11453 | 8176.98 | 0.00 | 3374.99 | 4801.99 | 0.00 |
| Chen, Steve, R,18902 | 4186.23 | 0.00 | 3578.27 | 607.96 | 0.00 |
| Navarro, Kathleen, J,19269 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Mehta, Tina, C,11444 | 8136.02 | 3374.99 | 0.00 | 4761.03 | 0.00 |
| Xu, Cedric, M,24278 | 184.48 | 0.00 | 0.00 | 184.48 | 0.00 |
| Kapoor, Rachael, D,11911 | 62.46 | 0.00 | 0.00 | 37.47 | 24.99 |
| Martin, Jaime,28316 | 539.99 | 0.00 | 0.00 | 539.99 | 0.00 |
| Subram, Kari,12682 | 227.96 | 0.00 | 0.00 | 68.96 | 159.00 |
| Perez, Preston,12370 | 61.53 | 0.00 | 0.00 | 61.53 | 0.00 |
| Luo, Shaun,27864 | 2447.05 | 0.00 | 0.00 | 2447.05 | 0.00 |
| Zheng, Randy, B,22574 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Scott, Timothy,19631 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Yuan, Karla, W,13629 | 6889.11 | 0.00 | 0.00 | 2049.10 | 4840.01 |
| Alonso, Billy, M,22852 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Xie, Alicia,26427 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Zhao, Jaclyn, D,26167 | 1903.48 | 0.00 | 782.99 | 0.00 | 1120.49 |
| Ramos, Joe,12353 | 6765.46 | 0.00 | 2071.42 | 2309.97 | 2384.07 |
| Gonzalez, Heidi, Z,13157 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Malhotra, Janelle,26425 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Subram, Kristi, N,15025 | 128.94 | 0.00 | 0.00 | 0.00 | 128.94 |
| Patel, Toni, E,25829 | 1894.07 | 0.00 | 699.10 | 0.00 | 1194.97 |
| Zhao, Colin, D,24241 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Martinez, Lydia,24169 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Gill, Gina, F,24177 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Martinez, Harold, J,20604 | 93.49 | 0.00 | 0.00 | 0.00 | 93.49 |
| Rubio, Randall, M,17286 | 6029.57 | 3578.27 | 0.00 | 2451.30 | 0.00 |
| Long, Alexis,22580 | 3051.31 | 0.00 | 2443.35 | 607.96 | 0.00 |
| Lal, Kurt, R,14015 | 59.98 | 0.00 | 0.00 | 24.99 | 34.99 |
| Raje, April, R,18744 | 32.22 | 0.00 | 0.00 | 21.98 | 10.24 |
| Andersen, Tara, L,24465 | 3356.04 | 0.00 | 0.00 | 3356.04 | 0.00 |
| Travers, Alexa, A,24466 | 3337.04 | 0.00 | 0.00 | 3337.04 | 0.00 |
| Diaz, Marc,11058 | 8248.02 | 3399.99 | 0.00 | 4848.03 | 0.00 |
| Ramos, Kristine,17479 | 163.40 | 0.00 | 0.00 | 163.40 | 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 |
| Gonzalez, Kristopher, C,19264 | 4132.24 | 0.00 | 3578.27 | 553.97 | 0.00 |
| Sai, Abby, L,11101 | 8262.52 | 3399.99 | 0.00 | 4862.53 | 0.00 |
| Lin, Wesley,21407 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Sanz, Arthur,27688 | 166.28 | 0.00 | 0.00 | 166.28 | 0.00 |
| Zhang, Barbara,16338 | 169.43 | 0.00 | 0.00 | 169.43 | 0.00 |
| Butler, Austin, W,18293 | 74.24 | 0.00 | 0.00 | 74.24 | 0.00 |
| Malhotra, Ross, R,29307 | 14.98 | 0.00 | 0.00 | 14.98 | 0.00 |
| Black, Priscilla,15766 | 62.27 | 0.00 | 0.00 | 62.27 | 0.00 |
| Lopez, Savannah,25709 | 1308.06 | 699.10 | 0.00 | 0.00 | 608.96 |
| Ms., Seidel, Birgit,16621 | 73.86 | 0.00 | 0.00 | 0.00 | 73.86 |
| Moreno, Roberto, R,21206 | 3882.55 | 0.00 | 2181.56 | 0.00 | 1700.99 |
| Tang, Colin,14323 | 5222.02 | 0.00 | 0.00 | 2071.42 | 3150.60 |
| Raje, Darrell,20252 | 69.97 | 0.00 | 0.00 | 0.00 | 69.97 |
| Sara, George,24247 | 2721.55 | 0.00 | 0.00 | 2181.56 | 539.99 |
| Hernandez, Diana, F,11038 | 6437.33 | 3374.99 | 0.00 | 0.00 | 3062.34 |
| Sai, Holly, V,26769 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Vazquez, Francis, E,17281 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| Xu, Lacey, S,17913 | 4733.75 | 3578.27 | 0.00 | 0.00 | 1155.48 |
| Torres, Neil,17305 | 196.97 | 0.00 | 0.00 | 196.97 | 0.00 |
| Malhotra, Ruben, M,17074 | 90.25 | 0.00 | 0.00 | 90.25 | 0.00 |
| Nelson, Sophia,16664 | 4377.75 | 3578.27 | 0.00 | 799.48 | 0.00 |
| Prasad, Cesar,23411 | 3577.82 | 0.00 | 2443.35 | 1134.47 | 0.00 |
| Chander, Drew, J,25111 | 2145.92 | 0.00 | 0.00 | 2145.92 | 0.00 |
| Shen, Kelvin,22406 | 3018.33 | 0.00 | 2443.35 | 574.98 | 0.00 |
| Kumar, Rafael, L,19088 | 24.27 | 0.00 | 0.00 | 2.29 | 21.98 |
| Griffin, Blake, S,18699 | 5308.24 | 3578.27 | 0.00 | 1729.97 | 0.00 |
| Flores, Miranda,17243 | 83.98 | 0.00 | 0.00 | 83.98 | 0.00 |
| Sai, Rachael,11912 | 8095.32 | 0.00 | 3374.99 | 2319.99 | 2400.34 |
| Chandra, Virginia, M,27588 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| James, Evan, V,11119 | 85.22 | 0.00 | 0.00 | 35.23 | 49.99 |
| Deng, Colleen, S,27728 | 67.49 | 0.00 | 0.00 | 0.00 | 67.49 |
| 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 |
| Martin, Renee, L,17478 | 4758.24 | 3578.27 | 0.00 | 1179.97 | 0.00 |
| Shan, Clarence,22408 | 2770.52 | 0.00 | 2181.56 | 588.96 | 0.00 |
| West, James, M,15148 | 90.75 | 0.00 | 0.00 | 90.75 | 0.00 |
| Stone, Keith,17331 | 40.96 | 0.00 | 0.00 | 8.99 | 31.97 |
| Morgan, Melissa, M,20222 | 74.45 | 0.00 | 0.00 | 13.98 | 60.47 |
| Sanchez, Abby, J,19966 | 6021.62 | 0.00 | 3578.27 | 2443.35 | 0.00 |
| Bell, Stephanie, A,27370 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Serrano, Dwayne,16695 | 76.15 | 0.00 | 0.00 | 0.00 | 76.15 |
| Sanz, Julio, H,21404 | 4684.39 | 0.00 | 2181.56 | 0.00 | 2502.83 |
| Xu, Kelvin, K,21222 | 3936.54 | 0.00 | 2181.56 | 0.00 | 1754.98 |
| Sara, Clifford, M,24178 | 2810.53 | 0.00 | 0.00 | 2181.56 | 628.97 |
| 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 |
| Andersen, Calvin,22920 | 91.95 | 0.00 | 0.00 | 0.00 | 91.95 |
| 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 |
| 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 |
| Raje, Lacey, T,12358 | 6787.76 | 0.00 | 2071.42 | 2297.28 | 2419.06 |
| Travers, Jimmy, V,12674 | 6829.47 | 0.00 | 2071.42 | 2319.99 | 2438.06 |
| Nath, Carly, J,17255 | 4442.24 | 3578.27 | 0.00 | 0.00 | 863.97 |
| Mehta, Mayra,12998 | 5694.90 | 0.00 | 2049.10 | 1249.84 | 2395.96 |
| Goel, Marshall, M,27691 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Stone, Colin, K,12673 | 6768.14 | 0.00 | 2049.10 | 2334.97 | 2384.07 |
| Lal, Sheena,23312 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
Generated 2026-07-22 07:07:23.704 UTC