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

382 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Parker, Amanda,1808151.970.000.000.0051.97
James, Christina,17409219.920.000.000.00219.92
Fernandez, Cesar,200355694.980.003374.990.002319.99
Smith, Noah,13175166.920.000.000.00166.92
Cox, Nathaniel, A,196612521.270.000.000.002521.27
Robinson, William,20103103.480.000.000.00103.48
Cox, Devin, C,134184768.050.000.000.004768.05
Murphy, Juan, T,246463578.270.003578.270.000.00
Garcia, Victoria, V,245013578.270.003578.270.000.00
Garcia, Carmen, J,247812181.560.002181.560.000.00
Thomas, Charles,250942443.350.002443.350.000.00
Richardson, Victoria, C,248172181.560.002181.560.000.00
Gray, Brianna,249603008.820.002443.350.00565.47
Gray, Alexandria, E,253632443.350.000.002443.350.00
Carter, Luis, E,258832443.350.000.002443.350.00
Gomez, Renee, L,253712181.560.000.002181.560.00
Murphy, Dalton, N,27043782.990.000.00782.990.00
Harris, Edward,27062782.990.000.00782.990.00
Robinson, Zachary, L,137092332.280.000.000.002332.28
Richardson, Brian,2860878.980.000.000.0078.98
Hill, Alexandra, K,15172215.450.000.0036.27179.18
Foster, Antonio,12795108.540.000.0028.9979.55
Clark, Joseph, D,153954780.020.000.000.004780.02
White, Nicole,16731155.910.000.000.00155.91
Moore, Jessica, J,2008576.760.000.000.0076.76
Rivera, Allison, M,13751224.910.000.000.00224.91
Simmons, Adam,253274.990.000.000.004.99
Gonzalez, Logan, J,1748364.500.000.000.0064.50
Evans, Connor, J,15402131.550.000.000.00131.55
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Allen, Luke,113162349.980.000.002349.980.00
Alexander, Luke,290432447.050.000.002447.050.00
Garcia, Chloe, M,110372374.230.000.002374.230.00
Stewart, Garrett, O,15762564.480.000.000.00564.48
Gonzales, Kayla,214947.280.000.000.007.28
Russell, Samuel, V,11652310.930.000.000.00310.93
Foster, Caleb,27112114.460.000.000.00114.46
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Kelly, Trinity,2609515.230.000.000.0015.23
Sanchez, Shelby,16021539.990.000.000.00539.99
Perry, Natalie,1712669.990.000.000.0069.99
Russell, Melanie, B,15478182.830.000.0038.88143.95
Flores, Caleb, S,12165280.640.000.00159.47121.17
Hayes, Hannah, J,2165656.970.000.000.0056.97
Nelson, Jordan, H,201304.990.000.004.990.00
Adams, Carlos,1982236.960.000.000.0036.96
Washington, Emma,191231170.480.000.000.001170.48
Martin, Christian, V,19709197.250.000.000.00197.25
Sanders, Lucas, W,268024.990.000.000.004.99
Flores, Cassidy, L,233684.990.000.000.004.99
Coleman, Miguel, D,2740069.990.000.0069.990.00
Sharma, Kathryn,20740140.940.000.000.00140.94
Russell, Ian, T,2474613.980.000.0013.980.00
Wright, Jennifer,2650559.980.000.0059.980.00
Harris, Jacob, G,2367939.980.000.000.0039.98
Alexander, Paige, W,1860459.250.000.000.0059.25
Turner, Andrea, A,202093268.550.002049.100.001219.45
Ross, Miranda,145984839.000.000.000.004839.00
Lee, Samantha, B,2737878.980.000.000.0078.98
Chen, Jonathan, G,13096200.690.000.000.00200.69
James, Julia,2497567.930.000.000.0067.93
Gonzales, Ashley, C,1860051.970.000.000.0051.97
Edwards, Eric,2462768.490.000.000.0068.49
Williams, Ryan, R,222475978.610.003578.270.002400.34
Powell, Spencer,14904468.120.000.000.00468.12
Ross, Anna, D,15494275.440.000.000.00275.44
Rogers, Carlos,19645134.440.000.000.00134.44
Henderson, Gabrielle, B,186031205.470.000.000.001205.47
Walker, Hunter,271007.280.000.000.007.28
Green, Gabrielle, M,2181564.470.000.000.0064.47
Wilson, Andrew, R,182362414.990.000.000.002414.99
Jones, Nicole,14504112.270.000.000.00112.27
Davis, Nicholas,1320173.160.000.000.0073.16
Wilson, Nathan, L,13936218.930.000.000.00218.93
Anderson, Lucas,2926639.980.000.000.0039.98
Bailey, Morgan, E,213542646.400.000.002071.42574.98
Wilson, Fernando,16643126.960.000.000.00126.96
Rogers, Amanda, A,13920266.970.000.000.00266.97
Thomas, Dylan,198737.280.000.000.007.28
Washington, Kayla, E,14655174.960.000.000.00174.96
Flores, Logan, K,14631848.470.000.000.00848.47
Harris, Emily, P,1986298.480.000.000.0098.48
Mitchell, Savannah,261153052.800.000.002443.35609.45
Davis, James,11922275.500.000.000.00275.50
She, Kenneth,16096212.010.000.000.00212.01
Richardson, Melissa, E,111322371.940.000.000.002371.94
Walker, John, M,2858969.990.000.000.0069.99
Lu, Alejandro,2562039.980.000.000.0039.98
Watson, Emma,17481126.940.000.000.00126.94
Rivera, Caitlin, L,261132730.540.000.002181.56548.98
Diaz, Luke,12054402.530.000.00124.99277.54
Martin, Lucas, L,221144183.230.003578.270.00604.96
Mitchell, Jonathan, L,221095971.330.003578.272393.060.00
Morris, Mason, J,22349124.990.000.000.00124.99
Gonzalez, Katherine,222345976.320.003578.270.002398.05
Wilson, Madison, H,1982821.980.000.000.0021.98
Turner, Sean,227324133.240.003578.270.00554.97
Ramos, Derrick,18449100.940.000.000.00100.94
Murphy, Richard, M,222994145.540.003578.270.00567.27
Taylor, Marcus, A,18944146.940.000.000.00146.94
Perry, Oscar,227856029.570.003578.272451.300.00
Zhao, Clarence, R,1982671.970.000.000.0071.97
Moore, Taylor, A,199874564.450.003374.990.001189.46
Lopez, Bailey, R,185571179.470.000.000.001179.47
Howard, Morgan, T,229713578.270.003578.270.000.00
Perez, Amber, D,13318214.260.000.000.00214.26
Long, Julia, R,228895971.330.003578.270.002393.06
Peterson, Steven, L,234497.280.000.000.007.28
Simmons, James,198844588.450.003399.990.001188.46
Diaz, Ryan, J,16910141.960.000.000.00141.96
Miller, Chloe, V,228936056.510.003578.270.002478.24
Zhang, Connor, R,138532329.980.000.000.002329.98
Thomas, Alexandra, C,231724809.390.003578.270.001231.12
Perez, Jonathan, R,2345512.940.000.000.0012.94
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Ruiz, Carrie, D,18644135.440.000.000.00135.44
Robinson, Abigail, R,183792362.270.000.000.002362.27
Martinez, Joseph, E,2921459.980.000.000.0059.98
Chavez, Kara, P,13285214.350.000.000.00214.35
Anderson, Madison, G,2835978.980.000.000.0078.98
Prasad, Molly,243924329.610.003578.270.00751.34
Lewis, Jeremiah,1437187.260.000.000.0087.26
Parker, Natalie, A,251043018.330.000.002443.35574.98
Srini, Evelyn,16855150.950.000.000.00150.95
Hill, Fernando,247634.990.000.000.004.99
Foster, Nicole, A,2349489.970.000.000.0089.97
Serrano, Albert, E,133284708.020.000.000.004708.02
Cannata, Gabrielle, C,217254.990.000.000.004.99
Gonzales, Luis,15856116.250.000.0037.2778.98
Martinez, Grace, M,17385208.690.000.000.00208.69
Bryant, Samantha,18345115.470.000.000.00115.47
Perry, Samuel,18811100.960.000.000.00100.96
Lopez, Isaiah,18968151.430.000.000.00151.43
Johnson, Xavier, R,2325539.980.000.000.0039.98
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Perry, Benjamin,291652407.040.000.000.002407.04
Henderson, Sarah, M,238674802.110.003578.270.001223.84
Peterson, Isabella,2808039.980.000.000.0039.98
Bradley, Melanie, G,133434720.270.000.000.004720.27
Mohamed, Samantha, A,292772419.060.000.000.002419.06
Walker, Emma, M,2520998.960.000.000.0098.96
Perez, Charles,266937.280.000.000.007.28
Torres, Mariah,16380195.950.000.000.00195.95
Foster, Jessica,2606951.460.000.000.0051.46
Stewart, Grace, H,247737.280.000.000.007.28
Hughes, Caroline, C,2830278.980.000.000.0078.98
Kelly, Angel, E,15418232.230.000.000.00232.23
Butler, Jackson, J,183241735.980.000.000.001735.98
Long, Gavin,13762186.030.000.000.00186.03
Kelly, Bailey, R,28284563.770.000.000.00563.77
Allen, Madeline,2924068.970.000.000.0068.97
Ward, Lucas, N,183631700.990.000.000.001700.99
Gomez, Briana, A,2878443.980.000.000.0043.98
Roberts, Wyatt,15900699.970.000.000.00699.97
Carter, Jesse, E,22141166.280.000.000.00166.28
Li, Brandon,2933973.960.000.000.0073.96
Washington, Adam, G,2543713.980.000.000.0013.98
Campbell, Timothy,2584513.980.000.000.0013.98
Sanchez, Jeremiah, E,2226521.980.000.000.0021.98
Murphy, Maria,160113657.260.000.000.003657.26
Williams, Joshua,260514.990.000.000.004.99
Chen, David,2720839.980.000.000.0039.98
Perez, Timothy, L,227304.990.000.000.004.99
Baker, Robert, A,273007.280.000.000.007.28
Russell, Katherine,2877169.990.000.000.0069.99
Martin, Alfredo, P,2148039.980.000.000.0039.98
James, Zoe, R,14611304.550.000.000.00304.55
Garcia, Alexandra, J,14107819.460.000.000.00819.46
Brown, Julia,18065155.470.000.000.00155.47
Harris, Noah,292562393.060.000.000.002393.06
Nath, Kenneth, W,170372334.970.000.000.002334.97
Stewart, Lucas, J,2934198.970.000.000.0098.97
Brooks, Steven, C,14877889.470.000.000.00889.47
Gutierrez, Neil, L,214897.280.000.000.007.28
Edwards, Elijah, D,281577.280.000.000.007.28
Brooks, Evan,2340139.980.000.000.0039.98
Butler, Jonathan,261804.990.000.000.004.99
Sanders, Zoe, L,248254.990.000.000.004.99
Sanchez, Katherine, S,24399132.940.000.000.00132.94
Young, Courtney,176222374.980.000.000.002374.98
Alvarez, Melody,2507068.490.000.000.0068.49
Lee, Kayla, M,2078115.230.000.000.0015.23
Parker, Kaylee, M,2773878.980.000.000.0078.98
Sanders, Mason, G,2345939.980.000.000.0039.98
Edwards, Alexandra,133582386.940.000.000.002386.94
Bailey, Maria, C,1915034.980.000.000.0034.98
Reed, Morgan, E,2877923.970.000.000.0023.97
Baker, Gabriella,174041709.980.000.000.001709.98
Stewart, Marcus, R,2063221.980.000.000.0021.98
Garcia, Xavier, M,2030071.970.000.000.0071.97
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Martin, Katherine, J,2027339.980.000.000.0039.98
Flores, Brandon, L,2562189.970.000.000.0089.97
Nath, Yolanda, A,2462513.980.000.000.0013.98
Davis, Jonathan,2925913.980.000.000.0013.98
Perez, Barry, M,2728269.990.000.000.0069.99
Gray, Marcus, T,183892401.450.000.000.002401.45
Jackson, Andrew,2047985.480.000.000.0085.48
Rogers, Olivia,12020804.470.000.000.00804.47
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Johnson, Ian, E,2173283.470.000.000.0083.47
Coleman, Isabel, S,12530337.900.000.000.00337.90
Simmons, Elizabeth, A,21461141.980.000.000.00141.98
Gill, Beth,199975814.980.003374.990.002439.99
Sanders, Megan, A,15376136.240.000.000.00136.24
Powell, Blake, J,2237139.980.000.000.0039.98
Morris, Chase, F,26789699.100.00699.100.000.00
Lewis, Lucas, A,232094802.110.003578.270.001223.84
Bryant, Kyle,231644807.100.003578.270.001228.83
Thompson, Ethan,199894495.480.003374.990.001120.49
Anderson, Megan, A,238594153.250.003578.27574.980.00
Thompson, Abigail,243324816.090.003578.270.001237.82
Williams, Ethan,243094793.120.003578.270.001214.85
Allen, Aaron, A,200753399.990.003399.990.000.00
Mitchell, Katelyn, A,244964349.610.003578.270.00771.34
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Foster, Trevor, J,2896469.990.000.000.0069.99
Gonzalez, Gabriella, Z,15872235.540.000.000.00235.54
Thompson, Blake,18390141.960.000.000.00141.96
Green, Chloe, J,1465892.820.000.000.0092.82
Simmons, Brittany,2923139.980.000.000.0039.98
Alexander, Lauren,189502351.960.000.000.002351.96
Ramirez, Sydney,267007.280.000.000.007.28
Green, Gabriella, C,2803569.990.000.000.0069.99
Smith, Alexandra,2829261.960.000.000.0061.96
Cox, Katelyn, B,2174230.970.000.000.0030.97
Rivera, Ariana,261734.990.000.000.004.99
Coleman, Joan, W,2669964.470.000.000.0064.47
Martin, Nicholas,233627.280.000.000.007.28
Edwards, Madeline,2077146.470.000.000.0046.47
Thomas, Benjamin, J,2129556.970.000.000.0056.97
Long, Chloe,167841735.980.000.000.001735.98
Sanchez, Faith,270494.990.000.000.004.99
Morgan, Angela,24665109.970.000.000.00109.97
King, Caleb, J,2898678.980.000.000.0078.98
Perry, Brandon,22095141.980.000.000.00141.98
Cooper, Alexandra,19541131.240.000.000.00131.24
Lewis, Ryan, A,203124.990.000.000.004.99
Russell, Kaitlyn, M,244913578.270.003578.270.000.00
Washington, Ian, M,246644368.580.003578.270.00790.31
Baker, Sean, T,247782858.490.002181.560.00676.93
Cooper, Stephanie,249762181.560.002181.560.000.00
Martin, Morgan,248322181.560.002181.560.000.00
Sanders, Paige,252872983.340.002443.350.00539.99
Lazecky, Petr,258642443.350.000.002443.350.00
Price, Stephanie,258922443.350.000.002443.350.00
Young, Savannah,259712749.320.000.002181.56567.76
Russell, Fernando,27084782.990.000.00782.990.00
Brown, Morgan,2919778.980.000.000.0078.98
Perez, Kaitlyn, A,120812366.960.000.000.002366.96
Johnson, Christopher,119794813.760.000.000.004813.76
Alexander, Nathan, A,187951198.970.000.000.001198.97
Barnes, Jeremy,2144654.980.000.000.0054.98
Mehta, Carmen, C,2743694.480.000.000.0094.48
Anand, Brendan, L,1984721.980.000.000.0021.98
Young, Jenna, W,163652490.180.000.000.002490.18
Ward, Juan, H,215952649.560.000.002049.10600.46
Washington, Victoria,235577.280.000.000.007.28
Moreno, Marie,2773969.990.000.000.0069.99
Barnes, Emily, G,15996564.990.000.000.00564.99
Watson, Marcus,2271585.480.000.000.0085.48
Rubio, Kellie,27653128.970.000.000.00128.97
Watson, Janet, S,2320859.980.000.000.0059.98
Dominguez, Erika, C,21251191.270.000.000.00191.27
Clark, William,2902169.990.000.000.0069.99
Hughes, Miranda,266784.990.000.000.004.99
Foster, Kayla,1969371.950.000.000.0071.95
Davis, Thomas,167641760.470.000.000.001760.47
Coleman, Spencer,15993597.260.000.000.00597.26
Green, Mackenzie, C,280737.280.000.000.007.28
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Richardson, Olivia,204683169.590.000.002049.101120.49
Walker, Thomas,1307193.980.000.000.0093.98
Peterson, Xavier, R,2645639.980.000.000.0039.98
Martinez, Carol, D,17656578.460.000.000.00578.46
Thompson, Brianna, X,1864269.970.000.000.0069.97
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Alexander, Sarah,1941129.990.000.000.0029.99
Wood, Brittany,2877753.990.000.000.0053.99
Williams, Zachary, B,27099782.990.000.00782.990.00
Cooper, Christina, C,265121000.440.000.001000.440.00
Robinson, Jennifer, L,265041000.440.000.001000.440.00
Diaz, Angela, K,27259782.990.000.00782.990.00
Stewart, Andrea, M,27252782.990.000.00782.990.00
White, Christopher, R,260492181.560.000.002181.560.00
James, Timothy,213312670.890.000.002670.890.00
Mitchell, Xavier, L,265331629.410.000.001000.44628.97
Simmons, Haley, T,262022749.320.000.002181.56567.76
Coleman, Jennifer, L,27298782.990.000.00782.990.00
Mitchell, Maria, D,27404782.990.000.00782.990.00
Scott, Allison,14497804.480.000.000.00804.48
Alexander, Logan, E,191161183.470.000.000.001183.47
Russell, Chloe, M,12763589.960.000.000.00589.96
Russell, Caleb,23552103.480.000.000.00103.48
Perry, Justin, E,167583062.340.000.000.003062.34
Thames, Bernard,2380368.490.000.000.0068.49
Thomas, Ian,191181120.490.000.000.001120.49
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Reed, Megan, A,181181750.980.000.000.001750.98
Roberts, Jordan, M,1680039.250.000.000.0039.25
Roberts, Carlos,2319639.980.000.000.0039.98
Washington, Ryan,2833294.480.000.000.0094.48
Moore, Ian, L,2463939.980.000.000.0039.98
Price, Caroline,180511735.980.000.000.001735.98
Ma, Tiffany,2157739.980.000.000.0039.98
Watson, Victoria,16125588.960.000.000.00588.96
Walker, Brandon, J,159164793.270.000.000.004793.27
Hill, Haley, J,161033142.320.000.000.003142.32
Sanders, Angel,16219553.970.000.000.00553.97
Coleman, Stephanie,2226489.970.000.000.0089.97
Brown, Dylan, J,124492351.960.000.000.002351.96
Ward, Mariah, J,2158044.910.000.000.0044.91
Collins, Jonathan,16849119.980.000.000.00119.98
Taylor, Taylor,159054899.020.000.000.004899.02
Nath, Carl, H,29001624.970.000.000.00624.97
Martin, Kellie, R,28195574.980.000.000.00574.98
Bell, Chase,180911750.980.000.000.001750.98
Hall, Fernando,2210090.950.000.000.0090.95
Harrison, Trevor, A,18055143.910.000.000.00143.91
Coleman, Destiny, W,121224814.040.000.000.004814.04
Wang, Benjamin, R,274547.280.000.000.007.28
Rodriguez, Natalie,2077330.970.000.000.0030.97
Walker, Destiny, M,169961754.980.000.000.001754.98
Andersen, Latoya, J,290578.990.000.000.008.99
Watson, Michelle, H,262352181.560.000.002181.560.00
Reed, Kaylee, R,17371151.920.000.000.00151.92
Carter, Elijah,216182611.070.000.002611.070.00
Thomas, William, A,216142589.090.000.002049.10539.99
Garcia, Lucas,27545782.990.000.00782.990.00
Bradley, Rachel,158504813.040.000.000.004813.04
Henderson, Olivia,188591155.480.000.000.001155.48
Torres, Victoria,17551160.920.000.000.00160.92
Ross, Kelly,2607676.960.000.000.0076.96
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Flores, Brittany,169062359.980.000.000.002359.98
Nelson, Sierra,161322459.620.000.002459.620.00
Wedge, Andrew, T,120604811.540.000.002418.482393.06
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Patterson, Jeremy,130272319.260.000.000.002319.26
Diaz, Jason,17374206.630.000.0089.46117.17
Evans, Jesse,2191639.980.000.000.0039.98
Perry, Lauren,248164.990.000.000.004.99
Alexander, Jason,2932849.990.000.000.0049.99
Richardson, Charles, I,121144719.020.000.000.004719.02
Bradley, Nathaniel,169551760.470.000.000.001760.47
Foster, Paige,2742894.480.000.000.0094.48
Price, Rachel, D,2532889.970.000.000.0089.97
Hall, Natalie, A,230704.990.000.004.990.00
Barnes, Haley, J,2133939.980.000.0039.980.00
Evans, Maria,22544127.280.000.00127.280.00
Ross, Jose,2744178.980.000.000.0078.98
Moore, Logan,2634889.970.000.000.0089.97
Phillips, Isaiah,28631144.470.000.000.00144.47
Cox, Arianna, D,1892789.250.000.000.0089.25
Cook, Joan,235544.990.000.000.004.99
Lobao, Alexandre,1892691.950.000.000.0091.95
Brown, Christian,227554.990.000.000.004.99
Thomas, Jeremiah,183721760.470.000.000.001760.47
Reed, Michelle,2804669.990.000.000.0069.99
Patterson, Austin, O,270247.280.000.000.007.28
Ward, Eduardo, I,139162354.980.000.000.002354.98
Gray, Sebastian, B,138782366.960.000.000.002366.96
Walker, Jacob, N,29027574.980.000.000.00574.98
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Nelson, Katherine,2802178.980.000.000.0078.98
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Moore, Jennifer, A,2175964.470.000.000.0064.47
Johnson, Madison, L,15530846.460.000.000.00846.46
Howard, Danielle,28357133.490.000.000.00133.49
Harris, Anthony,2144721.980.000.000.0021.98
Richardson, Lauren, C,14867839.480.000.000.00839.48
Martin, Noah, A,1765775.970.000.000.0075.97
Wang, Zachary,2214489.970.000.000.0089.97
Collins, Jose,2474839.980.000.000.0039.98
Rodriguez, Julia, A,264884.990.000.000.004.99
Hill, Eric, G,2525667.930.000.000.0067.93
Bryant, Rachel,220197.280.000.000.007.28
Ramirez, Richard, C,282397.280.000.000.007.28
Adams, Mason, T,2052864.470.000.000.0064.47
Harris, Samantha, A,244874.990.000.000.004.99
Alexander, Gavin, K,2932249.990.000.000.0049.99
_SUM1806517.5025543.71493581.21254851.631032540.95

Generated 2025-12-23 11:31:45.874 UTC