[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_SUM2023202420252026
Andersen, Colin,250532183.910.000.002183.910.00
Alvarez, Marvin,236513917.540.000.002181.561735.98
Suarez, Melody, H,142765259.360.000.002864.912394.45
Jenkins, Amanda,152144490.880.000.002071.422419.46
Gill, Leslie,146702919.890.000.002919.890.00
She, Tamara, M,142245621.220.000.002049.103572.12
Raman, Meagan, J,151345151.710.000.002071.423080.29
Shen, Grant, B,267631957.470.000.00782.991174.48
Chen, Crystal, M,265662016.950.00782.990.001233.96
Munoz, Monique,240082730.540.000.002181.56548.98
He, Colin, B,143005322.730.000.002071.423251.31
Rai, Nina,1401863.870.000.000.0063.87
Wang, Micah, C,146765188.410.000.002049.103139.31
Dominguez, Neil, K,236633882.550.000.002181.561700.99
Huang, Randy,240073042.820.000.002443.35599.47
Gomez, Jerome, J,250572120.930.000.002120.930.00
Young, Allison, R,2364439.980.000.000.0039.98
Ross, Arianna, E,267741331.970.000.001331.970.00
Schmidt, Shane,179224821.723578.270.000.001243.45
She, Jerry, C,142775196.740.000.002876.752319.99
Richardson, Abigail, S,142365710.230.000.002071.423638.81
Alexander, Olivia, L,146675295.410.000.002049.103246.31
Subram, Raymond,239942790.520.000.002181.56608.96
Li, Gilbert,239992730.540.000.002181.56548.98
Diaz, Josue,152074446.400.000.002071.422374.98
Jones, Destiny,151714392.020.000.002049.102342.92
Lopez, Virginia, J,273381339.920.000.001339.920.00
Chander, Melvin, L,242662749.320.000.002181.56567.76
King, Mackenzie, M,269161322.980.000.00782.99539.99
Serrano, Deanna, W,151444344.090.000.002049.102294.99
Zhao, Colin, D,242412997.320.000.002443.35553.97
Howard, Jesse, D,242492756.540.000.002181.56574.98
Weber, Cynthia,269211336.960.000.00782.99553.97
Luo, Colleen, E,152082951.560.000.002049.10902.46
Luo, Kenneth, S,152112910.900.000.002071.42839.48
Lin, Jake,242482770.520.000.002181.56588.96
Jai, Tommy, C,150272853.570.000.002049.10804.47
Rubio, Jay,151794444.890.000.002071.422373.47
Rana, Raymond,251152155.920.000.002155.920.00
Suarez, Erika,151205217.700.000.002049.103168.60
Chandra, Jarrod,241713006.310.000.002443.35562.96
Wang, Martha, D,242722735.530.000.002181.56553.97
Patterson, Jennifer, M,151295177.730.000.002071.423106.31
Ortega, Latasha,242702844.510.000.002181.56662.95
Shen, Leonard, J,242712745.330.000.002181.56563.77
Hu, Valerie, M,150443803.560.000.002049.101754.46
Chander, Keith, A,241742983.340.000.002443.35539.99
Suri, Carmen, E,242502738.490.000.002181.56556.93
Lopez, George,150403807.400.000.002071.421735.98
Romero, Frank, M,152092916.560.000.002049.10867.46
Li, Edwin,269671336.960.000.001336.960.00
Yang, Cedric,150383750.090.000.002049.101700.99
Gao, Gilbert,241653046.840.000.002443.35603.49
Raman, Ruben,155802910.900.000.002071.42839.48
Gonzalez, Edgar, A,156483807.400.000.002071.421735.98
Ye, Alvin, B,155752910.900.000.002071.42839.48
Sai, Ann,273391336.960.000.001336.960.00
Shan, Shaun,242743018.330.000.002443.35574.98
Rai, Tasha, L,243014144.340.000.002443.351700.99
Gill, Javier,156453785.080.000.002049.101735.98
Kapoor, Cesar, J,243023882.550.000.002181.561700.99
Gonzalez, Natalie,252152155.920.000.002155.920.00
Deng, Priscilla, M,251272174.920.000.002174.920.00
Subram, Douglas,273521357.970.000.001357.970.00
Zhou, Clayton,273481382.460.000.001382.460.00
Russell, Seth,251382120.930.000.001000.441120.49
Patel, Deanna, H,273541322.980.000.001322.980.00
Gutierrez, Cheryl, O,252132184.900.000.002184.900.00
Sun, Christy,252182184.900.000.001000.441184.46
Carlson, Francis,273401350.750.000.001350.750.00
Wood, Richard, W,243773945.530.000.002181.561763.97
Jenkins, Angela,157224448.570.000.002049.102399.47
Madan, Roy,157164467.060.000.002049.102417.96
Davis, Morgan, J,273591344.470.000.001344.470.00
Gomez, Naomi, E,243004144.340.000.002443.351700.99
Moreno, Naomi, C,156014429.570.000.002049.102380.47
Goel, Gilbert,155964460.040.000.002049.102410.94
Gill, Anne,274691331.970.000.00782.99548.98
Serrano, Beth,243043946.520.000.002181.561764.96
Luo, Melvin,243664144.340.000.002443.351700.99
Johnsen, Willie,152184399.080.000.002049.102349.98
He, Gilbert,155894416.380.000.002071.422344.96
Lopez, Mayra, E,273561336.960.000.001336.960.00
Jiménez, Brandi,243784173.320.000.002443.351729.97
Andersen, Tara, L,244653356.040.000.003356.040.00
She, Jeffery, M,2714942.280.000.000.0042.28
Guo, Cedric, R,274871322.980.000.00782.99539.99
Munoz, Sheila,274881322.980.000.00782.99539.99
Hall, Haley,274891383.450.000.00782.99600.46
Zhou, Ernest, P,157922645.400.000.002645.400.00
Blanco, Natasha,158084424.080.000.002049.102374.98
Allen, Ian, A,160313750.090.000.002049.101700.99
Guo, Rosa, M,244743882.550.000.002181.561700.99
Zhao, Heather,245964168.830.000.002443.351725.48
Guo, Louis, D,157644413.390.000.002071.422341.97
Dominguez, Lee, R,245974009.500.000.002181.561827.94
Rodriguez, Bobby,157524408.690.000.002071.422337.27
Hernandez, Erika,161602644.070.000.002644.070.00
Muñoz, Jaime, C,245063563.840.000.002443.351120.49
Luo, Jerry, M,245864144.340.000.002443.351700.99
Xu, Colin,157902668.380.000.002668.380.00
Hu, Susan,252422120.930.000.001000.441120.49
Shan, Yolanda,127026911.100.002049.102388.962473.04
Alan, Jamie, S,2122442.280.000.000.0042.28
Alonso, Natasha, L,2500914.980.000.000.0014.98
Sharma, Corey, M,17495119.910.000.0056.9762.94
Sharma, Edwin, K,250211554.410.000.001000.44553.97
Pal, Nina,29297613.450.000.000.00613.45
Vazquez, Marie,218994663.790.002181.560.002482.23
Gonzales, Lucas,29463751.340.000.000.00751.34
Xu, Jaclyn, L,126856904.110.002049.102416.952438.06
Lu, Glenn,12692156.260.000.006.28149.98
Lal, Deborah, T,219823882.550.002181.560.001700.99
Navarro, Cheryl,131095682.900.002049.100.003633.80
Alonso, Jonathon, A,1523898.960.000.0034.9963.97
Kumar, Kate,173218.990.000.000.008.99
Wang, Jon, A,261911938.470.00782.990.001155.48
Moreno, Felicia, A,129876759.470.002071.422294.992393.06
Jai, Alison,236574.990.000.000.004.99
Hernandez, Walter,13141240.240.000.000.00240.24
Nara, Tommy,1672938.920.000.000.0038.92
Suri, Arthur,261901932.460.00782.990.001149.47
Collins, Jennifer,113644921.823374.990.000.001546.83
Sai, Rachael,119128095.320.003374.992319.992400.34
Xu, Arturo,136196808.100.000.002049.104759.00
Lopez, Sergio, L,1512381.260.000.000.0081.26
James, Evan, V,1111985.220.000.0035.2349.99
Zhang, Claudia,131146807.450.002071.420.004736.03
Hernandez, Kellie, A,125862636.410.002071.420.00564.99
Suri, Lydia,131266815.080.002049.100.004765.98
Raje, Jenny,2023369.970.000.0069.970.00
Zheng, Erica, K,236434.990.000.004.990.00
Dominguez, Robyn, P,233057.280.000.007.280.00
Gutierrez, Pedro, S,1522471.920.000.0036.9334.99
Russell, Cassidy, N,2614427.770.000.0027.770.00
Guo, Jaclyn,131196829.450.002071.420.004758.03
Shan, Derek, R,197826089.590.003578.272511.320.00
Foster, Aidan,264451938.470.00782.990.001155.48
Zhu, Alan,173204391.743578.270.000.00813.47
Simmons, Jacqueline, W,13137177.940.000.00177.940.00
Sai, Bruce,221944633.900.002181.560.002452.34
Sara, Tabitha, W,257151274.080.00699.100.00574.98
Cai, Vincent, L,1175758.050.000.0024.4933.56
Deng, Latoya, H,219694759.470.002181.560.002577.91
Shen, Barbara,220304144.340.002443.350.001700.99
Gutierrez, Darren, A,257141308.060.00699.100.00608.96
Goel, Bridget,261341926.450.00782.990.001143.46
Lopez, Barry, R,260201932.460.00782.990.001149.47
Moreno, Tanya,1113983.970.000.000.0083.97
Patel, Stanley, L,249152145.920.001000.441145.480.00
Guo, Jorge, L,2659069.990.000.000.0069.99
Nara, Cassie,1364279.970.000.0079.970.00
Zeng, Alisha, A,15727134.460.000.0099.4734.99
Fernandez, Kristina, A,125812646.400.002071.420.00574.98
Ramos, Victor, D,242469.990.000.009.990.00
Kapoor, Dominic, J,1669967.580.000.0032.6034.98
Rodriguez, Dylan, E,1661175.530.000.0042.9332.60
Munoz, Marvin,1468049.990.000.000.0049.99
Raman, Jay, M,136186763.150.000.004344.092419.06
Diaz, Vanessa, J,29100102.960.000.000.00102.96
Gonzalez, Virginia,119294965.780.003374.990.001590.79
Ross, Brandon,141323804.080.000.003804.080.00
Carlson, Shannon, C,110098091.333374.990.004716.340.00
Zhu, Christy,110038139.293399.990.004739.300.00
Henderson, Xavier, K,1299396.250.000.0096.250.00
Guo, Trisha,1825345.950.000.0036.968.99
Romero, Dwayne,28314553.970.000.00553.970.00
Li, Barbara,157884443.380.000.002071.422371.96
Gao, Susan,274711386.480.000.00782.99603.49
Dominguez, Raquel, A,274701371.950.000.00782.99588.96
Prasad, George, C,157674379.090.000.002049.102329.99
Kumar, Robert,252262158.900.000.001000.441158.46
Sun, Suzanne, P,245873882.550.000.002181.561700.99
Rana, Ross,252402120.930.000.001000.441120.49
Patterson, Kyle,114488132.013374.990.004757.020.00
Lal, Donna,25812113.970.000.000.00113.97
Torres, Kristy, M,130352638.060.002049.100.00588.96
Perez, Joel,166844158.243578.270.000.00579.97
Serrano, Linda,11071110.230.000.0042.2667.97
Xu, Barbara,1407459.880.000.0059.880.00
Prasad, Denise,1829478.260.000.0075.972.29
Hu, Kristen, C,197886056.610.003578.272478.340.00
Romero, Max, C,293162433.040.000.002433.040.00
Liu, Christy,197846021.620.003578.272443.350.00
Vazquez, Arthur,28480742.350.000.00742.350.00
Patel, Ruben, I,197654132.240.003578.27553.970.00
Hu, Alvin, E,114498130.323374.990.004755.330.00
Huang, Dawn, E,119434734.290.003374.99539.99819.31
Townsend, Darren,184675279.263578.270.001700.990.00
Liu, Jessie,111068079.053399.990.004679.060.00
Coleman, Ethan, G,166936060.503578.270.002482.230.00
Roberts, Jennifer,114478078.023374.990.004703.030.00
Price, Ian, J,224012983.340.002443.35539.990.00
Garcia, Ruben,196136093.200.003578.272514.930.00
Zhou, Jon, L,110608153.023399.990.004753.030.00
Suri, Cesar,175124170.543578.270.00592.270.00
She, Colleen, E,2931269.970.000.0069.970.00
Raje, Terrence,182466030.613578.270.002452.340.00
Sharma, Kelvin, D,266551322.980.000.001322.980.00
Sai, Cesar,182436058.213578.270.002479.940.00
Suarez, Renee, L,127036891.120.002049.102448.962393.06
Nara, Cristina, R,197926056.610.003578.272478.340.00
Navarro, Melinda,114548089.040.003374.994714.050.00
Smith, Arthur,182406098.583578.270.002520.310.00
Anand, Rafael,293062384.070.000.002384.070.00
Chandra, Ann,182096056.613578.270.002478.340.00
Luo, Casey,110728194.003399.990.004794.010.00
Gonzalez, George, L,119424792.290.003399.99614.96777.34
Liang, Darryl,266581390.950.000.001390.950.00
Kapoor, Ruben, D,111098245.013374.990.004870.020.00
Suarez, Jacquelyn, C,110108088.043399.990.004688.050.00
Diaz, Cheryl, A,110928110.023374.990.004735.030.00
Liu, Jaclyn,129966808.150.002049.102374.982384.07
Huang, Amy, C,12244114.960.000.00114.960.00
Ortega, Renee,1844721.490.000.0021.490.00
Gill, Mallory, P,16698197.880.000.00197.880.00
Lopez, Edgar, O,1734681.460.000.0081.460.00
Navarro, Francis, J,2752078.980.000.0078.980.00
Sara, Ruben, A,19566164.910.000.00164.910.00
Goel, Barbara,129886915.440.002049.102482.272384.07
Liu, Glenn,188994118.263578.270.00539.990.00
Gao, Stacey,166624355.713578.270.00777.440.00
Gomez, Felicia, J,182196038.563578.270.002460.290.00
Johnson, Logan, K,229313882.550.002181.561700.990.00
Beck, Alejandro,110256576.803374.990.002405.47796.34
Hu, Alejandro,13125138.540.000.00104.9833.56
Peterson, Juan, H,130826906.390.002071.422382.932452.04
Allen, Logan,1581281.250.000.0078.962.29
Alonso, Krista, P,20212100.740.000.0023.7876.96
Raman, Pamela, C,2736978.980.000.0078.980.00
Serrano, Leslie, T,1401462.270.000.0034.9927.28
Perez, Brett, M,28313647.940.000.00647.940.00
Sara, Ann, A,2357639.980.000.0039.980.00
Jai, Brad, C,1826764.980.000.0034.9929.99
Long, Megan, J,1579142.260.000.0024.9917.27
Nara, Jaclyn, M,119305035.810.003399.990.001635.82
Sai, Ronald, B,136436799.450.002071.420.004728.03
Romero, Philip, F,221954909.670.002443.350.002466.32
Sanz, Cheryl, G,140465645.240.000.003340.262304.98
Torres, Mathew, L,189004132.240.003578.27553.970.00
Gonzalez, Phillip, N,182076089.593578.270.002511.320.00
Johnson, Elizabeth,110048196.013399.990.004796.020.00
Ruiz, Julio,110058121.333374.990.004746.340.00
Navarro, Kathleen, J,192694118.260.003578.27539.990.00
Shen, Nichole,129996840.460.002071.422349.982419.06
Ye, Tamara, A,2024360.470.000.0060.470.00
Sun, Louis, E,1618283.970.000.0058.9824.99
Hernandez, Wendy, A,15124122.440.000.00122.440.00
Zhou, Laura, D,126836801.450.002071.422316.972413.06
Mehta, Mayra,129985694.900.002049.101249.842395.96

Generated 2026-07-21 21:57:07.222 UTC