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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Wedge, Andrew, T,120604811.540.000.002418.482393.06
Russell, Samantha,11211723.560.000.00118.46605.10
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Watson, Olivia, S,1386093.850.000.0014.9878.87
Gonzalez, Jordan,15157213.940.000.00123.9889.96
Wood, Gavin,16964108.540.000.0093.5614.98
Jenkins, Alexandra, D,11632924.610.000.00160.51764.10
Barnes, Haley, J,2133939.980.000.0039.980.00
Rodriguez, Nicholas, D,14604137.950.000.0058.9778.98
Evans, Alexandra,2432268.490.000.000.0068.49
Yang, Jordan, K,14458133.950.000.000.00133.95
Campbell, Chloe,11212760.930.000.00231.72529.21
Bennett, Antonio, C,11631707.500.000.00216.34491.16
Griffin, Marcus,2075634.560.000.000.0034.56
Watson, Devin, A,18875114.950.000.000.00114.95
Ross, Xavier, A,12202171.470.000.0049.97121.50
Harris, Jacob, G,2367939.980.000.0039.980.00
Russell, Rachel, C,2158124.270.000.0024.270.00
Torres, Taylor,16666205.440.000.00123.9881.46
Jenkins, Samantha,113311290.330.000.00410.31880.02
Garcia, Henry, B,112871009.240.000.00234.49774.75
Alexander, Paige, W,1860459.250.000.0037.2721.98
Turner, Samuel,2742069.990.000.0069.990.00
Chen, Luis, G,2125294.450.000.0094.450.00
Phillips, Isaiah,28631144.470.000.00144.470.00
Harris, Natalie,2368259.980.000.0059.980.00
Nath, Kenneth, W,170372334.970.000.000.002334.97
Simmons, Jennifer,112621010.560.000.00207.93802.63
Coleman, Luke, A,11723152.550.000.0069.9882.57
Adams, Kaitlyn, A,11869239.600.000.0037.27202.33
Nelson, Kevin,1476584.970.000.000.0084.97
Roberts, Robert, R,1898656.970.000.0056.970.00
Zhao, Clarence, R,1982671.970.000.0071.970.00
Harrison, Trevor, A,18055143.910.000.0036.96106.95
Perez, Amber, D,13318214.260.000.00116.9197.35
Lewis, Lucas, A,232094802.110.003578.271223.840.00
Peterson, Steven, L,234497.280.000.007.280.00
Rodriguez, Destiny, J,227397.280.000.007.280.00
Peterson, Brian,12892419.470.000.00156.27263.20
Bailey, Jessica, L,12945218.440.000.000.00218.44
Gutierrez, Neil, L,214897.280.000.000.007.28
Flores, Hannah,1952540.230.000.000.0040.23
Patterson, Maria, G,1333094.950.000.000.0094.95
Ruiz, Carrie, D,18644135.440.000.00100.4634.98
Coleman, Isabel, S,12530337.900.000.00123.98213.92
Prasad, Summer, M,2214339.980.000.0039.980.00
Price, Marissa,15826160.740.000.00120.4840.26
Sharma, Kathryn,20740140.940.000.000.00140.94
Stewart, Amanda, M,1531094.440.000.000.0094.44
Harris, Joshua, L,2028095.940.000.0030.9764.97
Martinez, Grace, M,17385208.690.000.0069.97138.72
Robinson, Emily,12183228.420.000.0054.96173.46
Martinez, Andrew, C,11530523.810.000.00142.94380.87
Flores, Isabelle, A,15526188.320.000.0096.0792.25
Baker, Sara, M,11827512.470.000.00148.47364.00
Collins, Sierra,185491169.460.000.001169.460.00
Green, Blake, P,11719287.200.000.000.00287.20
Ramirez, Sydney,267007.280.000.000.007.28
Cooper, Grace, C,1601294.260.000.000.0094.26
Sandberg, Nicole, M,12077144.690.000.0094.4650.23
Hernandez, Haley, L,11769478.950.000.000.00478.95
Harris, Emily, P,1986298.480.000.000.0098.48
Harris, Isabella,17119214.900.000.0077.96136.94
Powell, Jonathan,238584712.740.003578.271134.470.00
Watson, Cole, A,217684118.263578.270.000.00539.99
Taylor, Madison, A,11802215.290.000.00127.9687.33
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
Morris, Paige, W,220414167.233578.270.000.00588.96
Roberts, Thomas, J,219394163.243578.270.000.00584.97
Griffin, Jason, L,112001267.110.000.00391.08876.03
Zukowski, Jake,220584118.263578.270.000.00539.99
Flores, Zachary, H,233765314.250.003578.270.001735.98
Perry, Jennifer, J,221205962.340.003578.272384.070.00
Morris, Abigail, C,287762.290.000.000.002.29
Martin, Xavier,222335997.330.003578.270.002419.06
Sandberg, Isaac,1335053.970.000.000.0053.97
Brown, Nicholas, S,11506675.640.000.00121.93553.71
Miller, Benjamin, G,26643699.100.00699.100.000.00
Johnson, James,234984.990.000.000.004.99
Rogers, Carlos,19645134.440.000.000.00134.44
Carter, Marcus, l,2147131.970.000.000.0031.97
Lee, Emma,16948176.430.000.000.00176.43
Flores, Emily,13206163.190.000.0069.9793.22
Roberts, Mason, D,111761106.680.000.00494.64612.04
Lewis, Seth,26782699.100.00699.100.000.00
Walker, Charles,11677298.210.000.000.00298.21
Green, Marcus, C,15974208.410.000.0091.95116.46
Chandra, Brandy, P,11501603.530.000.0098.23505.30
Moore, Taylor, A,199874564.450.003374.990.001189.46
Taylor, Ryan,170251709.980.000.000.001709.98
Martin, Gina, E,11078793.270.000.00158.36634.91
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Thomas, Alexandra, C,231724809.390.003578.271231.120.00
Washington, Caroline, D,231145996.320.003578.270.002418.05
Bryant, Isabella, L,229956060.500.003578.270.002482.23
Brooks, Isaac, M,233854829.390.003578.270.001251.12
Sanchez, Lucas, L,233514828.110.003578.270.001249.84
Mitchell, Savannah,261153052.800.000.002443.35609.45
Ware, Dennis, L,237254828.110.003578.270.001249.84
Bryant, Isabelle,233974828.110.003578.270.001249.84
Wilson, Hunter, R,2723013.980.000.000.0013.98
Washington, Vanessa,238194802.110.003578.270.001223.84
Rodriguez, Joshua, A,235114843.110.003578.270.001264.84
Thompson, Abigail,243324816.090.003578.270.001237.82
Chander, Wayne, S,243444329.610.003578.27751.340.00
Wright, Robert, C,158894848.030.000.000.004848.03
Turner, Wyatt,200345769.960.003399.990.002369.97
Russell, Isabella, A,11507645.780.000.0028.48617.30
Mitchell, Katelyn, A,244964349.610.003578.270.00771.34
Price, Isabelle,201825749.970.003374.990.002374.98
Simmons, Sarah, V,11500651.980.000.00118.96533.02
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Sanchez, Mariah, R,1922066.650.000.0038.8827.77
Parker, James,11808610.190.000.00186.77423.42
Cooper, Ariana,17348205.420.000.000.00205.42
Carter, Jason,11724210.090.000.00113.8696.23
Perry, Ryan,132494795.340.000.000.004795.34
Morris, Richard,2007039.980.000.000.0039.98
Hughes, Morgan, T,11642392.890.000.0049.48343.41
Russell, Megan,16220562.960.000.000.00562.96
Bailey, Hailey, R,262704.990.000.000.004.99
Parker, Katherine,13268289.700.000.0068.97220.73
Barnes, Fernando,113001390.550.000.00248.381142.17
Torres, Erin,1218287.250.000.0037.2949.96
Coleman, Jose, S,253494.990.000.000.004.99
Wilson, Fernando,16643126.960.000.000.00126.96
Murphy, Catherine, L,1650692.050.000.000.0092.05
Davis, Daniel,11711999.220.000.0086.48912.74
Thomas, Dylan,198737.280.000.000.007.28
Griffin, Julian, M,113284718.040.000.002319.992398.05
Phillips, Miguel,2049812.940.000.000.0012.94
Garcia, Brandon, V,244184329.610.003578.270.00751.34
Fernandez, Cesar,200355694.980.003374.990.002319.99
Garcia, Victoria, V,245013578.270.003578.270.000.00
Cooper, Stephanie,249762181.560.002181.560.000.00
Griffin, Madison, A,250932181.560.002181.560.000.00
Wood, Alexandria, M,248242181.560.002181.560.000.00
Hughes, Julia,250612443.350.002443.350.000.00
Turner, Amanda, L,203183241.900.002071.420.001170.48
Zhao, Karen, L,254082735.530.002181.560.00553.97
Gomez, Renee, L,253712181.560.002181.560.000.00
Clark, Anthony,27071782.990.00782.990.000.00
Howard, Isaiah,259813018.330.002443.350.00574.98
Cook, Steven, J,27053782.990.00782.990.000.00
Chen, Jackson, S,270751371.950.00782.990.00588.96
Coleman, Lucas, A,27060782.990.00782.990.000.00
Gonzales, Melissa, W,204704408.690.000.002071.422337.27
Taylor, Christian,2076456.760.000.000.0056.76
Carter, Sydney,12959203.920.000.000.00203.92
Smith, Justin, P,1982721.980.000.000.0021.98
Miller, Alexis, A,12196124.930.000.000.00124.93
Umeda, Masaki,16717233.810.000.000.00233.81
Moore, Matthew, W,13267109.950.000.000.00109.95
Turner, Jose,11784272.690.000.000.00272.69
Ward, Jade, D,14661195.020.000.000.00195.02
Smith, Samuel, D,2308349.900.000.000.0049.90
Walker, Brandon, J,159164793.270.000.000.004793.27
Walker, Jasmine,134604693.040.000.000.004693.04
Foster, Edward, R,18355150.950.000.000.00150.95
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Scott, Sean, F,2475539.980.000.000.0039.98
Foster, Isabel, M,2174571.950.000.000.0071.95
Taylor, Zachary, M,27082782.990.000.00782.990.00
Ross, Rachel, C,206693169.590.000.002049.101120.49
Diaz, Angela, K,27259782.990.000.00782.990.00
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Washington, Taylor,212664525.070.000.002049.102475.97
Ward, Nicole, L,212724435.380.000.002071.422363.96
Davis, Emily,27267782.990.000.00782.990.00
Patterson, Alexis,213484392.020.000.002049.102342.92
Adams, Connor,214232888.560.000.002049.10839.46
Ward, Juan, H,215952649.560.000.002049.10600.46
Miller, Eduardo,14561158.840.000.0049.97108.87
Jenkins, Megan, R,12074261.380.000.000.00261.38
Serrano, Albert, E,133284708.020.000.000.004708.02
Reed, Judith, D,2534759.980.000.000.0059.98
Perry, Natalie,1712669.990.000.000.0069.99
Diaz, Richard, A,2668264.470.000.000.0064.47
Hayes, Hannah, J,2165656.970.000.000.0056.97
White, Tyler,14291258.440.000.0049.97208.47
Thomas, David,168363193.790.000.000.003193.79
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Phillips, Devin,18759112.060.000.000.00112.06
Ward, Emma, W,2179659.980.000.000.0059.98
White, Emily, M,159174679.060.000.000.004679.06
Alexander, Edward, E,18524195.950.000.000.00195.95
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Powell, Caleb, G,216132610.580.000.002049.10561.48
Brooks, Mariah,216202620.400.000.002071.42548.98
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Wilson, Victoria, R,27536782.990.000.00782.990.00
King, Jordan, C,110202316.970.000.002316.970.00
Martinez, Matthew, L,16009170.450.000.000.00170.45
Powell, Angela, R,12970471.110.000.000.00471.11
Taylor, Natalie, M,14338828.740.000.000.00828.74
Martin, John, A,144364776.010.000.000.004776.01
Turner, Jeremiah, F,19207791.320.000.000.00791.32
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Russell, Elijah, M,118354772.300.000.002319.262453.04
Lal, Caleb, R,1586874.460.000.000.0074.46
Brown, Fernando,1900191.950.000.0069.9721.98
Parker, Morgan, S,1677236.960.000.0014.9821.98
Gray, Mariah,222787.280.000.007.280.00
Hall, Jan, M,11740334.120.000.00235.1598.97
Lee, William,13185149.840.000.0069.9779.87
Campbell, Adam, A,214002688.890.000.002071.42617.47
Kelly, Angel, E,15418232.230.000.000.00232.23
Foster, Kayla,1969371.950.000.000.0071.95
Brooks, Lucas, S,16089342.030.000.000.00342.03
Smith, Lucas, P,1809064.910.000.000.0064.91
Evans, Dalton, E,127104774.040.000.002354.982419.06
Bell, Alex, M,167543118.600.000.00756.332362.27
Cook, Jacqueline, A,1922360.370.000.0021.4938.88
Gill, Robyn, J,127651750.980.000.001750.980.00
Morgan, Jada, A,11520702.990.000.00137.45565.54
Sanchez, Allison,1666741.720.000.000.0041.72
Bradley, Evan,18506101.940.000.000.00101.94
Nath, Yolanda, A,2462513.980.000.000.0013.98
Foster, Emma,15468436.350.000.00159.99276.36
Davis, Jonathan,2925913.980.000.000.0013.98
Ramirez, Abigail, S,1585974.140.000.000.0074.14
Powell, Jasmine, A,11505846.770.000.00105.05741.72
Kelly, Haley,15511128.560.000.000.00128.56
Wilson, Nathan, L,13936218.930.000.000.00218.93
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Coleman, Spencer,15993597.260.000.000.00597.26
Perry, Ana,112151155.520.000.00432.39723.13
Lal, Luke, L,11019698.230.000.00139.93558.30
Sun, Arturo, C,11498557.540.000.00151.90405.64
Garcia, Alexandra, J,14107819.460.000.00819.460.00
James, Juan,232674862.090.003578.271283.820.00
Hill, Jordan, J,16005198.730.000.00102.2796.46
Gray, Brianna,249603008.820.002443.35565.470.00
Peterson, Melissa, S,249954.990.000.004.990.00
Martin, Joshua, A,276077.280.000.007.280.00
Patterson, Hailey, I,112231155.900.000.00267.62888.28
Robinson, Madison, W,183772394.970.000.000.002394.97
Rubio, Jaime, R,15007209.830.000.0049.97159.86
Carter, Jose, H,12532235.720.000.000.00235.72
Sanchez, Rachel, C,267304.990.000.000.004.99
Brown, Isabella, L,266921266.860.00699.100.00567.76
James, Zoe, R,14611304.550.000.000.00304.55
Hughes, Luke, I,270141274.080.00699.100.00574.98
Perez, Katherine, J,2207924.270.000.000.0024.27
Moreno, Renee, C,12936265.220.000.000.00265.22
Hughes, Eduardo,15564188.520.000.000.00188.52
Sanders, Paige,252872983.340.002443.350.00539.99
Young, Sierra, J,11619634.840.000.0034.99599.85
Rodriguez, Alexis, L,15244179.190.000.0042.28136.91
Thompson, Brianna, X,1864269.970.000.000.0069.97

Generated 2025-10-31 09:59:44.496 UTC