[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
Ross, Natalie, J,12916261.220.000.0068.97192.25
Mehta, Carmen, C,2743694.480.000.000.0094.48
Long, Natalie,14363192.340.000.0014.98177.36
Stewart, Allison, R,18826166.430.000.0069.9996.44
Moore, Wyatt, F,189712351.960.000.000.002351.96
Luo, Franklin, J,2202759.980.000.0059.980.00
Flores, Eduardo, S,2896962.980.000.0062.980.00
Morgan, Abigail, C,244314334.600.003578.27756.330.00
Brown, Nicholas, S,11506675.640.000.00401.27274.37
Hayes, Luis,12880200.730.000.0037.27163.46
Wilson, Fernando,16643126.960.000.00126.960.00
Jai, Edwin,169211754.980.000.001754.980.00
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
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
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
Richardson, Olivia,204683169.590.002049.100.001120.49
Price, Oscar, G,11833240.010.000.0013.98226.03
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Wilson, Eduardo,15323804.470.000.000.00804.47
Griffin, Haley, L,1892582.180.000.0045.2236.96
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
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
Rubio, Kellie,27653128.970.000.00128.970.00
Bennett, Jennifer, G,13708123.940.000.00123.940.00
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
Hall, Eduardo,16847189.940.000.00132.9756.97
Ross, Anna, D,15494275.440.000.00149.97125.47
Alexander, Sarah,1941129.990.000.000.0029.99
Blue, Melanie, L,178611749.960.000.000.001749.96
Rivera, Amanda,11131115.920.000.000.00115.92
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
Jai, Luis, A,18320185.920.000.000.00185.92
Long, Julia, R,228895971.330.003578.270.002393.06
Johnson, Jacob, I,28069553.970.000.000.00553.97
Nelson, Jose,19217185.020.000.00124.5560.47
Gonzalez, Jordan,15157213.940.000.00198.9614.98
Bradley, Jocelyn,230227.280.000.007.280.00
Thomas, Matthew, K,13239185.700.000.0099.4786.23
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
Bennett, Isabelle, C,1867421.980.000.0021.980.00
Watson, Richard,15943365.410.000.00236.44128.97
Phillips, Haley, B,2807939.980.000.000.0039.98
Walker, Charles,11677298.210.000.0021.49276.72
Adams, Miguel,11659213.520.000.0064.97148.55
Roberts, Jordan, M,1680039.250.000.0014.9824.27
Howard, Erin, L,183621725.210.000.000.001725.21
Dominguez, Erika, C,21251191.270.000.0024.99166.28
Thompson, Ethan,199894495.480.003374.990.001120.49
Smith, Justin, P,1982721.980.000.000.0021.98
Bell, Alex, M,167543118.600.000.00756.332362.27
Green, Samuel, D,14096174.730.000.0067.27107.46
Phillips, Luis, G,207347.280.000.007.280.00
Martinez, Andrew, C,11530523.810.000.00327.08196.73
Henderson, Jackson, A,221215997.333578.270.002419.060.00
Turner, Eduardo,158764789.020.000.000.004789.02
Young, Sierra, J,11619634.840.000.00244.70390.14
Collins, Allison,28581119.980.000.000.00119.98
Thompson, Brianna, X,1864269.970.000.0069.970.00
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Baker, Eduardo,180921789.450.000.000.001789.45
Perez, Savannah, J,17036176.950.000.00176.950.00
Coleman, Logan,1868691.950.000.0069.9721.98
Walker, Jasmine,134604693.040.000.002294.992398.05
Gonzales, Ashley, C,1860051.970.000.0021.9829.99
Hughes, Nathan, B,121134737.530.000.004737.530.00
Russell, Oscar, A,12140118.170.000.0032.2885.89
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
Hall, Wyatt,2382713.980.000.000.0013.98
Taylor, Taylor,159054899.020.000.000.004899.02
Nath, Carl, H,29001624.970.000.000.00624.97
Li, Rafael, M,217527.280.000.000.007.28
Perry, Jackson, J,213064.990.000.000.004.99
Turner, Sean,227324133.243578.270.000.00554.97
Martin, Kellie, R,28195574.980.000.000.00574.98
Bell, Chase,180911750.980.000.000.001750.98
Zhang, Heather,166543056.320.000.00751.342304.98
Sanders, Allison, B,18852268.250.000.000.00268.25
Reed, Mariah,263731565.910.001000.440.00565.47
Foster, Edward, R,18355150.950.000.000.00150.95
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Carter, Jason,11724210.090.000.00113.8696.23
Cooper, Angela,195261179.470.000.001179.470.00
Washington, Aaron, L,246494.990.000.004.990.00
Green, Chloe, J,1465892.820.000.0037.2955.53
Mitchell, Katelyn, A,244964349.610.003578.27771.340.00
Lewis, Zachary, L,14760167.260.000.0047.28119.98
Lal, Jack, R,185251735.980.000.000.001735.98
Martin, James, M,1987077.250.000.0039.9837.27
Rodriguez, Natalie,2077330.970.000.000.0030.97
Thompson, Xavier, R,15761192.410.000.000.00192.41
Wright, Robert, C,158894848.030.000.000.004848.03
Morgan, Evan, G,14725318.830.000.00228.8589.98
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Scott, Haley,13701154.540.000.0036.59117.95
White, James,253317.280.000.007.280.00
Gonzales, Miranda,11660324.720.000.00200.74123.98
Barnes, Fernando,113001390.550.000.00480.17910.38
Chapman, Nancy, E,11276840.150.000.00205.68634.47
Bell, Alexandria, A,13758284.130.000.00237.8746.26
Howard, Danielle,28357133.490.000.000.00133.49
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
Clark, Zachary, J,2389358.980.000.0058.980.00
Williams, Zachary, B,27099782.990.00782.990.000.00
Miller, Katherine, B,27102782.990.00782.990.000.00
Townsend, Jeremiah, I,265031000.440.001000.440.000.00
Thomas, Isabella, M,27265782.990.00782.990.000.00
Cooper, Timothy, J,206513198.570.002049.100.001149.47
Ross, Rachel, C,206693169.590.002049.100.001120.49
Diaz, Angela, K,27259782.990.00782.990.000.00
Jai, Connor, D,27253782.990.00782.990.000.00
White, Christopher, R,260492181.560.002181.560.000.00
Butler, Ana,260403018.330.000.003018.330.00
Phillips, Kaylee,211384371.380.000.002049.102322.28
Perez, Angel, S,213362628.350.000.002628.350.00
Adams, Connor,214232888.560.000.002049.10839.46
Kelly, Bryan,213492989.380.000.002989.380.00
Baker, Ian, V,262002756.540.000.002756.540.00
Alexander, Gavin, K,2932249.990.000.000.0049.99
Griffin, Jennifer, B,14244154.960.000.0069.9984.97
Gomez, Briana, A,2878443.980.000.000.0043.98
Morris, Haley, A,2354848.970.000.000.0048.97
Bell, Garrett, J,14265161.230.000.0097.2563.98
Griffin, James,28189567.760.000.000.00567.76
Stewart, Melissa,2517336.960.000.0036.960.00
Moore, Jessica, J,2008576.760.000.0029.9346.83
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
Smith, Chloe,17619163.920.000.0071.9791.95
Foster, Jose, C,2878534.990.000.0034.990.00
Rogers, Carlos,19645134.440.000.00134.440.00
Richardson, Caitlin, T,230576021.820.003578.270.002443.55
Simmons, Dylan,16133107.850.000.0038.8868.97
Gray, Jesse,14626197.040.000.0032.60164.44
Li, Brandon,2933973.960.000.000.0073.96
Brooks, Jacqueline, W,28254166.280.000.00166.280.00
Morgan, Andrea, M,16870149.040.000.00149.040.00
Diaz, Luis, D,11203801.770.000.00469.77332.00
Bradley, Evan,18506101.940.000.0069.9731.97
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
Jenkins, Austin, D,15748296.910.000.00239.9456.97
Bennett, Antonio, C,11631707.500.000.00415.52291.98
Price, Nicole, N,15815141.830.000.0056.9784.86
Chen, David,2720839.980.000.000.0039.98
Miller, Joseph, A,227134148.193578.270.000.00569.92
Russell, Katherine,2877169.990.000.000.0069.99
Martin, Alfredo, P,2148039.980.000.000.0039.98
Simmons, Sarah, V,11500651.980.000.00155.22496.76
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Scott, Kaitlyn, A,12159218.910.000.00203.9314.98
Stewart, Amanda, M,1531094.440.000.0059.5534.89
Richardson, Charles, I,121144719.020.000.004719.020.00
Diaz, Alyssa,139084715.330.000.002294.992420.34
Morgan, Marcus, W,289682.290.000.000.002.29
Barnes, Elizabeth, J,249397.280.000.000.007.28
Alexander, Edward, E,18524195.950.000.000.00195.95
Russell, Samantha,11211723.560.000.00369.40354.16
Sanders, Lucas, W,268024.990.000.004.990.00
Umeda, Masaki,16717233.810.000.00159.3574.46
Long, Elizabeth, F,127822400.950.000.002400.950.00
Perry, Eric,18314115.730.000.00115.730.00
Stewart, Destiny,13144281.470.000.00236.2345.24
Perry, Ana,112151155.520.000.00839.29316.23
Phillips, Mackenzie,12444228.430.000.00228.430.00
Cook, Joan,235544.990.000.004.990.00
Walker, Thomas,1307193.980.000.0063.9929.99
Rogers, Jade, I,14332102.250.000.0044.9957.26
White, Cameron,238304802.110.003578.270.001223.84
Henderson, Ashley,111851381.370.000.00350.911030.46
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
Murphy, Brianna, K,2834269.990.000.0069.990.00
Miller, Jill,129142329.980.000.002329.980.00
Parker, Jordan,216212616.860.000.002616.860.00
Ross, David, M,171431763.970.000.001763.970.00
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
Anderson, Madison, G,2835978.980.000.0078.980.00
Foster, Aaron,155664912.470.000.002430.442482.03
Serrano, Albert, E,133284708.020.000.004708.020.00
Sanders, Megan, A,15376136.240.000.0057.2678.98
Carter, Sydney,12959203.920.000.0034.98168.94
Ruiz, Carrie, D,18644135.440.000.00135.440.00
Coleman, Alexandria, C,1328942.280.000.0037.294.99
Kelly, Erin, D,2351364.470.000.000.0064.47
Campbell, Natalie, L,115122319.990.000.000.002319.99
Torres, Abigail,253674.990.000.000.004.99
Henderson, Luke,19200109.240.000.000.00109.24
Wilson, Chloe, A,11640409.120.000.00199.43209.69
Diaz, Jason,17374206.630.000.0089.46117.17
Sanders, Sean,14341175.150.000.000.00175.15
Bailey, Lauren,15864103.550.000.009.9993.56
Rogers, Jared, J,12166162.220.000.000.00162.22
Brown, Anna,1624795.820.000.000.0095.82
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
Miller, Alexis, A,12196124.930.000.0054.9669.97
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Wilson, Victoria, R,27536782.990.000.00782.990.00

Generated 2026-07-22 11:58:28.160 UTC