[ROOT]  dt  FactInternetSale  WHERE DimCurrency.AlternateKey EQ 'AUD'  >   PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount   <  ORDER BY 2020   <  TAKE 250  >   TITLE Top 1000 Australian Internet customers for 2020   

Top 1000 Australian Internet customers for 2020

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Yang, Jon, V,110008248.993399.990.004849.000.00
Johnson, Logan, K,229313882.550.000.003882.550.00
Chande, Jaclyn, S,186985314.250.003578.271735.980.00
Fernandez, Kristopher, O,192714153.250.003578.27574.980.00
Beck, Alejandro,110256576.803374.990.002405.47796.34
Perez, Toni,15581113.940.000.000.00113.94
Smith, Christian, L,14313222.440.000.000.00222.44
Raman, Cassandra,2871867.970.000.000.0067.97
Suarez, Leslie, C,2295513.980.000.000.0013.98
Alvarez, Adrienne, L,17067113.960.000.000.00113.96
Sharma, Sharon, T,252941882.57699.100.000.001183.47
Torres, Melinda, J,140336809.960.000.002071.424738.54
Suarez, Orlando,1112158.160.000.000.0058.16
Lopez, Kari,15235190.890.000.000.00190.89
Raman, Johnathan,1910363.910.000.0041.9321.98
Rodriguez, Harold, M,2118474.980.000.000.0074.98
Malhotra, Geoffrey, W,1829824.270.000.000.0024.27
Raman, Deanna, H,17053123.960.000.000.00123.96
Raje, Jodi, E,1963074.450.000.000.0074.45
Ruiz, Adrienne,1352367.260.000.000.0067.26
Lin, Ronnie, D,213842921.020.002181.560.00739.46
Suarez, Jacquelyn, C,110108088.043399.990.002294.992393.06
Goel, Karl,1870559.260.000.000.0059.26
Wu, Amy,197906089.590.003578.270.002511.32
Jiménez, Brandi,243784173.320.000.002443.351729.97
Suri, Mayra, M,157294393.700.000.002071.422322.28
Guo, Jaclyn,131196829.450.000.002071.424758.03
Serrano, Randall,27973539.990.000.000.00539.99
Nara, Calvin, J,1136786.260.000.000.0086.26
Kapoor, Kaitlin, M,17072123.960.000.000.00123.96
Subram, Kari,12682227.960.000.000.00227.96
Foster, Aidan,264451938.470.000.00782.991155.48
Becker, Gregory, M,131046894.440.000.002071.424823.02
Zhu, Alan,173204391.743578.270.000.00813.47
Hill, Kaylee, L,119188204.990.003399.992411.942393.06
Perez, Molly,259411255.360.00699.100.00556.26
Andersen, Calvin,2292091.950.000.000.0091.95
Lopez, Heidi,110528131.323374.990.002337.272419.06
Malhotra, Stanley, H,114538176.980.003374.992382.932419.06
Navarro, Kathleen, J,192694118.260.003578.27539.990.00
Jordan, Ross, F,111248129.023399.990.002309.972419.06
Lewis, Jasmine,139646806.450.000.002071.424735.03
Martinez, Clifford,2308739.980.000.000.0039.98
Ashe, Deanna,202845328.230.003578.270.001749.96
Serrano, Tyrone,113605025.800.003399.990.001625.81
Schmidt, Kaitlin,13628191.250.000.0032.27158.98
Hill, James, S,293172438.060.000.000.002438.06
Sun, Tamara, L,1997644.040.000.000.0044.04
Moreno, Monique, R,231183913.820.000.002181.561732.26
Andersen, Warren,119198171.520.003374.990.004796.53
Rivera, Devin, J,251094.990.000.000.004.99
Vazquez, Carolyn,2365039.980.000.000.0039.98
Vazquez, Janet, R,2197356.970.000.000.0056.97
Serrano, Danny,243813970.520.000.002181.561788.96
Deng, Kate, L,157234444.070.000.002049.102394.97
Deng, Latoya, H,219694759.470.002181.560.002577.91
Henderson, Cassidy,212283936.540.002181.560.001754.98
Suarez, Melody, H,142765259.360.000.002864.912394.45
Xie, Derek,142875141.430.000.002049.103092.33
Williams, Alexis, D,14674142.470.000.000.00142.47
Patel, Toni, E,258291894.070.00699.100.001194.97
Rodriguez, Pedro, L,179114698.763578.270.000.001120.49
Xu, Wesley, K,29182539.990.000.000.00539.99
Gill, Gina, F,241772721.550.000.002181.56539.99
Madan, Jay, L,201564139.750.003578.27561.480.00
Guo, Jamie,201514152.730.003578.27574.460.00
Nelson, Carol,135204551.360.000.004551.360.00
Nara, Devon, C,21964103.490.000.000.00103.49
Ramos, Larry,1844621.490.000.000.0021.49
Gonzalez, Eric, C,1909278.260.000.000.0078.26
Gao, Louis,146665199.920.000.002049.103150.82
Rana, Darren, M,172574480.733578.270.000.00902.46
Long, Julian,1203472.250.000.000.0072.25
Suri, Patricia, E,154363772.410.000.002071.421700.99
Chapman, Alicia, A,214184659.900.002181.560.002478.34
Jiménez, Darren, W,28931166.280.000.000.00166.28
Guo, Cedric, R,274871322.980.000.00782.99539.99
Munoz, Sheila,274881322.980.000.00782.99539.99
Raji, Andres, E,139556888.440.000.002071.424817.02
Liu, Dennis,29062742.350.000.000.00742.35
Ruiz, Marie, J,274981350.750.000.00782.99567.76
Simmons, Jordyn,164945961.203578.270.000.002382.93
Nara, Jaclyn, M,119305035.810.003399.990.001635.82
Gill, Kellie,1729294.220.000.000.0094.22
Foster, Madison,140386819.120.000.002049.104770.02
Johnson, Brianna, J,1731938.980.000.000.0038.98
Bailey, Melissa, C,1957282.250.000.0023.7858.47
Morgan, Melissa, M,2022274.450.000.000.0074.45
Subram, Meredith, S,142615653.920.000.002049.103604.82
Smith, Kristi, M,2196235.000.000.0035.000.00
Gonzalez, Donald,1107932.960.000.009.9922.97
Black, Rafael,1196655.760.000.000.0055.76
Mehta, Brett,114508173.260.003374.992370.222428.05
Bryant, Lauren,11752137.870.000.0077.9659.91
Suarez, Pedro, A,246112219.420.001000.441218.980.00
Mehta, Ebony, J,228544659.900.002181.560.002478.34
Sanz, Mathew, L,1455763.970.000.0063.970.00
Baker, Jose, A,229374179.330.000.002443.351735.98
Malhotra, Ross, R,2930714.980.000.0014.980.00
Ruiz, Carolyn, M,27863565.470.000.000.00565.47
Sun, Rafael,267491322.980.000.001322.980.00
Xu, Alejandro, R,265851903.480.000.00782.991120.49
Rodriguez, Dylan, E,1661175.530.000.0042.9332.60
Prasad, Preston, C,208124127.250.003578.27548.980.00
Pal, Jenny,15132151.940.000.000.00151.94
Shan, Kristin,234163598.830.000.003598.830.00
Dominguez, Andy, L,14126135.550.000.0063.9771.58
Serrano, Linda,11071110.230.000.0042.2667.97
Lin, Dennis,161694404.080.000.002049.102354.98
Lin, Heather, L,1571863.970.000.000.0063.97
Gonzalez, Virginia,119294965.780.003374.990.001590.79
Zhou, Clayton,273481382.460.000.00782.99599.47
Arun, Levi, A,1107494.190.000.0085.208.99
Hernandez, Erika,161602644.070.000.002049.10594.97
Shen, Brendan, L,143053652.200.000.002049.101603.10
Brown, Cameron, D,13041153.950.000.0088.9864.97
Xie, Clarence,224022721.550.002181.560.00539.99
Li, Jenny, B,2216978.980.000.000.0078.98
Malhotra, Ruben, M,1707490.250.000.0058.9831.27
Jimenez, Jimmy,273651371.950.000.00782.99588.96
She, Mandy, K,2197240.230.000.000.0040.23
Black, Priscilla,1576662.270.000.0034.9927.28
Gao, Erica, R,1908747.200.000.0047.200.00
Martin, Anne, V,250342164.910.000.001000.441164.47
Hu, Aimee, R,2798139.980.000.0039.980.00
Sandberg, Kristine,122413989.460.003399.990.00589.47
Zhou, Rafael, A,244949.990.000.009.990.00
Raji, Nicolas, N,1730174.980.000.000.0074.98
Yang, Hunter, E,2023721.490.000.0021.490.00
Shan, Damien, M,1136277.270.000.0027.2849.99
Moreno, Roberto, R,212063882.550.002181.560.001700.99
Zheng, Omar, C,14522126.950.000.000.00126.95
Tang, Colin,143235222.020.000.002071.423150.60
Barnes, Taylor,142795137.710.000.002049.103088.61
Beck, Alicia, L,172484382.753578.270.000.00804.48
Goel, Mario, J,123606750.480.002071.422294.992384.07
Zeng, Krystal, A,2581461.960.000.000.0061.96
Hernandez, Logan,123506791.750.002071.422319.992400.34
Garcia, Tina,1723183.980.000.000.0083.98
Huang, Crystal, L,260231917.460.00782.990.001134.47
Sara, George,242472721.550.000.002181.56539.99
Gao, Rafael, R,1873324.270.000.0024.270.00
Chen, Autumn, I,214084624.910.002181.560.002443.35
Gonzalez, Ann,118948223.000.003374.992394.972453.04
Lal, Donna,25812113.970.000.000.00113.97
Nara, Johnny, R,184896081.100.003578.272502.830.00
Yuan, Derek, L,275891183.470.000.000.001183.47
Nara, Derek, A,2613934.470.000.0034.470.00
Chen, Aimee,265911957.470.000.00782.991174.48
Ortega, Janet, L,117548163.530.003399.992319.992443.55
Allen, Kaylee,266531938.470.000.00782.991155.48
Sanz, Roy, R,119178121.330.003399.992337.272384.07
Moreno, Marc,130242665.060.002049.100.00615.96
Torres, Kari,184866021.620.003578.272443.350.00
Martin, Larry,182546021.620.003578.272443.350.00
Zhu, Louis,14858196.970.000.00187.988.99
Sanchez, Denise,167036090.593578.270.002512.320.00
White, Kayla,2642479.470.000.0079.470.00
James, Evan, V,1111985.220.000.0035.2349.99
She, Maurice,229174.990.000.004.990.00
Zhou, Cedric,175144142.233578.270.00563.960.00
Weber, Jay, A,2524421.930.000.0021.930.00
Yang, Heather,182756021.620.003578.272443.350.00
Cai, Willie, S,259601957.470.00782.990.001174.48
Lopez, Brandy, S,1819999.940.000.000.0099.94
Ye, Vincent,13013256.240.000.000.00256.24
Ramirez, Mason, K,251072143.900.000.001000.441143.46
Sun, Mandy, L,1669478.200.000.0039.2238.98
Brooks, Jared,244763563.840.000.002443.351120.49
Lal, Drew, A,28325574.980.000.000.00574.98
Luo, Alison, A,2352756.970.000.000.0056.97
Gomez, Jerome, J,250572120.930.000.001000.441120.49
Serrano, Dwayne,1669576.150.000.000.0076.15
Shen, Karla, E,22925134.930.000.000.00134.93
Zeng, Amy,242422756.540.000.002181.56574.98
Sanz, Julio, H,214044684.390.002181.560.002502.83
Hernandez, Jessie, A,241722735.530.000.002181.56553.97
Sara, Clifford, M,241782810.530.000.002181.56628.97
Rodriguez, Wyatt, D,212184661.500.002181.560.002479.94
Romero, Gina,142345687.720.000.002071.423616.30
Gao, Tiffany, E,163525948.493578.270.000.002370.22
Miller, Edward,113685106.240.003374.990.001731.25
Perez, Evelyn,143463583.260.000.002071.421511.84
Chander, Misty,1733380.940.000.000.0080.94
Diaz, Derrick, R,1485337.970.000.000.0037.97
Ye, Franklin, L,1395282.260.000.000.0082.26
Jai, Brad, C,1826764.980.000.0034.9929.99
Zeng, Brittney, K,13670178.450.000.0054.47123.98
Long, Megan, J,1579142.260.000.0024.9917.27
Alonso, Renee,241662789.520.000.002181.56607.96
Suri, Allen,215534666.500.002181.560.002484.94
Madan, Carla, D,28135548.980.000.000.00548.98
Nara, Gregory,266511957.470.000.00782.991174.48
Yang, Wesley, K,151275182.730.000.002071.423111.31
Gutierrez, Latasha, C,150222999.910.000.002071.42928.49
Zhu, Colleen,1725292.970.000.000.0092.97
Sai, Ronald, B,136436799.450.000.002071.424728.03
Madan, Ronald,258281873.580.00699.100.001174.48
Lal, Sheena,2331213.980.000.000.0013.98
Blanco, Lori, A,15735116.250.000.000.00116.25
Clark, Joshua, A,2613769.990.000.000.0069.99
Liang, Colin,13639188.960.000.0068.96120.00
Chen, Randy,13004190.270.000.000.00190.27
Garcia, Martin, l,233324144.340.000.002443.351700.99
Vazquez, Neil, K,287192384.070.000.002384.070.00
Munoz, Carolyn, L,173156030.613578.270.000.002452.34
Zheng, Jenny, R,119474747.300.003374.99629.96742.35
She, Ashlee,28319556.930.000.000.00556.93
Sharma, Dustin, M,184846093.200.003578.272514.930.00
Butler, Jose,29064815.810.000.000.00815.81
Chander, Alison,182496044.590.003578.272466.320.00
King, Jesse, J,1466581.260.000.000.0081.26
Pal, Peter, K,2284839.990.000.0039.990.00
Martinez, Virginia,1313662.270.000.000.0062.27
Liang, Steve,1431781.260.000.0049.9931.27
Nath, Tommy, B,289377.280.000.000.007.28
Ferrier, Leslie, M,285352433.040.000.002433.040.00
Ma, Omar, I,1523239.970.000.000.0039.97
Shen, Tamara, G,229353951.520.000.002181.561769.96
Zhang, Louis, K,202276054.220.003578.270.002475.95
Sanz, Ross,114558142.030.003374.992319.992447.05
Rai, Terrence, R,250372174.920.000.001000.441174.48
Gao, Jon, C,114568224.460.003399.992391.432433.04
Romero, Renee, E,166395908.253578.270.000.002329.98
Thompson, Cameron, M,166205895.243578.270.000.002316.97
Gonzalez, Carla, J,183366145.070.003578.270.002566.80
Martin, Diane,139586838.640.000.002049.104789.54
Gonzalez, George, L,119424792.290.003399.99614.96777.34
Subram, Virginia,130362677.070.002049.100.00627.97
Wu, Glenn, R,29343553.970.000.000.00553.97
Andersen, Colin,250532183.910.000.001000.441183.47
Zhang, Glenn, A,139675721.910.000.002049.103672.81
Romero, Ebony, A,2771712.940.000.000.0012.94
Martinez, Frederick,119918128.020.003374.990.004753.03
Suri, Holly, M,18286141.550.000.0069.9771.58
Sanz, Rodney,1692644.950.000.000.0044.95
Kapoor, Brandy, I,15236126.950.000.0037.9788.98
He, Karen, C,27861539.990.000.000.00539.99
Williams, Anna, R,175044362.743578.270.000.00784.47
Sharma, Jerry, C,136516812.120.000.002049.104763.02
Luo, Shaun,278642447.050.000.000.002447.05
She, Mindy, J,13009168.670.000.000.00168.67
Torres, Michele, A,161764404.080.000.002049.102354.98
Rana, Joe, D,119168178.510.003374.992405.472398.05
Zheng, Randy, B,2257469.990.000.000.0069.99
Xu, Clayton,184886056.610.003578.272478.340.00
Kumar, Alison,212003932.540.002181.560.001750.98
Shen, Corey,2673961.970.000.0061.970.00
Coleman, Nicole, A,215584919.300.002443.350.002475.95
He, Omar,158312646.360.000.002646.360.00

Generated 2024-09-19 01:37:09.130 UTC