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

382 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Gonzales, Ashley, C,1860051.970.000.000.0051.97
Scott, Allison,14497804.480.000.000.00804.48
Miller, Victoria,15816188.020.000.000.00188.02
Alexander, Logan, E,191161183.470.000.000.001183.47
Russell, Chloe, M,12763589.960.000.000.00589.96
Lobao, Alexandre,1892691.950.000.000.0091.95
Green, Chloe, J,1465892.820.000.000.0092.82
Harrison, Trevor, A,18055143.910.000.000.00143.91
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
Roberts, Carlos,2319639.980.000.000.0039.98
Thompson, Blake,18390141.960.000.000.00141.96
Washington, Ryan,2833294.480.000.000.0094.48
Martin, Noah, A,1765775.970.000.000.0075.97
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, Jose,2474839.980.000.000.0039.98
Rodriguez, Julia, A,264884.990.000.000.004.99
Coleman, Destiny, W,121224814.040.000.000.004814.04
Wang, Benjamin, R,274547.280.000.000.007.28
Martin, Samuel,15874225.440.000.000.00225.44
Hill, Eric, G,2525667.930.000.000.0067.93
Bryant, Rachel,220197.280.000.000.007.28
Hill, Haley, J,161033142.320.000.000.003142.32
Li, Jordan,17026261.390.000.000.00261.39
Ramirez, Richard, C,282397.280.000.000.007.28
Walker, Destiny, M,169961754.980.000.000.001754.98
Andersen, Latoya, J,290578.990.000.000.008.99
Richardson, Charles, I,121144719.020.000.000.004719.02
Adams, Mason, T,2052864.470.000.000.0064.47
Henderson, Olivia,188591155.480.000.000.001155.48
Torres, Victoria,17551160.920.000.000.00160.92
Foster, Carson, L,16959135.350.000.000.00135.35
Campbell, Kevin, S,121774811.500.000.000.004811.50
Ross, Kelly,2607676.960.000.000.0076.96
Hernandez, Sierra,27393123.980.000.000.00123.98
Hernandez, Eduardo, J,18919300.940.000.000.00300.94
Foster, Samuel, M,18523160.940.000.000.00160.94
Perry, Lauren,248164.990.000.000.004.99
Bradley, Nathaniel,169551760.470.000.000.001760.47
Foster, Paige,2742894.480.000.000.0094.48
Kelly, Julia,2379867.930.000.000.0067.93
Ramirez, Melanie, V,163632481.820.000.000.002481.82
Price, Rachel, D,2532889.970.000.000.0089.97
Robinson, Lauren,2719668.490.000.000.0068.49
Torres, Dalton,235037.280.000.000.007.28
Cook, Joan,235544.990.000.000.004.99
Parker, Jeremy,2866878.980.000.000.0078.98
Barnes, Kayla,2425639.980.000.000.0039.98
Powell, Sydney, M,14886539.990.000.000.00539.99
Cox, Arianna, D,1892789.250.000.000.0089.25
Simmons, Caleb, M,121934833.030.000.000.004833.03
Dominguez, Erika, C,21251191.270.000.000.00191.27
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Nelson, Katherine,2802178.980.000.000.0078.98
Torres, Christina, M,20746119.950.000.000.00119.95
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Gray, Jared, A,264494.990.000.000.004.99
Coleman, Logan,1868691.950.000.000.0091.95
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Henderson, Justin, P,235917.280.000.000.007.28
Harris, Anthony,2144721.980.000.000.0021.98
Richardson, Lauren, C,14867839.480.000.000.00839.48
Sanchez, Grace,120802354.990.000.000.002354.99
Johnson, Jonathan,220597.280.000.000.007.28
Reed, Gabriella, A,2743778.980.000.000.0078.98
Wang, Zachary,2214489.970.000.000.0089.97
Edwards, Eric,2462768.490.000.000.0068.49
Wilson, Andrew, R,182362414.990.000.000.002414.99
Jones, Nicole,14504112.270.000.000.00112.27
Flores, Logan, K,14631848.470.000.000.00848.47
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Robinson, Abigail, R,183792362.270.000.000.002362.27
Walker, Emma, M,2520998.960.000.000.0098.96
Bryant, Samantha,18345115.470.000.000.00115.47
Powell, Blake, J,2237139.980.000.000.0039.98
Simmons, Elizabeth, A,21461141.980.000.000.00141.98
Morgan, Angela,24665109.970.000.000.00109.97
King, Caleb, J,2898678.980.000.000.0078.98
Watson, Janet, S,2320859.980.000.000.0059.98
Clark, William,2902169.990.000.000.0069.99
Hughes, Miranda,266784.990.000.000.004.99
Simmons, Brittany,2923139.980.000.000.0039.98
Alexander, Lauren,189502351.960.000.000.002351.96
Cooper, Alexandra,19541131.240.000.000.00131.24
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
Hall, Fernando,2210090.950.000.000.0090.95
Perry, Brandon,22095141.980.000.000.00141.98
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Flores, Brittany,169062359.980.000.000.002359.98
Patterson, Jeremy,130272319.260.000.000.002319.26
Brown, Morgan,2919778.980.000.000.0078.98
Evans, Jesse,2191639.980.000.000.0039.98
Alexander, Jason,2932849.990.000.000.0049.99
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
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Peterson, Xavier, R,2645639.980.000.000.0039.98
Martinez, Carol, D,17656578.460.000.000.00578.46
Harris, Samantha, A,244874.990.000.000.004.99
Alexander, Sarah,1941129.990.000.000.0029.99
Wood, Brittany,2877753.990.000.000.0053.99
Bailey, Lauren,15864103.550.000.000.00103.55
Turner, Eduardo,158764789.020.000.000.004789.02
Flores, Zachary, H,233765314.250.003578.270.001735.98
Walker, Charles,11677298.210.000.000.00298.21
Griffin, Julian, M,113284718.040.000.002319.992398.05
Sanders, Xavier,1672173.750.000.000.0073.75
Turner, Timothy, C,14641119.860.000.000.00119.86
Yang, Thomas, A,14108839.480.000.000.00839.48
Gonzales, Brittany,217104187.233578.270.000.00608.96
Ye, Alisha, J,220084141.230.003578.270.00562.96
Long, Gabrielle,198305765.920.003374.990.002390.93
Collins, Lucas, T,219214142.750.003578.270.00564.48
Mitchell, Lucas, C,198294533.450.003374.990.001158.46
Powell, Vanessa,26630699.100.00699.100.000.00
Henderson, Jackson, A,221215997.330.003578.270.002419.06
Bennett, Jordyn, L,222304223.230.003578.270.00644.96
Phillips, Adam, R,227484188.240.003578.270.00609.97
Collins, Luis, J,227655978.610.003578.270.002400.34
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Martinez, Wyatt, R,228815997.330.003578.270.002419.06
Perry, Ryan,132494795.340.000.000.004795.34
Ortega, Byron,233064828.110.003578.270.001249.84
Suarez, Juan, R,167631700.990.000.000.001700.99
Lopez, Carlos,186171147.770.000.000.001147.77
Cook, Megan, J,2029956.970.000.000.0056.97
Reed, Judith, D,2534759.980.000.000.0059.98
Perez, Angel, S,213362628.350.000.002071.42556.93
Yuan, Carly,19839194.960.000.000.00194.96
Flores, Megan, N,230746021.820.003578.270.002443.55
Powell, Elijah, E,231135997.330.003578.270.002419.06
Foster, Eric,229765971.330.003578.270.002393.06
Washington, Lauren, R,229985329.250.003578.271750.980.00
Diaz, Elijah,200004495.480.003374.990.001120.49
Alexander, Ashley, J,200074495.480.003374.990.001120.49
White, Cameron,238304802.110.003578.270.001223.84
Washington, Vanessa,238194802.110.003578.270.001223.84
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Long, Kaitlyn,233964891.610.003578.270.001313.34
Sanz, Lori, L,238654891.610.003578.270.001313.34
Campbell, Evan, W,243424828.110.003578.270.001249.84
Martinez, Jill,242354829.390.003578.270.001251.12
Hughes, Edward,200234530.470.003374.990.001155.48
Jones, Madison,246614181.760.003578.27603.490.00
Bennett, Seth,244933578.270.003578.270.000.00
Martinez, Hannah, M,246664370.610.003578.270.00792.34
Bailey, Mariah, L,2724354.980.000.000.0054.98
Thomas, Samantha,2169093.970.000.000.0093.97
Sandberg, Isaac,1335053.970.000.000.0053.97
Brooks, Bryce,12061140.170.000.0074.9865.19
Price, Nicole, N,15815141.830.000.000.00141.83
Reed, Marcus,14582111.790.000.000.00111.79
Thompson, Kaitlyn, L,12430223.930.000.000.00223.93
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Perry, Christian,246714354.600.003578.270.00776.33
Murphy, Juan, T,246463578.270.003578.270.000.00
Fernandez, Cesar,200355694.980.003374.990.002319.99
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, 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
Flores, Jordyn,252882721.550.000.002181.56539.99
Chen, Jackson, S,270751371.950.000.00782.99588.96
Harris, Edward,27062782.990.000.00782.990.00
Perry, Olivia,203754438.380.000.002071.422366.96
Reed, Catherine, M,203807.280.000.000.007.28
Smith, Lucas, P,1809064.910.000.000.0064.91
Ramirez, Abigail, S,1585974.140.000.000.0074.14
Butler, Morgan, E,2050068.490.000.000.0068.49
Butler, Isabel,16241126.960.000.000.00126.96
Hernandez, Haley, L,11769478.950.000.000.00478.95
Cooper, Brianna,2592513.980.000.000.0013.98
Edwards, Connor,16950211.010.000.000.00211.01
Johnson, Anthony, D,270224.990.000.000.004.99
Walker, Jasmine,134604693.040.000.000.004693.04
Li, Kevin, S,2518813.980.000.000.0013.98
Martinez, Jonathan,1330366.250.000.000.0066.25
Price, Jeremy,259892744.520.000.002181.56562.96
Taylor, Zachary, M,27082782.990.000.00782.990.00
Fernandez, Ruth,205463246.550.000.002049.101197.45
Hill, Sydney,264821000.440.000.001000.440.00
Bell, Eduardo,27101782.990.000.00782.990.00
Thomas, Isabella, M,27265782.990.000.00782.990.00
Cooper, Timothy, J,206513198.570.000.002049.101149.47
Evans, James, C,206654408.560.000.002049.102359.46
Cox, Julia, A,206703228.570.000.002049.101179.47
Thompson, Joshua, F,259992181.560.000.002181.560.00
Phillips, Jack, R,259952443.350.000.002443.350.00
Jai, Connor, D,27253782.990.000.00782.990.00
Phillips, Kaylee,211384371.380.000.002049.102322.28
Jones, Zachary, J,27285782.990.000.00782.990.00
Coleman, Ashley,27297782.990.000.00782.990.00
Kelly, Bryan,213492989.380.000.002989.380.00
Coleman, Vanessa,215892589.090.000.002049.10539.99
Robinson, William,20103103.480.000.000.00103.48
Cox, Devin, C,134184768.050.000.000.004768.05
Moore, Andrew, A,13944150.130.000.000.00150.13
Lewis, Brandon, A,2903769.990.000.000.0069.99
Diaz, Alyssa,139084715.330.000.000.004715.33
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Griffin, Jack, L,1768632.280.000.000.0032.28
Sanders, Hailey,19647282.040.000.000.00282.04
Luo, Franklin, J,2202759.980.000.000.0059.98
Moore, Jonathan,2047896.460.000.000.0096.46
Jai, Edwin,169211754.980.000.000.001754.98
White, Edward, J,15847205.460.000.000.00205.46
Thomas, Megan,2907169.990.000.000.0069.99
Bell, Christina,2609939.980.000.000.0039.98
Griffin, Haley, L,1892582.180.000.000.0082.18
Johnson, Andrew, F,262942443.350.000.002443.350.00
Russell, Jessica,265721000.440.000.001000.440.00
Thomas, Richard,27557782.990.000.00782.990.00
Winston, Ethan, R,216222612.060.000.002049.10562.96
Thomas, Thomas,216292624.080.000.002049.10574.98
Wilson, Victoria, R,27536782.990.000.00782.990.00
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
Washington, Alexia,27613782.990.000.00782.990.00
King, Jordan, C,110202316.970.000.002316.970.00
Washington, Riley, L,185441155.480.000.001155.480.00
Russell, Elijah, M,118354772.300.000.002319.262453.04
Davis, Richard, R,15549574.980.000.00574.980.00
Lal, Caleb, R,1586874.460.000.000.0074.46
Miller, Kayla, A,236734.990.000.000.004.99
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, Timothy, F,13199105.190.000.0022.9382.26
Campbell, Hailey,15507267.840.000.00228.9638.88
Bradley, Jocelyn,230227.280.000.000.007.28
Sanchez, Jared, J,2585064.470.000.000.0064.47
Bailey, Marcus, L,18329146.530.000.0023.78122.75
Prasad, Erick, E,28786127.950.000.000.00127.95
Nelson, Jordan, H,201304.990.000.004.990.00
Coleman, Miguel, D,2740069.990.000.0069.990.00
Russell, Ian, T,2474613.980.000.0013.980.00
Wright, Jennifer,2650559.980.000.0059.980.00
Hughes, Eduardo,15564188.520.000.000.00188.52
Howard, Brianna, D,246304.990.000.000.004.99
Martin, Thomas, A,169521735.980.000.000.001735.98
Perry, Dalton, A,16149192.040.000.000.00192.04
Harris, Jacob, G,2367939.980.000.000.0039.98
Alexander, Paige, W,1860459.250.000.000.0059.25
Ashe, Alexis, S,194141145.480.000.000.001145.48
Russell, Oscar, A,12140118.170.000.000.00118.17
Green, Kaylee, C,2618567.970.000.000.0067.97
Brown, Anna,1624795.820.000.000.0095.82
Cannata, Gabrielle, C,217254.990.000.000.004.99
Parker, Amanda,1808151.970.000.000.0051.97
Sharma, Thomas, A,18637121.940.000.000.00121.94
Dominguez, Meghan,14370122.560.000.000.00122.56
Hall, Morgan,2172641.950.000.000.0041.95
Sanchez, Martin, E,216317.280.000.000.007.28
Campbell, Hunter,17422174.920.000.000.00174.92
King, Morgan,196811179.970.000.000.001179.97
Taylor, Ryan,170251709.980.000.000.001709.98
Nelson, Adam, B,27402128.970.000.000.00128.97
Hughes, Samantha,2721564.470.000.000.0064.47
Wilson, Hunter, R,2723013.980.000.000.0013.98
Young, Julia, J,274144.990.000.000.004.99
Rogers, Faith,2468259.980.000.000.0059.98
Long, Brandon, M,16110650.470.000.000.00650.47
Bennett, Maria, G,229837.280.000.000.007.28
Stewart, Julia, L,129022329.980.000.000.002329.98
Perez, Jordan, A,292674.990.000.000.004.99
Thomas, Victoria, A,15536249.530.000.000.00249.53
Bailey, Hailey, R,262704.990.000.000.004.99
Powell, Lauren, E,1966275.970.000.000.0075.97
Adams, Mackenzie, A,14640812.420.000.000.00812.42
Griffin, Stephanie, L,2826127.920.000.000.0027.92
White, Miguel, S,13988195.520.000.000.00195.52
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Clark, Lauren,170341750.980.000.000.001750.98
Hall, Charles,234764.990.000.000.004.99
James, Christina,17409219.920.000.000.00219.92
Jackson, Hannah, G,131432404.970.000.000.002404.97
Sanders, Isaiah,2587339.980.000.000.0039.98
Morris, Seth,189592341.460.000.000.002341.46
Torres, Mackenzie,28153570.470.000.000.00570.47
Thompson, Xavier, R,15761192.410.000.000.00192.41
Smith, Samuel, D,2308349.900.000.000.0049.90
Henderson, Luke,19200109.240.000.000.00109.24
Patterson, Natalie,16123629.970.000.000.00629.97
Garcia, Isabella,18382204.940.000.000.00204.94
Hughes, Destiny, P,28027119.980.000.000.00119.98
Anderson, Isabella,137432349.980.000.000.002349.98
Phillips, Kyle,12158202.200.000.000.00202.20
Sanders, Allison, B,18852268.250.000.000.00268.25
Foster, Edward, R,18355150.950.000.000.00150.95
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Scott, Sean, F,2475539.980.000.000.0039.98
Cox, Nathaniel, A,196612521.270.000.000.002521.27
Gonzales, Kayla,214947.280.000.000.007.28
Kelly, Trinity,2609515.230.000.000.0015.23
Robinson, Zachary, L,137092332.280.000.000.002332.28
Richardson, Brian,2860878.980.000.000.0078.98
Perry, Natalie,1712669.990.000.000.0069.99
Hayes, Hannah, J,2165656.970.000.000.0056.97
Campbell, Lucas,2932953.990.000.000.0053.99
Morris, Mason, J,22349124.990.000.000.00124.99
Wilson, Madison, H,1982821.980.000.000.0021.98
Alexander, Edward, E,18524195.950.000.000.00195.95
Griffin, Miguel,2146476.970.000.000.0076.97
Gray, Isabella,168203217.790.000.000.003217.79
Jones, Samantha,1831721.980.000.000.0021.98
Griffin, Marcus,2075634.560.000.000.0034.56
Blue, Melanie, L,178611749.960.000.000.001749.96
Gonzales, Emily, P,21777180.980.000.000.00180.98
Carter, Jesse, E,22141166.280.000.000.00166.28
Adams, Julia, N,2607359.980.000.000.0059.98
Edwards, Hailey,242584.990.000.000.004.99
Johnson, Jacob, I,28069553.970.000.000.00553.97
Murphy, Maria,160113657.260.000.000.003657.26
Robinson, Ian, D,138522294.990.000.000.002294.99
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Diaz, Trevor, B,2051954.960.000.000.0054.96
Butler, Cassidy, L,21792114.460.000.000.00114.46
Howard, Erin, L,183621725.210.000.000.001725.21
Perez, Timothy, L,227304.990.000.000.004.99
James, Zoe, R,14611304.550.000.000.00304.55
Collins, Allison,28581119.980.000.000.00119.98
Baker, Eduardo,180921789.450.000.000.001789.45
Brown, Julia,18065155.470.000.000.00155.47
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
Gonzalez, Molly,1637021.980.000.000.0021.98
Hughes, Riley,2928449.990.000.000.0049.99
Butler, Jonathan,261804.990.000.000.004.99
Sanders, Zoe, L,248254.990.000.000.004.99
Young, Courtney,176222374.980.000.000.002374.98
Zhang, Connor, R,138532329.980.000.000.002329.98
Perez, Jonathan, R,2345512.940.000.000.0012.94
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
Srini, Evelyn,16855150.950.000.000.00150.95
Foster, Nicole, A,2349489.970.000.000.0089.97
Butler, Jackson, J,183241735.980.000.000.001735.98
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
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
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
Williams, Joshua,260514.990.000.000.004.99
Chen, David,2720839.980.000.000.0039.98
Russell, Katherine,2877169.990.000.000.0069.99
Martin, Alfredo, P,2148039.980.000.000.0039.98
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
_SUM1806517.5025543.71493581.21254851.631032540.95

Generated 2025-12-23 05:33:17.812 UTC