[ROOT]  dt  FactInternetSale  <  WHERE DimCurrency.AlternateKey EQ 'CAD'  >   PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount   <  ORDER BY 2020   SHUFFLE   <  SKIP 1125  >   <  TAKE 500  >   

382 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Davis, Justin,2807412.940.000.000.0012.94
White, Emma, N,16090604.960.000.000.00604.96
Martin, Gina, E,11078793.270.000.00158.36634.91
Watson, Shelby, J,14911867.970.000.000.00867.97
Bryant, Nathan,2145059.980.000.000.0059.98
Lewis, Morgan,17410168.740.000.000.00168.74
Alexander, Thomas,207607.280.000.000.007.28
Gonzales, Jose,2201439.980.000.000.0039.98
Sun, Arturo, C,11498557.540.000.0012.94544.60
Alexander, Jordan,2141259.980.000.0059.980.00
Thomas, Dalton,230097.280.000.000.007.28
Roberts, Seth, H,11510258.150.000.0039.47218.68
Washington, Lauren, R,229985329.250.003578.271750.980.00
Bell, Alexandria, A,13758284.130.000.0042.28241.85
Phillips, Miguel,2049812.940.000.000.0012.94
Coleman, Samuel, N,17450123.980.000.000.00123.98
Anderson, Megan, A,238594153.250.003578.27574.980.00
Torres, Pedro, E,16958168.020.000.00153.0414.98
Hughes, Zachary,12203157.910.000.000.00157.91
Cook, Bryce,2864069.990.000.000.0069.99
Bryant, Jackson, J,2533239.980.000.000.0039.98
Parker, Jennifer, D,221184158.240.003578.270.00579.97
Lewis, Lucas, A,232094802.110.003578.271223.840.00
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Torres, Mackenzie,28153570.470.000.000.00570.47
Green, Blake, P,11719287.200.000.000.00287.20
Carter, Madeline, A,2752269.990.000.000.0069.99
Gonzales, Emily, P,21777180.980.000.000.00180.98
Simmons, Brittany,2923139.980.000.000.0039.98
Morgan, Isaiah,18978118.730.000.000.00118.73
Cook, Joan,235544.990.000.000.004.99
Perry, Samuel,18811100.960.000.00100.960.00
Roberts, Noah, S,2704268.490.000.000.0068.49
Harris, Jacob, G,2367939.980.000.0039.980.00
Bailey, Hailey, R,262704.990.000.000.004.99
Price, Miranda,26629699.10699.100.000.000.00
Edwards, Angel, J,2912469.990.000.000.0069.99
King, Sara,2235439.980.000.000.0039.98
Thomas, Thomas,216292624.080.000.002049.10574.98
Zeng, Jake,18054106.930.000.000.00106.93
Hu, Gilbert, L,2876769.990.000.000.0069.99
Hayes, Carson, A,124472331.950.000.000.002331.95
Ward, Emma, W,2179659.980.000.000.0059.98
Perry, Lauren,248164.990.000.000.004.99
Flores, Nathan, C,2463713.980.000.000.0013.98
Turner, Timothy, C,14641119.860.000.000.00119.86
Gray, Brianna,249603008.820.002443.35565.470.00
Liu, Arturo,13222150.410.000.0013.98136.43
Powell, Miranda, J,153044843.000.000.000.004843.00
Alexander, Ryan, J,14078839.480.000.00839.480.00
Reed, Judith, D,2534759.980.000.000.0059.98
Price, Nicole, N,15815141.830.000.000.00141.83
Nath, Alison, J,171161764.960.000.000.001764.96
Ortega, Sheila, M,2763239.980.000.000.0039.98
Thomas, Jeremiah,183721760.470.000.000.001760.47
Powell, Jordyn, K,153914828.010.000.000.004828.01
Patterson, Eric, A,2738478.980.000.000.0078.98
Bryant, Zachary,216552648.070.000.002648.070.00
Gomez, Renee, L,253712181.560.002181.560.000.00
Bradley, Melanie, G,133434720.270.000.000.004720.27
Isla, Julian, A,13732108.960.000.004.99103.97
Perez, Dalton,110911125.360.000.00213.86911.50
Campbell, Lucas,2932953.990.000.000.0053.99
Price, Caroline,180511735.980.000.000.001735.98
Nelson, Jordan, H,201304.990.000.004.990.00
Evans, Alexandra,2432268.490.000.000.0068.49
Li, Brandon,2933973.960.000.000.0073.96
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Torres, Taylor,16666205.440.000.00123.9881.46
Powell, Jasmine, A,11505846.770.000.0077.77769.00
Evans, Luke,2917615.230.000.000.0015.23
Griffin, Jack, L,1768632.280.000.000.0032.28
Wright, Jennifer,2650559.980.000.0059.980.00
Sharma, Yolanda, K,250483046.840.002443.35603.490.00
Hill, Sydney,264821000.440.000.001000.440.00
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Flores, Miguel,1975077.250.000.000.0077.25
Bryant, Dakota, L,176132401.950.000.000.002401.95
Harrison, Trevor, A,18055143.910.000.0036.96106.95
Adams, Julia, N,2607359.980.000.000.0059.98
Griffin, Thomas, J,19015125.430.000.0094.4630.97
Nelson, James, L,245257.280.000.007.280.00
Richardson, Melissa, E,111322371.940.000.000.002371.94
Yuan, Carly,19839194.960.000.000.00194.96
Sanders, Angel,16219553.970.000.000.00553.97
Jones, Nicole,14504112.270.000.000.00112.27
Collins, Nathan, F,197041143.460.000.000.001143.46
Garcia, Kayla, L,2130881.460.000.000.0081.46
Dominguez, Meghan,14370122.560.000.000.00122.56
Smith, Chloe,17619163.920.000.000.00163.92
Peterson, Morgan, J,168341750.980.000.000.001750.98
Hall, Noah, A,1525175.250.000.000.0075.25
Sanders, Alexa, E,217414127.253578.270.00548.980.00
White, Nicole,16731155.910.000.0084.9670.95
Griffin, Melissa, L,287807.950.000.000.007.95
Luo, Franklin, J,2202759.980.000.000.0059.98
Richardson, Devin, G,2131836.960.000.000.0036.96
Thomas, Logan, A,14091251.200.000.0053.99197.21
Perry, Christian,246714354.600.003578.270.00776.33
Stewart, Cody, A,212843223.580.000.002049.101174.48
Davis, Jasmine, M,265291549.420.000.001000.44548.98
Jai, Connor, D,27253782.990.000.00782.990.00
Walker, Isabella,243864143.740.003578.27565.470.00
Scott, Mason,2355139.980.000.000.0039.98
Harris, Seth, M,161402528.330.000.002528.330.00
Ward, Natalie, J,132412325.960.000.000.002325.96
Hernandez, Sierra,27393123.980.000.00123.980.00
Shan, Gabriel, T,2773169.990.000.000.0069.99
Nath, Kenneth, W,170372334.970.000.000.002334.97
Allen, Sean, L,12097159.220.000.000.00159.22
Rogers, Faith,2468259.980.000.000.0059.98
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Powell, Vanessa,26630699.100.00699.100.000.00
Harris, Samantha, A,244874.990.000.000.004.99
Rivera, Caitlin, L,261132730.540.000.002181.56548.98
Suarez, Juan, R,167631700.990.000.000.001700.99
Lewis, Brandon, A,2903769.990.000.000.0069.99
Simmons, Haley, T,262022749.320.000.002181.56567.76
Hughes, Antonio, P,15913712.270.000.000.00712.27
Rubio, Ruben, D,1887186.960.000.0086.960.00
Shan, Chad, M,2462112.940.000.000.0012.94
Simmons, Mariah,266831270.820.00699.100.00571.72
Bradley, Nathaniel,169551760.470.000.000.001760.47
Tang, Carl,2123832.270.000.000.0032.27
Perry, Eric,18314115.730.000.0056.9758.76
Howard, Brianna, D,246304.990.000.000.004.99
Huang, Kristen,251002443.350.002443.350.000.00
White, Greg, C,174032322.280.000.000.002322.28
Hayes, Oscar,2652729.260.000.000.0029.26
Wilson, Fernando,16643126.960.000.000.00126.96
Wilson, Eduardo,15323804.470.000.000.00804.47
Wu, Randy, J,116472365.940.000.002365.940.00
Cooper, Alexandra,19541131.240.000.000.00131.24
Lewis, Jeremiah,1437187.260.000.0049.9737.29
Nelson, Adam, B,27402128.970.000.000.00128.97
Long, Caleb, P,250462181.560.002181.560.000.00
Murphy, Maria,160113657.260.000.000.003657.26
Thompson, Blake,18390141.960.000.000.00141.96
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Long, Xavier,112512318.960.000.000.002318.96
Adams, Jennifer,153624745.020.000.000.004745.02
Bailey, Marcus, L,18329146.530.000.0023.78122.75
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Howard, Alyssa, A,11513863.950.000.000.00863.95
Fernandez, Darren,2899278.980.000.000.0078.98
Reed, Erin, I,14353128.840.000.0074.9853.86
Thomas, William, A,216142589.090.000.002049.10539.99
Walker, Charles,11677298.210.000.000.00298.21
Richardson, Olivia,204683169.590.000.002049.101120.49
Bailey, Mariah, L,2724354.980.000.000.0054.98
Stewart, Makayla,16649115.940.000.000.00115.94
Miller, Kayla, A,236734.990.000.000.004.99
Reed, Kaylee, R,17371151.920.000.000.00151.92
Rubio, Jaime, R,15007209.830.000.0049.97159.86
Flores, Brandon, L,2562189.970.000.000.0089.97
Bailey, Richard, N,220504160.533578.270.000.00582.26
Jai, Jose,12944164.210.000.0039.99124.22
Lopez, Katelyn,11820232.710.000.0060.47172.24
Sharma, Jackson,16876151.840.000.000.00151.84
Mohamed, Samantha, A,292772419.060.000.002419.060.00
Griffin, Madison, A,250932181.560.002181.560.000.00
Cannata, Gabrielle, C,217254.990.000.000.004.99
Price, Stephanie,258922443.350.002443.350.000.00
Turner, Wyatt,200345769.960.003399.990.002369.97
Anderson, Emma, A,185801170.480.000.000.001170.48
Powell, Katherine, C,14574177.600.000.000.00177.60
Johnson, Ian, E,2173283.470.000.000.0083.47
Taylor, Edward, C,17442319.880.000.00230.9088.98
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Richardson, Nathaniel,120894710.030.000.002316.972393.06
Brown, Nicholas, S,11506675.640.000.00121.93553.71
Brown, Samantha, G,2514739.980.000.000.0039.98
Flores, Cassidy, L,233684.990.000.000.004.99
Collins, Amanda,2078339.980.000.000.0039.98
Brown, Christian,227554.990.000.000.004.99
Foster, Jose, C,2878534.990.000.000.0034.99
Cox, Julia, A,206703228.570.000.002049.101179.47
Clark, Miguel, D,169872414.990.000.000.002414.99
Powell, David, W,266151000.440.000.001000.440.00
Nelson, Luis,234884.990.000.000.004.99
Srini, Ruben,18078200.940.000.000.00200.94
Green, Chloe, J,1465892.820.000.000.0092.82
Green, Mackenzie, C,280737.280.000.000.007.28
White, Emily, M,159174679.060.000.000.004679.06
Zhang, Heather,166543056.320.000.00751.342304.98
Perry, Olivia,203754438.380.000.002071.422366.96
Alvarez, Melody,2507068.490.000.000.0068.49
Robinson, Abigail, R,183792362.270.000.000.002362.27
Washington, Elijah, L,250164.990.000.000.004.99
Foster, Isabel, M,2174571.950.000.000.0071.95
Washington, Alexia,27613782.990.000.00782.990.00
Reed, Bryan,18884133.930.000.000.00133.93
Morgan, Angela,24665109.970.000.000.00109.97
Flores, Isabelle, A,15526188.320.000.0096.0792.25
Butler, Victoria,132844767.530.000.000.004767.53
Malhotra, Kristi, S,151754850.330.000.000.004850.33
Williams, Edward, D,14274121.560.000.000.00121.56
Simmons, Dakota, T,14110819.460.000.000.00819.46
Gomez, Krista,12760273.180.000.0036.27236.91
Alexander, Aidan,17387148.190.000.0056.9791.22
Griffin, Haley, L,1892582.180.000.000.0082.18
Rivera, Allison, M,13751224.910.000.000.00224.91
Moreno, Lance, A,2922939.980.000.000.0039.98
Lewis, Zachary, L,14760167.260.000.000.00167.26
Lewis, Seth,26782699.100.00699.100.000.00
Price, Mariah, C,2074549.480.000.000.0049.48
Harris, Noah,292562393.060.000.002393.060.00
Collins, Xavier, C,16646250.910.000.000.00250.91
Allen, Amanda,2235339.980.000.000.0039.98
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Martinez, Carol, D,17656578.460.000.000.00578.46
King, Caleb, J,2898678.980.000.000.0078.98
Rodriguez, Nicholas, D,14604137.950.000.0058.9778.98
Li, Connor,201863191.910.002071.420.001120.49
Scott, Gabrielle,270614.990.000.000.004.99
Evans, Kaylee,19642133.540.000.000.00133.54
Thames, Bernard,2380368.490.000.000.0068.49
Moreno, Meredith, D,2228589.970.000.000.0089.97
Mitchell, Alexandra,14455218.930.000.0023.97194.96
Murphy, Emma,198445807.930.003374.990.002432.94
Ross, Xavier, A,12202171.470.000.0049.97121.50
Foster, Kayla,1969371.950.000.000.0071.95
Clark, Joseph, D,153954780.020.000.000.004780.02
Washington, Emma,191231170.480.000.000.001170.48
Moore, Jessica, J,2008576.760.000.000.0076.76
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Chandra, Allen,2932753.990.000.000.0053.99
Jones, Dalton, T,189512334.970.000.000.002334.97
Thompson, Joshua, F,259992181.560.000.002181.560.00
Powell, Angela, R,12970471.110.000.000.00471.11
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Bennett, Seth,244933578.270.003578.270.000.00
Wilson, Christian,27085782.990.000.00782.990.00
Washington, Adam, G,2543713.980.000.000.0013.98
Bradley, Alexandria,176911779.470.000.000.001779.47
Powell, Sydney, M,14886539.990.000.00539.990.00
Diaz, Faith, M,2236356.970.000.000.0056.97
Hughes, Anna,197052341.970.000.000.002341.97
Li, Kevin, S,2518813.980.000.000.0013.98
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Thomas, Samantha,2169093.970.000.000.0093.97
Martin, Morgan,248322181.560.002181.560.000.00
Cooper, Stephanie,249762181.560.002181.560.000.00
Young, Kaylee, S,13756298.490.000.0058.47240.02
Richardson, Lauren, C,14867839.480.000.000.00839.48
Moore, Hunter,14897196.270.000.0071.58124.69
Jackson, Hannah, G,131432404.970.000.000.002404.97
Anderson, Jasmine, A,235534.990.000.000.004.99
Coleman, Dylan,27403132.970.000.000.00132.97
Hernandez, José, M,11253696.610.000.0098.97597.64
Baker, Robert, A,273007.280.000.007.280.00
Xu, Louis,2010466.530.000.0066.530.00
Mehta, Carmen, C,2743694.480.000.000.0094.48
James, Sara,198023374.993374.990.000.000.00
Sanchez, Martin, E,216317.280.000.000.007.28
White, Christopher, R,260492181.560.000.002181.560.00
Cox, Devin, C,134184768.050.000.000.004768.05
Sanders, Sean,14341175.150.000.000.00175.15
Hall, Lauren, A,19648100.840.000.000.00100.84
Torres, Dalton,235037.280.000.007.280.00
Kelly, Bryan,213492989.380.000.002989.380.00
Murphy, Richard, M,222994145.540.003578.270.00567.27
Kumar, Cameron, S,185711120.490.000.001120.490.00
Johnson, Madison, L,15530846.460.000.000.00846.46
Li, Eugene, A,15283865.950.000.000.00865.95
Hill, Alexandra, K,15172215.450.000.0036.27179.18
Ward, Cole,214907.280.000.000.007.28
Perez, Jordan, A,292674.990.000.000.004.99
Hayes, Dalton, C,188822322.280.000.000.002322.28
Lee, Alexander, S,18356149.910.000.000.00149.91
Martinez, Grace, M,17385208.690.000.0069.97138.72
Hill, Jordan, J,16005198.730.000.00102.2796.46
Hall, Luke, E,14745902.460.000.000.00902.46
Morgan, Marcus, W,289682.290.000.000.002.29
Chow, Candice,1923260.960.000.000.0060.96
Walker, Jacob, N,29027574.980.000.000.00574.98
Moore, Andrew, A,13944150.130.000.0036.27113.86
Foster, Edward, R,18355150.950.000.000.00150.95
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Taylor, Ryan,170251709.980.000.000.001709.98
Patterson, Jeremy,130272319.260.000.000.002319.26
Brooks, Ian, W,2829064.470.000.000.0064.47
James, Maria,1624391.970.000.0069.9921.98
Russell, Richard,2763322.260.000.000.0022.26
Cooper, Paige,14119148.940.000.000.00148.94
Thomas, Charles,250942443.350.002443.350.000.00
Ward, Jade, D,14661195.020.000.000.00195.02
Bailey, Morgan, E,213542646.400.000.002071.42574.98
Richardson, Erin, R,1633188.850.000.0038.8849.97
Edwards, Madeline,2077146.470.000.000.0046.47
Bradley, Rachel,158504813.040.000.000.004813.04
Rogers, Sean, G,18685124.460.000.000.00124.46
Price, Isabelle,201825749.970.003374.990.002374.98
Alexander, Gavin, K,2932249.990.000.000.0049.99
Williams, Morgan, C,203733226.900.000.002071.421155.48
Phillips, Luis, G,207347.280.000.000.007.28
Stewart, Amanda, M,1531094.440.000.000.0094.44
Jones, Natalie, A,11845197.200.000.0082.26114.94
Mitchell, Caleb, K,268064.990.000.000.004.99
Ross, Kaitlyn,16121614.470.000.000.00614.47
Lal, Kyle,17360122.180.000.000.00122.18
Lewis, Isabella,2624267.930.000.000.0067.93
Ward, Stephanie, A,27429782.990.000.00782.990.00
Gonzalez, Gabriella, Z,15872235.540.000.000.00235.54
Martin, Christian, V,19709197.250.000.000.00197.25
Davis, James,11922275.500.000.0034.98240.52
Mitchell, Kaylee, R,14566401.490.000.000.00401.49
_SUM1806517.5065197.22487005.99323518.76930795.53
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Stewart, Grace, H,247737.280.000.000.007.28
Gonzales, Ashley, C,1860051.970.000.000.0051.97
Gonzalez, Jeremiah,17468128.910.000.0071.9556.96
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Hill, Timothy,14871848.470.000.000.00848.47
Torres, Erin,1218287.250.000.0037.2949.96
Washington, Ian, M,246644368.580.003578.270.00790.31
Russell, Gail, L,212634.990.000.000.004.99
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Murphy, Catherine, L,1650692.050.000.000.0092.05
Parker, Kaylee, M,2773878.980.000.000.0078.98
Roberts, Robert, R,1898656.970.000.0056.970.00
Chen, James, D,11641303.200.000.0021.49281.71
Townsend, Jeremiah, I,265031000.440.000.001000.440.00
Sanchez, Mariah, R,1922066.650.000.0038.8827.77
Taylor, Marcus, A,18944146.940.000.000.00146.94
Anderson, Madison, G,2835978.980.000.000.0078.98
Bryant, Isabelle,233974828.110.003578.270.001249.84
Barnes, Kayla,2425639.980.000.0039.980.00
Stewart, Hailey,229036054.220.003578.270.002475.95
Stewart, Alexandria,174761700.990.000.000.001700.99
Murphy, Shelby,244894.990.000.000.004.99
Baker, Allison,2649558.980.000.000.0058.98
Sanders, Megan, A,15376136.240.000.000.00136.24
Wang, Zachary,2214489.970.000.000.0089.97
Moore, Jonathan,2047896.460.000.000.0096.46
Murphy, Dalton, N,27043782.990.00782.990.000.00
Foster, Antonio,12795108.540.000.0066.2642.28
Russell, Chloe, M,12763589.960.000.000.00589.96
Butler, Cassidy, L,21792114.460.000.000.00114.46
Martinez, Jonathan,1330366.250.000.000.0066.25
Gray, Sara,292472447.050.000.002447.050.00
Clark, Zachary, J,2389358.980.000.000.0058.98
Reed, Michelle,2804669.990.000.000.0069.99
Washington, Hannah, A,291307.280.000.007.280.00
Coleman, Logan,1868691.950.000.000.0091.95
Henderson, Ashley,111851381.370.000.00232.801148.57
Diaz, Gabrielle,14893839.480.000.000.00839.48
Perry, Ryan,132494795.340.000.000.004795.34
Baker, Isaiah,12106169.540.000.000.00169.54
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Rodriguez, Taylor,1607166.960.000.000.0066.96
Butler, Dalton, A,133454759.510.000.000.004759.51
Rowe, Todd,14586233.940.000.000.00233.94
Morris, Richard,2007039.980.000.000.0039.98
Rodriguez, Lucas, P,15942191.870.000.000.00191.87
Yuan, Leonard, F,167911729.970.000.000.001729.97
Walker, Richard, T,19640224.550.000.000.00224.55
Carter, Sydney,12959203.920.000.000.00203.92
Nelson, Sierra,161322459.620.000.002459.620.00
Turner, Jose,11784272.690.000.000.00272.69
Garcia, Xavier, M,2030071.970.000.000.0071.97
Thomas, Dylan,198737.280.000.000.007.28
Russell, Xavier,12964119.950.000.000.00119.95
Hill, Blake,11748131.540.000.000.00131.54
Ramirez, Emma,29072128.970.000.000.00128.97
Griffin, Jordan,13095328.890.000.0069.97258.92
Miller, Benjamin, G,26643699.100.00699.100.000.00
Davis, Thomas,167641760.470.000.000.001760.47
Ramos, Derrick,18449100.940.000.0030.9769.97
White, Tyler,14291258.440.000.0049.97208.47
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Butler, Morgan, E,2050068.490.000.000.0068.49
Moore, Seth,138512331.950.000.000.002331.95
Mitchell, Katelyn, A,244964349.610.003578.270.00771.34
Thomas, David,168363193.790.000.000.003193.79
Shan, Logan,1867760.960.000.0029.9930.97
Cooper, Brooke,195361120.490.000.000.001120.49
Alexander, Jason,2932849.990.000.000.0049.99
Mitchell, Savannah,261153052.800.000.002443.35609.45
Ware, Dennis, L,237254828.110.003578.270.001249.84
Watson, Emma,17481126.940.000.000.00126.94
Scott, Sean, F,2475539.980.000.000.0039.98

Generated 2025-11-04 15:05:50.084 UTC