[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 |
|---|---|---|---|---|---|
| Rana, Darren, M,17257 | 4480.73 | 3578.27 | 0.00 | 0.00 | 902.46 |
| Raman, Summer, C,25949 | 1882.57 | 0.00 | 699.10 | 0.00 | 1183.47 |
| Suarez, Melinda,29181 | 553.97 | 0.00 | 0.00 | 0.00 | 553.97 |
| Lal, Kate,21557 | 4886.70 | 0.00 | 2443.35 | 0.00 | 2443.35 |
| Young, Morgan, L,12342 | 6838.12 | 0.00 | 2049.10 | 2369.96 | 2419.06 |
| 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 |
| Morgan, Melanie,21227 | 26.97 | 0.00 | 0.00 | 0.00 | 26.97 |
| Barnes, Taylor,14279 | 5137.71 | 0.00 | 0.00 | 2800.44 | 2337.27 |
| Tang, Colin,14323 | 5222.02 | 0.00 | 0.00 | 2071.42 | 3150.60 |
| Goel, Mario, J,12360 | 6750.48 | 0.00 | 2071.42 | 2294.99 | 2384.07 |
| Srini, Jay, M,18326 | 62.98 | 0.00 | 0.00 | 0.00 | 62.98 |
| Howard, Jesse, D,24249 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Sullivan, Toni, M,29083 | 3.99 | 0.00 | 0.00 | 0.00 | 3.99 |
| Garcia, Troy, M,29290 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Huang, Margaret, H,17070 | 123.96 | 0.00 | 0.00 | 123.96 | 0.00 |
| Gill, Byron, J,18483 | 6056.61 | 3578.27 | 0.00 | 2478.34 | 0.00 |
| Zhou, Arturo, F,27910 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Liang, Colin,13639 | 188.96 | 0.00 | 0.00 | 188.96 | 0.00 |
| Simpson, Tara, K,28107 | 810.32 | 0.00 | 0.00 | 810.32 | 0.00 |
| Jai, Ethan,15217 | 41.26 | 0.00 | 0.00 | 31.27 | 9.99 |
| Foster, Luke,15137 | 161.94 | 0.00 | 0.00 | 161.94 | 0.00 |
| Serrano, Tabitha,28327 | 2407.04 | 0.00 | 0.00 | 2407.04 | 0.00 |
| 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 |
| Yang, Wesley, K,15127 | 5182.73 | 0.00 | 0.00 | 2071.42 | 3111.31 |
| Shen, Jaclyn, A,12575 | 2668.08 | 0.00 | 2049.10 | 0.00 | 618.98 |
| Zeng, Dawn, D,29455 | 751.34 | 0.00 | 0.00 | 0.00 | 751.34 |
| She, Christine,16184 | 78.20 | 0.00 | 0.00 | 0.00 | 78.20 |
| Zhu, Colleen,17252 | 92.97 | 0.00 | 0.00 | 62.98 | 29.99 |
| Raje, Lindsey,24614 | 2120.93 | 0.00 | 1000.44 | 1120.49 | 0.00 |
| Anand, Johnny,14058 | 5652.52 | 0.00 | 0.00 | 3355.24 | 2297.28 |
| Andersen, Roger,24469 | 64.47 | 0.00 | 0.00 | 64.47 | 0.00 |
| Gonzalez, Rebekah, A,16927 | 30.97 | 0.00 | 0.00 | 30.97 | 0.00 |
| Jai, Brad, C,18267 | 64.98 | 0.00 | 0.00 | 34.99 | 29.99 |
| Lin, Claudia, A,14312 | 191.27 | 0.00 | 0.00 | 166.28 | 24.99 |
| Andersen, Ashlee, J,11059 | 116.93 | 0.00 | 0.00 | 116.93 | 0.00 |
| Coleman, Dalton, M,23412 | 3586.81 | 0.00 | 0.00 | 3586.81 | 0.00 |
| She, Katie, B,11965 | 118.74 | 0.00 | 0.00 | 94.25 | 24.49 |
| Flores, Miranda,17243 | 83.98 | 0.00 | 0.00 | 83.98 | 0.00 |
| Serrano, Dana, S,12678 | 341.43 | 0.00 | 0.00 | 341.43 | 0.00 |
| Shen, Brendan, L,14305 | 3652.20 | 0.00 | 0.00 | 2855.86 | 796.34 |
| Serrano, Jésus, B,12991 | 5641.90 | 0.00 | 2049.10 | 1237.82 | 2354.98 |
| Vazquez, Latasha,21952 | 99.47 | 0.00 | 0.00 | 99.47 | 0.00 |
| Hayes, Alexis,13048 | 190.23 | 0.00 | 0.00 | 111.25 | 78.98 |
| Saunders, Patricia, J,19565 | 5308.24 | 0.00 | 3578.27 | 1729.97 | 0.00 |
| Rana, Carla, K,19593 | 5306.54 | 0.00 | 3578.27 | 1728.27 | 0.00 |
| Raman, Harold, F,28484 | 778.62 | 0.00 | 0.00 | 778.62 | 0.00 |
| Luo, Warren,23562 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Zeng, Stacey, J,17317 | 128.95 | 0.00 | 0.00 | 0.00 | 128.95 |
| Zimmerman, Jenny,18197 | 30.97 | 0.00 | 0.00 | 8.99 | 21.98 |
| Torres, Bailey,18259 | 30.97 | 0.00 | 0.00 | 30.97 | 0.00 |
| Tang, Barbara,27711 | 617.47 | 0.00 | 0.00 | 0.00 | 617.47 |
| Carson, Mitchell,13623 | 99.20 | 0.00 | 0.00 | 3.99 | 95.21 |
| Ruiz, Kari, L,12695 | 192.97 | 0.00 | 0.00 | 159.00 | 33.97 |
| Fernandez, Shane, A,13127 | 86.26 | 0.00 | 0.00 | 6.28 | 79.98 |
| Shan, Colleen, D,15150 | 4379.08 | 0.00 | 0.00 | 2049.10 | 2329.98 |
| Sanchez, Cynthia, S,23662 | 3917.54 | 0.00 | 0.00 | 2181.56 | 1735.98 |
| Gill, Kristine,19977 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Ramirez, Mason, K,25107 | 2143.90 | 0.00 | 0.00 | 2143.90 | 0.00 |
| Lal, Drew, A,28325 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Harrison, Colleen, L,20219 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Long, Nicole, C,13624 | 114.97 | 0.00 | 0.00 | 59.98 | 54.99 |
| Guo, Martha, A,28536 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Baker, Luke, J,22952 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Cai, Vincent, L,11757 | 58.05 | 0.00 | 0.00 | 24.49 | 33.56 |
| Torres, Ruben,11002 | 8114.04 | 3399.99 | 0.00 | 4714.05 | 0.00 |
| Garcia, Jermaine,21566 | 42.28 | 0.00 | 0.00 | 42.28 | 0.00 |
| Moreno, Pedro, A,18248 | 6037.89 | 3578.27 | 0.00 | 2459.62 | 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 |
| Mehta, Tina, C,11444 | 8136.02 | 3374.99 | 0.00 | 4761.03 | 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 |
| Smith, Adriana,18702 | 5333.25 | 3578.27 | 0.00 | 1754.98 | 0.00 |
| Vazquez, Joe, C,20418 | 4207.24 | 0.00 | 3578.27 | 628.97 | 0.00 |
| Gonzalez, Devin,18485 | 6063.21 | 3578.27 | 0.00 | 2484.94 | 0.00 |
| Deng, Carl,18284 | 6029.57 | 3578.27 | 0.00 | 2451.30 | 0.00 |
| Zhang, Suzanne, R,20316 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Raje, Kurt,15210 | 2926.39 | 0.00 | 0.00 | 2071.42 | 854.97 |
| Gao, Jamie,26022 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Liu, Jaclyn,12996 | 6808.15 | 0.00 | 2049.10 | 2374.98 | 2384.07 |
| Gill, Lawrence, J,20224 | 44.46 | 0.00 | 0.00 | 0.00 | 44.46 |
| 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 |
| Allen, Devin,15806 | 102.85 | 0.00 | 0.00 | 102.85 | 0.00 |
| Jimenez, Victor,11461 | 8089.04 | 0.00 | 3374.99 | 2294.99 | 2419.06 |
| Moore, Thomas,14010 | 3861.39 | 0.00 | 0.00 | 3861.39 | 0.00 |
| Goel, Dale, M,20416 | 4118.26 | 0.00 | 3578.27 | 539.99 | 0.00 |
| Morgan, Nathaniel, E,16626 | 71.57 | 0.00 | 0.00 | 71.57 | 0.00 |
| Chande, Casey,26149 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Huang, Valerie, J,26745 | 1932.46 | 0.00 | 0.00 | 782.99 | 1149.47 |
| Vazquez, Francis, E,17281 | 83.97 | 0.00 | 0.00 | 0.00 | 83.97 |
| 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 |
| Ye, Valerie, C,28948 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Ortega, Janet, L,11754 | 8163.53 | 0.00 | 3399.99 | 2319.99 | 2443.55 |
| Torres, Danielle, G,22947 | 75.97 | 0.00 | 0.00 | 75.97 | 0.00 |
| Weber, Jay, A,25244 | 21.93 | 0.00 | 0.00 | 21.93 | 0.00 |
| Fernandez, Ronald,28939 | 14.98 | 0.00 | 0.00 | 14.98 | 0.00 |
| Sanchez, Andre,15595 | 4369.09 | 0.00 | 0.00 | 2049.10 | 2319.99 |
| Jai, Calvin, S,22918 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Perez, Henry,26752 | 1917.46 | 0.00 | 0.00 | 782.99 | 1134.47 |
| 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 |
Generated 2026-07-22 07:06:17.389 UTC