[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 |
|---|---|---|---|---|---|
| Vazquez, Eddie, T,14012 | 5249.92 | 0.00 | 0.00 | 2826.44 | 2423.48 |
| Yuan, Kelsey, D,13034 | 94.71 | 0.00 | 0.00 | 35.23 | 59.48 |
| West, James, M,15148 | 90.75 | 0.00 | 0.00 | 90.75 | 0.00 |
| Li, Gilbert,23999 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Kumar, Wayne,17502 | 6070.59 | 3578.27 | 0.00 | 0.00 | 2492.32 |
| Diaz, Josue,15207 | 4446.40 | 0.00 | 0.00 | 2071.42 | 2374.98 |
| Malhotra, Joel, E,16343 | 58.25 | 0.00 | 0.00 | 36.27 | 21.98 |
| Jones, Destiny,15171 | 4392.02 | 0.00 | 0.00 | 2049.10 | 2342.92 |
| Lopez, Virginia, J,27338 | 1339.92 | 0.00 | 0.00 | 1339.92 | 0.00 |
| Gonzales, Alexis,23521 | 21.98 | 0.00 | 0.00 | 0.00 | 21.98 |
| Nara, Tommy,16729 | 38.92 | 0.00 | 0.00 | 0.00 | 38.92 |
| Chander, Melvin, L,24266 | 2749.32 | 0.00 | 0.00 | 2181.56 | 567.76 |
| King, Mackenzie, M,26916 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Blanco, Philip, M,15603 | 39.97 | 0.00 | 0.00 | 24.99 | 14.98 |
| Xylaras, Ioannis,20215 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Martinez, Stanley, Z,13668 | 114.21 | 0.00 | 0.00 | 106.26 | 7.95 |
| Serrano, Deanna, W,15144 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Raje, Gilbert,11055 | 8168.01 | 3374.99 | 0.00 | 4793.02 | 0.00 |
| White, Olivia, E,18457 | 4826.23 | 3578.27 | 0.00 | 0.00 | 1247.96 |
| Zhao, Colin, D,24241 | 2997.32 | 0.00 | 0.00 | 2443.35 | 553.97 |
| Howard, Jesse, D,24249 | 2756.54 | 0.00 | 0.00 | 2181.56 | 574.98 |
| Weber, Cynthia,26921 | 1336.96 | 0.00 | 0.00 | 782.99 | 553.97 |
| Sanz, Cheryl, G,14046 | 5645.24 | 0.00 | 0.00 | 3340.26 | 2304.98 |
| Luo, Colleen, E,15208 | 2951.56 | 0.00 | 0.00 | 2049.10 | 902.46 |
| Rana, Ruben,27696 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Luo, Kenneth, S,15211 | 2910.90 | 0.00 | 0.00 | 2071.42 | 839.48 |
| Lin, Jake,24248 | 2770.52 | 0.00 | 0.00 | 2181.56 | 588.96 |
| Nath, Melvin, D,27697 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Jai, Tommy, C,15027 | 2853.57 | 0.00 | 0.00 | 2049.10 | 804.47 |
| Xu, Kathryn,25210 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Rubio, Jay,15179 | 4444.89 | 0.00 | 0.00 | 2071.42 | 2373.47 |
| Rana, Raymond,25115 | 2155.92 | 0.00 | 0.00 | 2155.92 | 0.00 |
| Suarez, Erika,15120 | 5217.70 | 0.00 | 0.00 | 2049.10 | 3168.60 |
| Gonzales, Logan,16607 | 5897.53 | 3578.27 | 0.00 | 0.00 | 2319.26 |
| Raji, Kathryn, C,21995 | 37.29 | 0.00 | 0.00 | 0.00 | 37.29 |
| Becker, Grant,21390 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Chandra, Jarrod,24171 | 3006.31 | 0.00 | 0.00 | 2443.35 | 562.96 |
| Wang, Martha, D,24272 | 2735.53 | 0.00 | 0.00 | 2181.56 | 553.97 |
| Patterson, Jennifer, M,15129 | 5177.73 | 0.00 | 0.00 | 2071.42 | 3106.31 |
| Ortega, Latasha,24270 | 2844.51 | 0.00 | 0.00 | 2181.56 | 662.95 |
| Chen, Louis, J,17059 | 123.96 | 0.00 | 0.00 | 69.97 | 53.99 |
| Torres, Kellie,19569 | 112.24 | 0.00 | 0.00 | 0.00 | 112.24 |
| Vazquez, Andy,19620 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Suri, Cassandra, B,18717 | 87.21 | 0.00 | 0.00 | 0.00 | 87.21 |
| Pal, Willie, J,11755 | 46.25 | 0.00 | 0.00 | 29.98 | 16.27 |
| Alonso, Stacy,28315 | 556.93 | 0.00 | 0.00 | 556.93 | 0.00 |
| Shen, Leonard, J,24271 | 2745.33 | 0.00 | 0.00 | 2181.56 | 563.77 |
| Hu, Valerie, M,15044 | 3803.56 | 0.00 | 0.00 | 2049.10 | 1754.46 |
| Ye, Alvin, B,15575 | 2910.90 | 0.00 | 0.00 | 2071.42 | 839.48 |
| Becker, Kelsey, G,11968 | 8079.05 | 0.00 | 3399.99 | 2294.99 | 2384.07 |
| Chander, Keith, A,24174 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
| Vance, Monica, G,12338 | 8265.00 | 0.00 | 3374.99 | 2436.97 | 2453.04 |
| Alvarez, Diana,13638 | 6832.12 | 0.00 | 0.00 | 2049.10 | 4783.02 |
| Munoz, Anne,15798 | 98.96 | 0.00 | 0.00 | 98.96 | 0.00 |
| Liang, Dennis,14034 | 104.24 | 0.00 | 0.00 | 0.00 | 104.24 |
| Suri, Carmen, E,24250 | 2738.49 | 0.00 | 0.00 | 2181.56 | 556.93 |
| Lopez, George,15040 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Romero, Frank, M,15209 | 2916.56 | 0.00 | 0.00 | 2049.10 | 867.46 |
| Zhang, Dawn, A,14222 | 82.26 | 0.00 | 0.00 | 0.00 | 82.26 |
| Nelson, Julia, L,11102 | 102.91 | 0.00 | 0.00 | 0.00 | 102.91 |
| Raman, Meagan, J,15134 | 5151.71 | 0.00 | 0.00 | 2071.42 | 3080.29 |
| Martin, Adrienne,19952 | 39.46 | 0.00 | 0.00 | 25.48 | 13.98 |
| Li, Edwin,26967 | 1336.96 | 0.00 | 0.00 | 1336.96 | 0.00 |
| Jones, Emily,16659 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Raman, Shane,16661 | 5908.25 | 3578.27 | 0.00 | 0.00 | 2329.98 |
| Yang, Cedric,15038 | 3750.09 | 0.00 | 0.00 | 2049.10 | 1700.99 |
| Shen, Rafael, J,16689 | 290.46 | 0.00 | 0.00 | 0.00 | 290.46 |
| Gao, Gilbert,24165 | 3046.84 | 0.00 | 0.00 | 2443.35 | 603.49 |
| Munoz, Monique,24008 | 2730.54 | 0.00 | 0.00 | 2181.56 | 548.98 |
| Luo, Lindsey, R,22201 | 5012.27 | 0.00 | 2443.35 | 0.00 | 2568.92 |
| Martinez, Emma,16734 | 128.97 | 0.00 | 0.00 | 128.97 | 0.00 |
| Dominguez, Philip,15730 | 122.96 | 0.00 | 0.00 | 0.00 | 122.96 |
| Raman, Ruben,15580 | 2910.90 | 0.00 | 0.00 | 2071.42 | 839.48 |
| Ma, Rafael, T,13022 | 2644.02 | 0.00 | 2049.10 | 0.00 | 594.92 |
| Gonzalez, Edgar, A,15648 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Shan, Bethany, L,13973 | 5185.68 | 0.00 | 0.00 | 2835.70 | 2349.98 |
| Sai, Ann,27339 | 1336.96 | 0.00 | 0.00 | 1336.96 | 0.00 |
| Shan, Shaun,24274 | 3018.33 | 0.00 | 0.00 | 2443.35 | 574.98 |
| Yuan, Melvin,29331 | 47.97 | 0.00 | 0.00 | 0.00 | 47.97 |
| Rai, Tasha, L,24301 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Navarro, Cheryl,13109 | 5682.90 | 0.00 | 2049.10 | 0.00 | 3633.80 |
| Alonso, Jonathon, A,15238 | 98.96 | 0.00 | 0.00 | 34.99 | 63.97 |
| Martin, Jay,19597 | 33.98 | 0.00 | 0.00 | 33.98 | 0.00 |
| Gill, Javier,15645 | 3785.08 | 0.00 | 0.00 | 2049.10 | 1735.98 |
| Ruiz, Melody,13621 | 167.40 | 0.00 | 0.00 | 0.00 | 167.40 |
| Sun, Franklin,19615 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Kapoor, Cesar, J,24302 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Raje, Misty, A,23544 | 3971.01 | 0.00 | 0.00 | 2181.56 | 1789.45 |
| Gonzalez, Natalie,25215 | 2155.92 | 0.00 | 0.00 | 2155.92 | 0.00 |
| Chander, Edwin, T,17370 | 4742.74 | 3578.27 | 0.00 | 1164.47 | 0.00 |
| Deng, Priscilla, M,25127 | 2174.92 | 0.00 | 0.00 | 2174.92 | 0.00 |
| Rodriguez, Kristi,14345 | 3639.92 | 0.00 | 0.00 | 2897.57 | 742.35 |
| Kapoor, Jarrod,28930 | 15.23 | 0.00 | 0.00 | 0.00 | 15.23 |
| Subram, Douglas,27352 | 1357.97 | 0.00 | 0.00 | 1357.97 | 0.00 |
| Sun, Todd,22018 | 76.97 | 0.00 | 0.00 | 76.97 | 0.00 |
| Deng, Kurt, D,13635 | 215.74 | 0.00 | 0.00 | 32.27 | 183.47 |
| Lee, Destiny,17058 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Zhou, Clayton,27348 | 1382.46 | 0.00 | 0.00 | 1382.46 | 0.00 |
| Sanz, Jimmy,25810 | 114.46 | 0.00 | 0.00 | 114.46 | 0.00 |
| Sanz, Roy, R,11917 | 8121.33 | 0.00 | 3399.99 | 2337.27 | 2384.07 |
| Russell, Seth,25138 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Patel, Deanna, H,27354 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Sutton, Cassie, S,16613 | 129.35 | 0.00 | 0.00 | 34.89 | 94.46 |
| Gutierrez, Cheryl, O,25213 | 2184.90 | 0.00 | 0.00 | 2184.90 | 0.00 |
| Sun, Christy,25218 | 2184.90 | 0.00 | 0.00 | 1000.44 | 1184.46 |
| Jenkins, Amanda,15214 | 4490.88 | 0.00 | 0.00 | 2071.42 | 2419.46 |
| Carlson, Ebony,13959 | 6858.42 | 0.00 | 2049.10 | 0.00 | 4809.32 |
| Garcia, Darren,28716 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Carlson, Francis,27340 | 1350.75 | 0.00 | 0.00 | 1350.75 | 0.00 |
| Wood, Richard, W,24377 | 3945.53 | 0.00 | 0.00 | 2181.56 | 1763.97 |
| Jenkins, Angela,15722 | 4448.57 | 0.00 | 0.00 | 2049.10 | 2399.47 |
| Dominguez, Lee, R,24597 | 4009.50 | 0.00 | 0.00 | 2181.56 | 1827.94 |
| Huang, Randy,24007 | 3042.82 | 0.00 | 0.00 | 2443.35 | 599.47 |
| Beck, Bonnie, A,29097 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Madan, Roy,15716 | 4467.06 | 0.00 | 0.00 | 2049.10 | 2417.96 |
| Romero, Latasha,14220 | 5696.19 | 0.00 | 0.00 | 2071.42 | 3624.77 |
| Davis, Morgan, J,27359 | 1344.47 | 0.00 | 0.00 | 1344.47 | 0.00 |
| Gomez, Naomi, E,24300 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
| Pal, Dustin,26588 | 1938.47 | 0.00 | 782.99 | 0.00 | 1155.48 |
| Moreno, Naomi, C,15601 | 4429.57 | 0.00 | 0.00 | 2049.10 | 2380.47 |
| Goel, Gilbert,15596 | 4460.04 | 0.00 | 0.00 | 2049.10 | 2410.94 |
| Subram, Raymond,23994 | 2790.52 | 0.00 | 0.00 | 2181.56 | 608.96 |
| Gill, Anne,27469 | 1331.97 | 0.00 | 0.00 | 782.99 | 548.98 |
| Serrano, Beth,24304 | 3946.52 | 0.00 | 0.00 | 2181.56 | 1764.96 |
| Luo, Melvin,24366 | 4144.34 | 0.00 | 0.00 | 2443.35 | 1700.99 |
Generated 2026-07-21 14:34:42.044 UTC