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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Foster, Antonio,12795108.540.000.0028.9979.55
Allen, Aaron, A,200753399.990.003399.990.000.00
Henderson, Gabrielle, B,186031205.470.000.000.001205.47
Wright, Jennifer,2650559.980.000.0059.980.00
Kumar, Cameron, S,185711120.490.000.000.001120.49
Peterson, Alex, M,13423132.900.000.000.00132.90
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Johnson, Christopher,119794813.760.000.000.004813.76
Alexander, Jason,2932849.990.000.000.0049.99
Diaz, Luis, D,11203801.770.000.000.00801.77
Bailey, Hailey, R,262704.990.000.000.004.99
Adams, Kyle, E,1881269.990.000.000.0069.99
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Peterson, Melissa, S,249954.990.000.000.004.99
Hu, Gilbert, L,2876769.990.000.000.0069.99
Howard, Morgan, T,229713578.270.003578.270.000.00
Nelson, Henry,193941155.480.000.000.001155.48
Alexander, Logan, E,191161183.470.000.000.001183.47
Evans, Elijah, S,2588439.980.000.000.0039.98
Blanco, Armando, F,139182397.950.000.000.002397.95
Russell, Jacqueline,18391100.960.000.000.00100.96
Stewart, Destiny,13144281.470.000.000.00281.47
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Ross, Aaron, N,118882376.960.000.000.002376.96
Lee, Emma,16948176.430.000.000.00176.43
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Bailey, Jessica, L,12945218.440.000.000.00218.44
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Wilson, Nathan, L,13936218.930.000.000.00218.93
Cook, Joan,235544.990.000.000.004.99
Washington, Victoria,235577.280.000.000.007.28
Green, Blake, P,11719287.200.000.000.00287.20
Foster, Caleb,27112114.460.000.000.00114.46
Ross, Kelly,2607676.960.000.000.0076.96
Stewart, Alex, M,2008463.150.000.000.0063.15
Henderson, Sarah, M,238674802.110.003578.270.001223.84
Robinson, Ian, D,138522294.990.000.000.002294.99
Long, Julia, R,228895971.330.003578.270.002393.06
Gomez, Rebekah,13486225.440.000.000.00225.44
Martinez, Grace, M,17385208.690.000.000.00208.69
McDonald, Aaron, J,27734119.980.000.000.00119.98
Adams, Connor,214232888.560.000.002049.10839.46
Peterson, Jared,11502829.370.000.0053.99775.38
Hall, Morgan,2172641.950.000.000.0041.95
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Rodriguez, Richard,12969180.790.000.000.00180.79
Sanchez, Rachel, C,267304.990.000.000.004.99
Richardson, Arianna, C,1205534.980.000.000.0034.98
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Prasad, Donald,15413318.920.000.00123.98194.94
Brown, Nicholas, S,11506675.640.000.000.00675.64
Xu, Louis,2010466.530.000.000.0066.53
Henderson, Hailey, C,171481775.470.000.000.001775.47
Carter, Jason,11724210.090.000.0071.58138.51
Bell, Alex, M,167543118.600.000.000.003118.60
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Russell, Samuel, V,11652310.930.000.000.00310.93
Lopez, Eduardo, J,266401288.060.00699.100.00588.96
Murphy, Richard, M,222994145.540.003578.270.00567.27
Deng, Damien, A,16873578.460.000.000.00578.46
Campbell, Isabella, C,203503226.900.000.002071.421155.48
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
White, Nicole,16731155.910.000.000.00155.91
Richardson, Evan, J,15488165.300.000.000.00165.30
Alexander, Jordan,2141259.980.000.0059.980.00
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Davis, Thomas,167641760.470.000.000.001760.47
Cooper, Ariana,17348205.420.000.000.00205.42
Davis, James,11922275.500.000.000.00275.50
Baker, Allison,2649558.980.000.000.0058.98
Green, Sophia, E,249772181.560.002181.560.000.00
Collins, Sierra,185491169.460.000.000.001169.46
Ruiz, Carrie, D,18644135.440.000.000.00135.44
Ward, Juan, H,215952649.560.000.002049.10600.46
Ms., Coleman, Abigail, C,238684829.390.003578.270.001251.12
Luo, Franklin, J,2202759.980.000.000.0059.98
Hayes, Logan, J,19026113.240.000.000.00113.24
Carter, Sydney,12959203.920.000.000.00203.92
Li, Kevin, S,2518813.980.000.000.0013.98
King, Aaron, L,117394758.030.000.002359.982398.05
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Diaz, Thomas, O,16020595.960.000.000.00595.96
Butler, Victoria,132844767.530.000.000.004767.53
Flores, Brittany,169062359.980.000.000.002359.98
Cook, Seth,2301064.470.000.000.0064.47
Powell, Ian,2608564.470.000.000.0064.47
Powell, Blake, J,2237139.980.000.000.0039.98
Martin, Jill, C,11824181.030.000.000.00181.03
Perry, Jonathan, T,27026699.100.00699.100.000.00
Martinez, Hannah, M,246664370.610.003578.270.00792.34
Brooks, Lucas, S,16089342.030.000.000.00342.03
Wilson, Tyler, L,15879196.930.000.000.00196.93
Thomas, Victoria, A,15536249.530.000.000.00249.53
Hall, Elizabeth, L,13474339.480.000.000.00339.48
Sanchez, Martin, E,216317.280.000.000.007.28
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Jones, Joshua,184012294.990.000.000.002294.99
Simmons, Elizabeth, A,21461141.980.000.000.00141.98
Harris, Matthew,14330806.760.000.000.00806.76
Morris, Paige, W,220414167.233578.270.000.00588.96
Harris, Joshua, L,2028095.940.000.000.0095.94
Green, Eric,2738069.990.000.000.0069.99
Collins, Isaac,260777.280.000.000.007.28
Evans, Connor, J,15402131.550.000.000.00131.55
Brooks, Evan,2340139.980.000.000.0039.98
Lal, Jonathan,2009671.460.000.000.0071.46
Morgan, Marcus, W,289682.290.000.000.002.29
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Ross, Alexia, S,13231247.900.000.000.00247.90
Zhang, Robert,188551155.480.000.000.001155.48
Moreno, Marie,2773969.990.000.000.0069.99
Johnson, Anthony, D,270224.990.000.000.004.99
Powell, Katherine, C,14574177.600.000.000.00177.60
Fernandez, Darren,2899278.980.000.000.0078.98
Price, Marissa,15826160.740.000.000.00160.74
Hill, Jordan, J,16005198.730.000.000.00198.73
Ward, Ian,12056213.920.000.000.00213.92
Hernandez, Sierra,27393123.980.000.000.00123.98
Collins, Eduardo,139872329.990.000.000.002329.99
Jackson, Hannah, G,131432404.970.000.000.002404.97
Wilson, Madison, H,1982821.980.000.000.0021.98
James, Julia,2497567.930.000.000.0067.93
Simmons, Sarah, V,11500651.980.000.0034.99616.99
Gonzalez, Molly,1637021.980.000.000.0021.98
Long, Jordan,199884555.470.003399.990.001155.48
Moore, Matthew, W,13267109.950.000.000.00109.95
Rivera, Makayla, A,2878334.990.000.000.0034.99
Morris, Chase, F,26789699.100.00699.100.000.00
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Long, Xavier,112512318.960.000.000.002318.96
Allen, Luke,113162349.980.000.002349.980.00
Ortega, Javier, P,127852294.990.000.000.002294.99
Rogers, Jade, I,14332102.250.000.000.00102.25
Long, Gabrielle,198305765.920.003374.990.002390.93
Stewart, Julia, L,129022329.980.000.000.002329.98
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Mitchell, Caleb, K,268064.990.000.000.004.99
Stewart, Melissa,2517336.960.000.000.0036.96
Allen, Allison, A,1975737.270.000.000.0037.27
Nelson, Katherine,2802178.980.000.000.0078.98
Perry, Marcus, L,206563245.900.000.002071.421174.48
Martin, Katherine, J,2027339.980.000.000.0039.98
Griffin, Jason, L,112001267.110.000.00193.891073.22
Dominguez, Meghan,14370122.560.000.000.00122.56
Turner, Amanda, L,203183241.900.002071.420.001170.48
Gray, Jared, A,264494.990.000.000.004.99
Jones, Nicole,14504112.270.000.000.00112.27
Stewart, Alexandria,174761700.990.000.000.001700.99
Washington, Ryan,2833294.480.000.000.0094.48
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Rodriguez, Morgan,237304828.110.003578.270.001249.84
Edwards, Elijah, D,281577.280.000.000.007.28
Thomas, William, A,216142589.090.000.002049.10539.99
Reed, Isaac, D,260747.280.000.000.007.28
Cook, Bryce,2864069.990.000.000.0069.99
Williams, Austin,2035432.220.000.000.0032.22
Ross, Haley, T,253612443.350.002443.350.000.00
Howard, Natalie,1349154.960.000.0014.9839.98
Fernandez, Ruth,205463246.550.000.002049.101197.45
Russell, Oscar, A,12140118.170.000.000.00118.17
Thomas, Seth,14567161.280.000.0096.0765.21
Patterson, Aaron, W,191131184.460.000.000.001184.46
Johnson, Madison, L,15530846.460.000.000.00846.46
White, Jennifer, S,27027782.990.00782.990.000.00
Watson, Devin, A,18875114.950.000.000.00114.95
Hernandez, Jonathan, J,1901465.950.000.000.0065.95
Foster, Alyssa, I,14875839.480.000.000.00839.48
Alexander, Nathan, A,187951198.970.000.000.001198.97
Martinez, Wyatt, R,228815997.330.003578.270.002419.06
Perry, Oscar,227856029.570.003578.272451.300.00
Foster, Olivia,238063578.270.003578.270.000.00
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Johnson, Cameron, R,137201155.480.000.000.001155.48
Richardson, Brian,2860878.980.000.000.0078.98
Parker, Natalie, A,251043018.330.000.002443.35574.98
Cooper, Alexandra,19541131.240.000.000.00131.24
Ruiz, Philip,1807781.460.000.000.0081.46
Baker, Gabriella,174041709.980.000.000.001709.98
Hernandez, Marcus,185952329.990.000.000.002329.99
Stewart, Olivia, B,1874923.780.000.000.0023.78
Lobao, Alexandre,1892691.950.000.000.0091.95
Collins, Charles, B,29041628.450.000.000.00628.45
White, Emma, N,16090604.960.000.000.00604.96
Hughes, Julia,250612443.350.002443.350.000.00
She, Alisha, G,247574343.590.003578.270.00765.32
Torres, Haley, W,232834828.110.003578.270.001249.84
Miller, Alexis, A,12196124.930.000.000.00124.93
Morgan, Andrea, M,16870149.040.000.0039.47109.57
Clark, Emily, R,120862294.990.000.000.002294.99
Richardson, Nathaniel,120894710.030.000.002316.972393.06
Thomas, Dalton,230097.280.000.000.007.28
Flores, Emma, P,15543180.940.000.000.00180.94
Powell, Jasmine, A,11505846.770.000.000.00846.77
Kelly, Haley,15511128.560.000.000.00128.56
Lopez, Jack, I,2904751.460.000.000.0051.46
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Washington, Hailey, S,2588559.980.000.000.0059.98
Nelson, Sean,11841307.970.000.000.00307.97
Moreno, Meredith, D,2228589.970.000.000.0089.97
Wilson, Emily,174002331.950.000.000.002331.95
Rodriguez, Brianna, J,222674167.230.003578.270.00588.96
Wood, Brittany,2877753.990.000.000.0053.99
Martin, Gina, E,11078793.270.000.000.00793.27
White, James,253317.280.000.000.007.28
Hughes, Riley,2928449.990.000.000.0049.99
Foster, Jessica,2606951.460.000.000.0051.46
Zhao, Clarence, R,1982671.970.000.000.0071.97
Thompson, Devin,207084406.400.000.002071.422334.98
Campbell, Alex,119844730.320.000.000.004730.32
Cox, Katelyn, B,2174230.970.000.000.0030.97
Flores, Jordyn,252882721.550.000.002181.56539.99
Bryant, Zachary,216552648.070.000.002049.10598.97
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Roberts, Noah, S,2704268.490.000.000.0068.49
Simmons, Dylan,16133107.850.000.0038.8868.97
Richardson, Devin, G,2131836.960.000.000.0036.96
Jenkins, Megan, R,12074261.380.000.000.00261.38
Winston, Ethan, R,216222612.060.000.002049.10562.96
Roberts, Carlos,2319639.980.000.000.0039.98
Navarro, Jerome, B,11519717.280.000.000.00717.28
Hayes, Oscar,2652729.260.000.000.0029.26
Ramirez, Abigail, S,1585974.140.000.000.0074.14
Taylor, Tyler, A,12032614.960.000.000.00614.96
Collins, Allison,28581119.980.000.000.00119.98
Williams, Ryan, R,222475978.610.003578.270.002400.34
Miller, Kayla, A,236734.990.000.000.004.99
Harrison, Trevor, A,18055143.910.000.000.00143.91
Barnes, Kayla,2425639.980.000.000.0039.98
Jai, Samuel, L,1635887.950.000.000.0087.95
Collins, Xavier, C,16646250.910.000.000.00250.91
Martinez, Joseph, E,2921459.980.000.000.0059.98
Peterson, Brian,12892419.470.000.000.00419.47
Perry, Eric,18314115.730.000.000.00115.73
Li, Thomas,181162376.960.000.000.002376.96
Garcia, Hunter, J,213053204.580.000.002049.101155.48
Hughes, Nathan, B,121134737.530.000.000.004737.53
Martin, John, A,144364776.010.000.000.004776.01
Li, Jordan,17026261.390.000.000.00261.39
Cox, Arianna, D,1892789.250.000.000.0089.25
Rivera, Rachel, S,2899678.980.000.000.0078.98
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Anderson, Jasmine, A,235534.990.000.000.004.99
Butler, Cassidy, L,21792114.460.000.000.00114.46
Hayes, Jeremiah, W,20086128.550.000.000.00128.55
Harris, Edward,27062782.990.000.00782.990.00
Mitchell, Alexandra,14455218.930.000.000.00218.93
Sanchez, Jeremiah, E,2226521.980.000.000.0021.98
James, Juan,232674862.090.003578.270.001283.82

Generated 2025-12-21 22:32:18.568 UTC