[ROOT]  dt  FactInternetSale  <  WHERE DimCurrency.AlternateKey EQ 'CAD'  >   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
Sanchez, Adrian, L,13179190.170.000.00150.1939.98
Sanders, Alexa, E,217414127.253578.270.00548.980.00
Lopez, Katelyn,11820232.710.000.00197.7334.98
Tang, Carl,2123832.270.000.0032.270.00
Henderson, Ashley,111851381.370.000.00785.15596.22
Jenkins, Alexandra, D,11632924.610.000.00822.36102.25
Peterson, Jared,11502829.370.000.00613.28216.09
Edwards, Eric,2462768.490.000.0068.490.00
Foster, Carson, L,16959135.350.000.00135.350.00
Green, Isabella,26620699.10699.100.000.000.00
Diaz, Luke,12054402.530.000.00332.5669.97
Morris, Paige, W,220414167.233578.270.000.00588.96
Howard, Natalie,1349154.960.000.0014.9839.98
Moreno, Meredith, D,2228589.970.000.0089.970.00
Thomas, Logan, A,14091251.200.000.00251.200.00
Turner, Jose,11784272.690.000.00144.97127.72
Barnes, Fernando,113001390.550.000.00854.70535.85
Bailey, Richard, N,220504160.533578.270.00582.260.00
Prasad, Donald,15413318.920.000.00198.96119.96
Parker, Jennifer, D,221184158.243578.270.00579.970.00
Robinson, Sarah, A,2702859.980.000.0059.980.00
Henderson, Jackson, A,221215997.333578.270.002419.060.00
Ramirez, Abigail, S,1585974.140.000.0039.2534.89
Brown, Anna,1624795.820.000.0095.820.00
Martinez, Andrew, C,11530523.810.000.00327.08196.73
Reed, Bryan,18884133.930.000.0076.9756.96
Sun, Arturo, C,11498557.540.000.00323.86233.68
Lee, John,19801193.010.000.00103.0489.97
Butler, Morgan, E,2050068.490.000.0068.490.00
Davis, Nicholas,1320173.160.000.0012.9460.22
Foster, Trevor, J,2896469.990.000.0069.990.00
Rodriguez, Brianna, J,222674167.233578.270.000.00588.96
Wright, Jackson,11698225.950.000.00204.4621.49
Miller, Joseph, A,227134148.193578.270.000.00569.92
Collins, Hailey,11709325.890.000.00156.45169.44
Green, Marcus, C,15974208.410.000.00138.4269.99
Navarro, Jerome, B,11519717.280.000.00653.3163.97
Perry, Oscar,227856029.573578.270.002451.300.00
Griffin, Isabelle,249864.990.000.000.004.99
Chandra, Brandy, P,11501603.530.000.00300.14303.39
Torres, Mackenzie,28153570.470.000.000.00570.47
Martin, Gina, E,11078793.270.000.00648.83144.44
Lee, Ian,19646197.040.000.000.00197.04
Reed, Erin, I,14353128.840.000.00128.840.00
Carter, Jesse, E,22141166.280.000.00166.280.00
Green, Gabrielle, M,2181564.470.000.0064.470.00
Barnes, Alexandra, P,222686031.313578.270.002453.040.00
Russell, Jacqueline,18391100.960.000.00100.960.00
Henderson, Hailey, C,171481775.470.000.001775.470.00
Bryant, Kyle,231644807.103578.270.001228.830.00
Griffin, Jason, L,112001267.110.000.00988.01279.10
Jenkins, Samantha,113311290.330.000.00923.85366.48
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Thompson, Ethan,199894495.483374.990.001120.490.00
Richardson, Nathaniel,120894710.030.000.004710.030.00
James, Juan,232674862.093578.270.001283.820.00
Foster, Antonio,12795108.540.000.0066.2642.28
Powell, Angela, R,12970471.110.000.00198.92272.19
Hill, Alexandra, K,15172215.450.000.00145.4869.97
Foster, Eric,229765971.333578.270.000.002393.06
Morgan, Andrea, M,16870149.040.000.00149.040.00
Harris, Emily, P,1986298.480.000.0098.480.00
Rodriguez, Nicholas, D,14604137.950.000.00137.950.00
James, Jeremiah, S,11661287.700.000.00104.97182.73
Carter, Jason,11724210.090.000.00161.1248.97
Phillips, Jackson, D,233785317.230.003578.271738.960.00
Washington, Hannah, A,291307.280.000.007.280.00
Diaz, Elijah,200004495.480.003374.991120.490.00
Harris, Jacob, G,2367939.980.000.0039.980.00
Stewart, Jessica,16097103.550.000.00103.550.00
Gonzales, Trevor, K,16085143.530.000.00143.530.00
Mitchell, Savannah,261153052.800.000.003052.800.00
Torres, Taylor,16666205.440.000.00205.440.00
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Young, Sierra, J,11619634.840.000.00358.72276.12
Shan, Benjamin,235663578.270.003578.270.000.00
Perez, Dalton,110911125.360.000.00742.57382.79
Alexander, Ashley, J,200074495.480.003374.990.001120.49
Alexander, Paige, W,1860459.250.000.0037.2721.98
Wilson, Hunter, R,2723013.980.000.0013.980.00
Blue, Makayla,1900029.990.000.000.0029.99
Rogers, Amanda, A,13920266.970.000.00198.0068.97
Yang, Aaron, C,2519654.980.000.000.0054.98
Campbell, Kevin, S,121774811.500.000.004811.500.00
Jai, Logan, H,12031769.490.000.000.00769.49
Anderson, Megan, A,238594153.250.003578.27574.980.00
Stewart, Katherine, Z,229015971.333578.270.000.002393.06
Martin, Brianna, M,235834829.390.003578.271251.120.00
Cooper, Timothy, J,206513198.570.002049.100.001149.47
Long, Kaitlyn,233964891.610.003578.271313.340.00
Murphy, Maria,160113657.260.000.002407.421249.84
Rodriguez, Joshua, A,235114843.110.003578.271264.840.00
Evans, Connor, J,15402131.550.000.0074.9856.57
Rogers, Jared, J,12166162.220.000.0037.29124.93
Thompson, Isabella,18756128.410.000.0042.9385.48
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Flores, Kevin,15878225.920.000.0069.97155.95
Thompson, Kaitlyn, L,12430223.930.000.00223.930.00
White, Greg, C,174032322.280.000.000.002322.28
Martinez, Jill,242354829.390.003578.270.001251.12
Perez, Amber, D,13318214.260.000.00116.9197.35
Sharma, Samuel,27725119.980.000.000.00119.98
Peterson, Alex, M,13423132.900.000.0012.94119.96
Chander, Wayne, S,243444329.610.003578.27751.340.00
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Williams, Ethan,243094793.120.003578.270.001214.85
Bell, Gabrielle,223735976.323578.270.000.002398.05
Hughes, Luke, I,270141274.080.00699.100.00574.98
Jai, Samuel, L,1635887.950.000.0083.963.99
Perry, Jonathan, T,27026699.100.00699.100.000.00
Rivera, Makayla, A,2878334.990.000.0034.990.00
Jones, Madison,246614181.760.003578.27603.490.00
Green, Gabriella, C,2803569.990.000.0069.990.00
Bennett, Seth,244933578.270.003578.270.000.00
Cooper, Brianna,2592513.980.000.0013.980.00
Allen, Aaron, A,200753399.990.003399.990.000.00
Cox, Katelyn, B,2174230.970.000.0030.970.00
Hughes, Zachary,12203157.910.000.0058.9598.96
Stewart, Hailey,229036054.223578.270.002475.950.00
Brooks, Lucas, S,16089342.030.000.00180.98161.05
He, Micah,2740169.990.000.0069.990.00
She, Kenneth,16096212.010.000.00188.0423.97
Coleman, Joan, W,2669964.470.000.0064.470.00
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Ramirez, Brian, M,116182369.960.000.002369.960.00
Walker, Isabella,243864143.740.003578.27565.470.00
Chen, Luis, G,2125294.450.000.0094.450.00
Prasad, Molly,243924329.610.003578.27751.340.00
Russell, Kaitlyn, M,244913578.270.003578.270.000.00
Garcia, Victoria, V,245013578.270.003578.270.000.00
Parker, Morgan, S,1677236.960.000.0014.9821.98
Turner, Adam, K,16109548.980.000.000.00548.98
Cooper, Stephanie,249762181.560.002181.560.000.00
Sharma, Yolanda, K,250483046.840.002443.35603.490.00
Hughes, Justin, M,181222439.990.000.000.002439.99
Green, Sophia, E,249772181.560.002181.560.000.00
Thomas, Charles,250942443.350.002443.350.000.00
Lee, William,13185149.840.000.00149.840.00
Hughes, Julia,250612443.350.002443.350.000.00
Ross, Haley, T,253612443.350.002443.350.000.00
Huang, Kristen,251002443.350.002443.350.000.00
Turner, Amanda, L,203183241.900.002071.420.001170.48
Watson, Emma,17481126.940.000.00126.940.00
Price, Stephanie,258922443.350.002443.350.000.00
Morgan, Timothy,14633242.500.000.0095.55146.95
Morris, Richard,2007039.980.000.0039.980.00
Murphy, Dalton, N,27043782.990.00782.990.000.00
Hernandez, Marcus,185952329.990.000.000.002329.99
Howard, Isaiah,259813018.330.002443.35574.980.00
Suarez, Juan, R,167631700.990.000.001700.990.00
Rodriguez, Lucas, P,15942191.870.000.0099.9291.95
Chen, James, D,11641303.200.000.00303.200.00
Powell, Jasmine, A,11505846.770.000.00688.58158.19
Williams, Morgan, C,203733226.900.002071.420.001155.48
Russell, Fernando,27084782.990.00782.990.000.00
Edwards, Connor,16950211.010.000.00211.010.00
Stewart, Julia, L,129022329.980.000.002329.980.00
Walker, Emma, M,2520998.960.000.0098.960.00
Morris, Mackenzie, N,2647413.980.000.0013.980.00
Torres, Mariah,16380195.950.000.0071.97123.98
Powell, Lauren, E,1966275.970.000.0075.970.00
Morgan, Jada, A,11520702.990.000.00488.28214.71
Evans, Dalton, E,127104774.040.000.004774.040.00
Adams, Mackenzie, A,14640812.420.000.00812.420.00
Lopez, Jack, I,2904751.460.000.0051.460.00
Coleman, Jose, S,253494.990.000.004.990.00
Ortega, Javier, P,127852294.990.000.002294.990.00
Gonzales, Nathan, M,12107222.230.000.00222.230.00
Gutierrez, Jerome,127832420.460.000.002420.460.00
Phillips, Miguel,2049812.940.000.0012.940.00
Alexander, Taylor,17482146.940.000.00146.940.00
Bell, Alex, M,167543118.600.000.003118.600.00
Green, Samuel, D,14096174.730.000.00174.730.00
Smith, Samuel, D,2308349.900.000.0049.900.00
Coleman, Logan,1868691.950.000.0091.950.00
Walker, Brandon, J,159164793.270.000.002332.282460.99
Bryant, Gabriel,2765669.990.000.0069.990.00
Cooper, Alexandra,19541131.240.000.0098.9632.28
Miller, Sydney, A,134404818.530.000.004818.530.00
Rodriguez, Alexis, L,15244179.190.000.00129.2249.97
Griffin, Jennifer, B,14244154.960.000.00119.9635.00
Russell, Xavier,12964119.950.000.0064.9954.96
Watson, Olivia, S,1386093.850.000.0054.9738.88
Flores, Emma, P,15543180.940.000.0078.98101.96
Ross, Xavier, A,12202171.470.000.0099.5371.94
Perez, Angel, S,213362628.350.000.002628.350.00
Yuan, Carly,19839194.960.000.0069.97124.99
Fernandez, Ruth,205463246.550.002049.100.001197.45
Townsend, Jeremiah, I,265031000.440.001000.440.000.00
Perry, Marcus, L,206563245.900.002071.420.001174.48
Robinson, Jennifer, L,265041000.440.001000.440.000.00
Diaz, Angela, K,27259782.990.00782.990.000.00
Thompson, Ryan, M,113301111.360.000.00733.75377.61
Davis, Marcus, T,17337123.910.000.00101.9321.98
McDonald, Aaron, J,27734119.980.000.00119.980.00
Thames, Bernard,2380368.490.000.0068.490.00
Thomas, Ian,191181120.490.000.001120.490.00
Parker, Jeremy,2866878.980.000.0078.980.00
Watson, Erin, B,227724.990.000.004.990.00
Smith, Nathan,217647.280.000.007.280.00
Rogers, Andrea, L,14328308.660.000.00155.23153.43
Davis, Daniel,11711999.220.000.00363.22636.00
Patterson, Hailey, I,112231155.900.000.00897.37258.53
Young, Adam,12984200.200.000.00131.2368.97
Flores, Megan, N,230746021.823578.270.000.002443.55
Martin, James, M,1987077.250.000.0039.9837.27
Simmons, Jennifer,112621010.560.000.00527.37483.19
Rodriguez, Natalie,2077330.970.000.000.0030.97
Thompson, Devin,207084406.400.002071.420.002334.98
Gonzales, Brianna, L,211483223.580.002049.100.001174.48
Russell, Isabella, A,11507645.780.000.00390.78255.00
Baker, Sara, M,11827512.470.000.00255.73256.74
Hayes, Brittany,13941286.820.000.0038.88247.94
Sanchez, Rachel, C,267304.990.000.000.004.99
Rogers, Paige, H,17125539.990.000.000.00539.99
Perez, Katherine, J,2207924.270.000.000.0024.27
Gray, Marcus, T,183892401.450.000.000.002401.45
Gray, Jared, A,264494.990.000.004.990.00
Srini, Ruben,18078200.940.000.0071.97128.97
Perry, Ana,112151155.520.000.00874.28281.24
Torres, Christina, M,20746119.950.000.00119.950.00
Miller, Victoria,15816188.020.000.00188.020.00
Alexander, Aidan,17387148.190.000.00148.190.00
Simmons, Caleb, M,121934833.030.000.004833.030.00
Wilson, Tyler, L,15879196.930.000.00196.930.00
Hill, Blake,11748131.540.000.0054.9576.59
Perry, Eric,18314115.730.000.00115.730.00
Gray, Isabella,168203217.790.000.002341.46876.33
Ye, Alisha, J,220084141.233578.270.000.00562.96
Lal, Luke, L,11019698.230.000.00344.76353.47
Washington, Caroline, D,231145996.323578.270.000.002418.05
Thomas, Matthew, K,13239185.700.000.0099.4786.23
Simmons, Sarah, V,11500651.980.000.00397.65254.33
Turner, Blake,12136131.740.000.00126.754.99
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
Coleman, Benjamin, F,234865343.230.003578.271764.960.00
Young, Kaylee, S,13756298.490.000.00298.490.00
Alexander, Elijah,11738331.680.000.00211.70119.98
Ward, Mariah, J,2158044.910.000.0044.910.00
Hill, Katherine, L,2670139.980.000.0039.980.00
Ross, Miranda,145984839.000.000.002445.942393.06
Lee, Samantha, B,2737878.980.000.000.0078.98
Griffin, Maria,1840763.250.000.0030.9732.28
Henderson, Eduardo, R,14359256.240.000.0078.98177.26
Flores, Miguel,1975077.250.000.000.0077.25
Brown, Christian,227554.990.000.000.004.99
Ward, Ian,12056213.920.000.00138.9474.98
Thomas, Jeremiah,183721760.470.000.000.001760.47
Campbell, Chloe,11212760.930.000.00441.24319.69
Zhang, Connor, R,138532329.980.000.000.002329.98

Generated 2024-06-01 09:32:27.050 UTC