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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2023202420252026
Jackson, Charles, P,112771305.660.000.00790.61515.05
Green, Samuel, D,14096174.730.000.0067.27107.46
Cooper, Ariana,17348205.420.000.0084.96120.46
White, Edward, J,15847205.460.000.00119.9885.48
Peterson, Christina,2897694.480.000.0094.480.00
Coleman, Logan,1868691.950.000.0069.9721.98
Clark, Emily, R,120862294.990.000.002294.990.00
Rodriguez, Richard,12969180.790.000.0073.54107.25
Young, Kaylee, S,13756298.490.000.00298.490.00
Brown, Nicholas, S,11506675.640.000.00401.27274.37
Walker, Jasmine,134604693.040.000.002294.992398.05
Watson, Marcus,2271585.480.000.0085.480.00
Sanchez, Lucas, L,233514828.110.003578.271249.840.00
Russell, Isabella, A,11507645.780.000.00278.85366.93
Griffin, Haley, L,1892582.180.000.0045.2236.96
Zhang, Heather,166543056.320.000.00751.342304.98
Hall, Kaylee, E,1975137.270.000.0032.284.99
Hall, Elizabeth, L,13474339.480.000.0083.95255.53
Bailey, Jessica, L,12945218.440.000.0049.97168.47
Moore, Anthony, M,2473039.980.000.0039.980.00
Sanders, Allison, B,18852268.250.000.000.00268.25
Reed, Mariah,263731565.910.001000.440.00565.47
Young, Sierra, J,11619634.840.000.00244.70390.14
Martin, John, A,144364776.010.000.002356.952419.06
Garcia, Henry, B,112871009.240.000.00572.88436.36
Thompson, Kaitlyn, L,12430223.930.000.00148.9574.98
Foster, Edward, R,18355150.950.000.000.00150.95
Rubio, Kellie,27653128.970.000.00128.970.00
Bennett, Jennifer, G,13708123.940.000.00123.940.00
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Carter, Jason,11724210.090.000.00113.8696.23
Zhang, Robert,188551155.480.000.001155.480.00
Moore, Hunter,14897196.270.000.00146.0450.23
Miller, Kayla, A,236734.990.000.004.990.00
Foster, Kayla,1969371.950.000.0071.950.00
Davis, Ethan,136604750.010.000.002351.962398.05
Gomez, Krista,12760273.180.000.00273.180.00
Smith, Lucas, P,1809064.910.000.0064.910.00
Chen, James, D,11641303.200.000.00265.9137.29
Thompson, Tyler,2750269.990.000.0069.990.00
Campbell, Hailey,15507267.840.000.00228.9638.88
Prasad, Donald,15413318.920.000.00198.96119.96
Kelly, Haley,15511128.560.000.00128.560.00
Wright, Carol, C,12928247.410.000.00128.46118.95
Stewart, Alex, M,2008463.150.000.0038.8824.27
Henderson, Stephanie, L,19224352.520.000.00168.04184.48
Torres, Xavier,16840176.950.000.00176.950.00
Russell, Oscar, A,12140118.170.000.0032.2885.89
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Simmons, Elizabeth, A,21461141.980.000.000.00141.98
Garcia, Jonathan,1888386.960.000.0029.9956.97
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Watson, Olivia, S,1386093.850.000.0054.9738.88
Gonzalez, Jordan,15157213.940.000.00198.9614.98
Alexander, Elijah,11738331.680.000.00211.70119.98
Foster, Antonio,12795108.540.000.0066.2642.28
Coleman, Miguel, D,2740069.990.000.0069.990.00
Russell, Ian, T,2474613.980.000.0013.980.00
Hall, Natalie, A,230704.990.000.004.990.00
Wright, Jennifer,2650559.980.000.0059.980.00
Evans, Maria,22544127.280.000.00127.280.00
Bradley, Jocelyn,230227.280.000.007.280.00
Thomas, Matthew, K,13239185.700.000.0099.4786.23
Ross, Jose,2744178.980.000.0078.980.00
Green, Chloe, J,1465892.820.000.0037.2955.53
Washington, Hannah, A,291307.280.000.007.280.00
Phillips, Andrea,1857383.740.000.0083.740.00
Hu, Gilbert, L,2876769.990.000.0069.990.00
Lee, William,13185149.840.000.00117.2432.60
Peterson, Morgan, J,168341750.980.000.001750.980.00
Davis, Austin, E,133664749.040.000.004749.040.00
Carter, Isaac,137191129.480.000.001129.480.00
Prasad, Erick, E,28786127.950.000.00127.950.00
Lal, Kyle,17360122.180.000.0035.2386.95
Alexander, Paige, W,1860459.250.000.0037.2721.98
Bennett, Isabelle, C,1867421.980.000.0021.980.00
Moore, Logan,2634889.970.000.0089.970.00
Watson, Richard,15943365.410.000.00236.44128.97
Scott, Haley,13701154.540.000.0036.59117.95
Phillips, Luis, G,207347.280.000.007.280.00
Martinez, Andrew, C,11530523.810.000.00327.08196.73
Cox, Devin, C,134184768.050.000.002329.992438.06
Gonzalez, Gabriella, Z,15872235.540.000.000.00235.54
Henderson, Jackson, A,221215997.333578.270.002419.060.00
Wilson, Tyler, L,15879196.930.000.00126.9669.97
Collins, Xavier, C,16646250.910.000.000.00250.91
Mitchell, Caleb, K,268064.990.000.000.004.99
Garcia, Anna, B,15572104.550.000.0049.9754.58
Mitchell, Xavier, L,265331629.410.000.001000.44628.97
Thompson, Brianna, X,1864269.970.000.0069.970.00
Powell, Jordyn, K,153914828.010.000.002394.972433.04
Parker, Caleb, A,2631813.980.000.000.0013.98
Morris, Seth,189592341.460.000.000.002341.46
Hayes, Hannah, J,2165656.970.000.000.0056.97
Griffin, Jordan,13095328.890.000.0069.97258.92
Perez, Savannah, J,17036176.950.000.00176.950.00
Thompson, Xavier, R,15761192.410.000.000.00192.41
Patterson, Natalie,16123629.970.000.000.00629.97
Price, Isabelle,201825749.970.003374.990.002374.98
Perry, Olivia,203754438.380.002071.420.002366.96
Blue, Makayla,1900029.990.000.000.0029.99
Jai, Logan, H,12031769.490.000.000.00769.49
Gonzales, Ashley, C,1860051.970.000.0021.9829.99
Hughes, Nathan, B,121134737.530.000.004737.530.00
Miller, Victoria,15816188.020.000.00188.020.00
Alexander, Logan, E,191161183.470.000.001183.470.00
Baker, Sara, M,11827512.470.000.00218.44294.03
Stewart, Sara,17347119.720.000.0021.9897.74
Powell, Miranda, J,153044843.000.000.002369.962473.04
Hughes, Destiny, P,28027119.980.000.000.00119.98
Thomas, Benjamin, J,2129556.970.000.000.0056.97
Murphy, Emma,198445807.933374.990.000.002432.94
Long, Jordyn,1733847.250.000.000.0047.25
Rodriguez, Taylor,1607166.960.000.000.0066.96
Flores, Nathan, C,2463713.980.000.000.0013.98
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Bradley, Alexandria,176911779.470.000.000.001779.47
Hernandez, Jamie,27283119.980.000.00119.980.00
Ward, Kaylee, A,244154.990.000.004.990.00
Stewart, Olivia, B,1874923.780.000.000.0023.78
Evans, Gabriel,2348789.970.000.000.0089.97
Cox, Nathaniel, A,196612521.270.000.000.002521.27
Lewis, Lucas, A,232094802.110.003578.271223.840.00
Parker, Katherine,13268289.700.000.0068.97220.73
Cooper, Angela,195261179.470.000.001179.470.00
Washington, Aaron, L,246494.990.000.004.990.00
Mitchell, Katelyn, A,244964349.610.003578.27771.340.00
Lewis, Zachary, L,14760167.260.000.0047.28119.98
Gonzales, Jose,2201439.980.000.0039.980.00
Ward, Mariah, J,2158044.910.000.0044.910.00
Henderson, Ashley,111851381.370.000.00350.911030.46
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Wilson, Chloe, A,11640409.120.000.00199.43209.69
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Perry, Ana,112151155.520.000.00839.29316.23
Walker, Thomas,1307193.980.000.0063.9929.99
Green, Marcus, C,15974208.410.000.0091.95116.46
Hayes, Logan, J,19026113.240.000.0037.2775.97
Diaz, Luis, D,11203801.770.000.00469.77332.00
Smith, Chloe,17619163.920.000.0071.9791.95
Chen, Jonathan, G,13096200.690.000.000.00200.69
Rogers, Jade, I,14332102.250.000.0044.9957.26
Moore, Jessica, J,2008576.760.000.0029.9346.83
White, Cameron,238304802.110.003578.270.001223.84
Foster, Carson, L,16959135.350.000.00120.3714.98
Harris, Samantha, A,244874.990.000.000.004.99
Richardson, Evan, J,15488165.300.000.0050.23115.07
Washington, Hailey, S,2588559.980.000.000.0059.98
Flores, Stephanie,259922721.550.002181.56539.990.00
Griffin, Melissa, L,287807.950.000.007.950.00
Barnes, Fernando,113001390.550.000.00480.17910.38
Gonzales, Miranda,11660324.720.000.00200.74123.98
Jones, Samantha,1831721.980.000.000.0021.98
Thompson, Madison, L,187882351.960.000.000.002351.96
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Chapman, Nancy, E,11276840.150.000.00205.68634.47
Ward, Cole,214907.280.000.000.007.28
Collins, Amanda,2078339.980.000.000.0039.98
Wood, Brittany,2877753.990.000.000.0053.99
Russell, Samantha,11211723.560.000.00369.40354.16
Reed, Isaac, D,260747.280.000.000.007.28
Isla, Julian, A,13732108.960.000.0073.9635.00
Jones, Charles,22882101.450.000.000.00101.45
Ramirez, Ian,166783162.310.000.00742.352419.96
Barnes, Alexandra, P,222686031.313578.270.000.002453.04
Lal, Robert, L,14084138.680.000.0070.2368.45
Russell, Xavier,12964119.950.000.0029.9989.96
Martin, Xavier,222335997.333578.270.002419.060.00
Howard, Isaiah,259813018.330.002443.35574.980.00
Evans, Kaylee,19642133.540.000.0096.9536.59
Bailey, Richard, N,220504160.533578.270.00582.260.00
Bryant, Isabelle,233974828.110.003578.271249.840.00
Bell, Alexandria, A,13758284.130.000.00237.8746.26
Clark, Zachary, J,2389358.980.000.0058.980.00
Jenkins, Austin, D,15748296.910.000.00239.9456.97
Hayes, Dalton, C,188822322.280.000.000.002322.28
Reed, Melanie, A,28160574.980.000.000.00574.98
Adams, Julia, N,2607359.980.000.000.0059.98
Simmons, Sarah, V,11500651.980.000.00155.22496.76
Murphy, Maria,160113657.260.000.000.003657.26
Allen, Allison, A,1975737.270.000.0032.284.99
Thompson, Isabella,18756128.410.000.000.00128.41
Flores, Kevin,15878225.920.000.0069.97155.95
White, Greg, C,174032322.280.000.000.002322.28
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Stewart, Melissa,2517336.960.000.0036.960.00
Thomas, William, A,216142589.090.000.002589.090.00
Shan, Christian, L,2308439.980.000.0039.980.00
Edwards, Amber, B,2051776.970.000.0076.970.00
Foster, Jose, C,2878534.990.000.0034.990.00
Rogers, Carlos,19645134.440.000.00134.440.00
Rivera, Sara,187852350.960.000.000.002350.96
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Gonzales, Jordan,2368113.980.000.000.0013.98
Reed, Megan, A,181181750.980.000.000.001750.98
Bell, Garrett, J,14265161.230.000.0097.2563.98
Blue, Paige,2170313.980.000.000.0013.98
Phillips, Kyle,12158202.200.000.000.00202.20
Martinez, Jonathan,1330366.250.000.0042.2823.97
Evans, Alexandra,2432268.490.000.000.0068.49
Flores, Emily,13206163.190.000.0069.9793.22
Perez, Timothy, L,227304.990.000.000.004.99
Gomez, Rebekah,13486225.440.000.00104.96120.48
Yang, Jordan, K,14458133.950.000.000.00133.95
Bennett, Antonio, C,11631707.500.000.00415.52291.98
Watson, Devin, A,18875114.950.000.000.00114.95
Price, Riley, R,139094764.020.000.002344.962419.06
Jai, Jose,12944164.210.000.0086.2577.96
Brooks, Jacqueline, W,28254166.280.000.00166.280.00
Morgan, Andrea, M,16870149.040.000.00149.040.00
Bradley, Evan,18506101.940.000.0069.9731.97
Moore, Ian, L,2463939.980.000.000.0039.98
Zukowski, Jake,220584118.263578.270.000.00539.99
Alexander, Edward, E,18524195.950.000.000.00195.95
Torres, Mariah,16380195.950.000.000.00195.95
Price, Caroline,180511735.980.000.000.001735.98
Barnes, Brittany, R,15340156.040.000.0074.4681.58
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Brown, Julia,18065155.470.000.000.00155.47
Patterson, Abigail, H,144784795.010.000.002341.972453.04
Stewart, Destiny,13144281.470.000.00236.2345.24
Bell, Danielle,140414765.020.000.002351.962413.06
Wedge, Andrew, T,120604811.540.000.004811.540.00
Stewart, Garrett, O,15762564.480.000.00564.480.00
Kelly, Angel, E,15418232.230.000.00232.230.00
Rogers, Amanda, A,13920266.970.000.00150.06116.91
Powell, Elijah, E,231135997.330.003578.270.002419.06
Flores, Luke, L,247337.280.000.000.007.28
Phillips, Kaylee,211384371.380.000.002049.102322.28
Ross, Rachel, C,206693169.590.002049.100.001120.49
Williams, Ethan,243094793.120.003578.270.001214.85
Thompson, Abigail,243324816.090.003578.270.001237.82
Thomas, Dalton,230097.280.000.000.007.28
Stewart, Amanda, M,1531094.440.000.0059.5534.89
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Sanders, Sean,14341175.150.000.000.00175.15
Richardson, Charles, I,121144719.020.000.004719.020.00
Rubio, Ruben, D,1887186.960.000.0086.960.00
Martinez, Grace, M,17385208.690.000.0069.97138.72
Flores, Isabelle, A,15526188.320.000.0096.0792.25
Price, Devin, M,18758158.510.000.00158.510.00
Reed, Paige,221126047.323578.270.002469.050.00
Flores, Megan, N,230746021.820.003578.270.002443.55
Madan, Carmen, V,155674720.270.000.000.004720.27
Foster, Aaron,155664912.470.000.002430.442482.03
Jones, Natalie, A,11845197.200.000.0082.26114.94
Alexander, Aidan,17387148.190.000.00148.190.00
Rogers, Andrea, L,14328308.660.000.00155.23153.43
Perry, Samuel,18811100.960.000.00100.960.00

Generated 2026-07-22 19:18:32.952 UTC