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

304 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Hughes, Caroline, C,2830278.980.000.000.0078.98
Thomas, Benjamin, J,2129556.970.000.000.0056.97
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Lal, Caleb, R,1586874.460.000.000.0074.46
Williams, Destiny, S,15881564.990.000.000.00564.99
Peterson, Mason, A,185701174.480.000.000.001174.48
Flores, Madison,14416769.490.000.000.00769.49
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Hernandez, Sierra,27393123.980.000.000.00123.98
Gonzales, Paige,2170291.940.000.000.0091.94
Mitchell, Bailey, B,267067.280.000.000.007.28
Davis, Thomas,167641760.470.000.000.001760.47
Yuan, Leonard, F,167911729.970.000.000.001729.97
Green, Mackenzie, C,280737.280.000.000.007.28
Hernandez, Eduardo, J,18919300.940.000.000.00300.94
Gray, Mariah,222787.280.000.000.007.28
Bradley, Jocelyn,230227.280.000.000.007.28
Baker, Robert, A,273007.280.000.000.007.28
Phillips, Luis, G,207347.280.000.000.007.28
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Ruiz, Philip,1807781.460.000.000.0081.46
Garcia, Alexandra, J,14107819.460.000.000.00819.46
Harris, Noah,292562393.060.000.000.002393.06
Robinson, Lauren,2719668.490.000.000.0068.49
Martin, Joshua, A,276077.280.000.000.007.28
Torres, Dalton,235037.280.000.000.007.28
Parker, Eduardo, M,12939169.420.000.000.00169.42
Edwards, Hunter,2422067.930.000.000.0067.93
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Scott, Allison,14497804.480.000.000.00804.48
Ashe, Alexis, S,194141145.480.000.000.001145.48
Smith, Nathan,217647.280.000.000.007.28
Van, Bobby,27757132.970.000.000.00132.97
Stewart, Marcus, R,2063221.980.000.000.0021.98
McDonald, Aaron, J,27734119.980.000.000.00119.98
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Robinson, Zachary, L,137092332.280.000.000.002332.28
Brown, Morgan,2919778.980.000.000.0078.98
Jai, Hunter, M,28272111.950.000.000.00111.95
Richardson, Devin, G,2131836.960.000.000.0036.96
Russell, Nicole, M,182372318.960.000.000.002318.96
Patterson, Eric, A,2738478.980.000.000.0078.98
Roberts, Carlos,2319639.980.000.000.0039.98
Johnson, Jonathan,220597.280.000.000.007.28
Reed, Gabriella, A,2743778.980.000.000.0078.98
Hill, Katherine, L,2670139.980.000.000.0039.98
Hughes, Luis,130841798.960.000.000.001798.96
Alexander, Julia, J,15291889.470.000.000.00889.47
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Coleman, Stephanie,2226489.970.000.000.0089.97
Brown, Dylan, J,124492351.960.000.000.002351.96
Alexander, Caroline,176541759.970.000.000.001759.97
Ward, Mariah, J,2158044.910.000.000.0044.91
Gray, Seth, M,2008785.480.000.000.0085.48
Davis, Jonathan,2925913.980.000.000.0013.98
Tang, Carl,2123832.270.000.000.0032.27
Flores, Zachary, H,233765314.250.003578.270.001735.98
Butler, Victoria,132844767.530.000.000.004767.53
Morris, Abigail, C,287762.290.000.000.002.29
Dominguez, Meghan,14370122.560.000.000.00122.56
Ross, Anna, D,15494275.440.000.000.00275.44
Flores, Emily,13206163.190.000.000.00163.19
Henderson, Gabrielle, B,186031205.470.000.000.001205.47
Ross, Natalie, J,12916261.220.000.000.00261.22
Nelson, Adam, B,27402128.970.000.000.00128.97
Harris, Emily, P,1986298.480.000.000.0098.48
Ward, Angela, M,2775669.990.000.000.0069.99
Patterson, Nicole,1972937.270.000.000.0037.27
Wright, Robert, C,158894848.030.000.000.004848.03
Rogers, Sean, G,18685124.460.000.000.00124.46
Henderson, Caroline,2008256.970.000.000.0056.97
Madan, Carmen, V,155674720.270.000.000.004720.27
Turner, Blake,12136131.740.000.000.00131.74
Bradley, Melanie, G,133434720.270.000.000.004720.27
Torres, Mariah,16380195.950.000.000.00195.95
Perry, Melissa,221284142.230.003578.270.00563.96
Lopez, Jack, I,2904751.460.000.000.0051.46
Hayes, Oscar,2652729.260.000.000.0029.26
Smith, Tyler, J,2034156.970.000.000.0056.97
Gutierrez, Jerome,127832420.460.000.000.002420.46
Phillips, Miguel,2049812.940.000.000.0012.94
Sandberg, Nicole, M,12077144.690.000.000.00144.69
Garcia, Cameron,186411120.490.000.000.001120.49
Griffin, Jordan,13095328.890.000.000.00328.89
Williams, Ian, M,175581750.470.000.000.001750.47
Washington, Kayla, E,14655174.960.000.000.00174.96
Yang, Thomas, A,14108839.480.000.000.00839.48
King, Caleb, J,2898678.980.000.000.0078.98
Hughes, Miranda,266784.990.000.000.004.99
Jackson, Hannah, G,131432404.970.000.000.002404.97
Richardson, Melissa, E,111322371.940.000.000.002371.94
Ortega, Byron,233064828.110.003578.270.001249.84
Watson, Cole, A,217684118.263578.270.000.00539.99
Powell, Vanessa,26630699.100.00699.100.000.00
Martin, Xavier,222335997.330.003578.270.002419.06
Brooks, Paige,222325985.310.003578.270.002407.04
Smith, John,198555709.960.003399.990.002309.97
Parker, Madeline, H,221826006.320.003578.270.002428.05
Turner, Sean,227324133.240.003578.270.00554.97
Murphy, Richard, M,222994145.540.003578.270.00567.27
Rogers, Sara,198744544.450.003374.990.001169.46
Miller, Joseph, A,227134148.190.003578.270.00569.92
Moore, Taylor, A,199874564.450.003374.990.001189.46
Miller, Chloe, V,228936056.510.003578.270.002478.24
Richardson, Caitlin, T,230576021.820.003578.270.002443.55
Walker, Brandon, J,159164793.270.000.000.004793.27
Bryant, Gabriel,2765669.990.000.000.0069.99
Bryant, Brittany,2254548.970.000.000.0048.97
Hughes, Jasmine,276284.990.000.000.004.99
White, Edward, J,15847205.460.000.000.00205.46
Miller, Sydney, A,134404818.530.000.000.004818.53
Hall, Fernando,2210090.950.000.000.0090.95
Martinez, Kristina, S,2134529.930.000.000.0029.93
Griffin, Jennifer, B,14244154.960.000.000.00154.96
Henderson, Jordan, C,229966035.600.003578.270.002457.33
Long, Jordan,199884555.470.003399.990.001155.48
Morris, Chase, F,26789699.100.00699.100.000.00
Gill, Beth,199975814.980.003374.990.002439.99
Bryant, Isabelle,233974828.110.003578.270.001249.84
White, Cameron,238304802.110.003578.270.001223.84
Foster, Olivia,238063578.270.003578.270.000.00
Rodriguez, Joshua, A,235114843.110.003578.270.001264.84
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Jenkins, Megan, R,12074261.380.000.000.00261.38
Cooper, Andrea,2932378.980.000.000.0078.98
Cook, Megan, J,2029956.970.000.000.0056.97
Serrano, Albert, E,133284708.020.000.000.004708.02
Anderson, Emma, A,185801170.480.000.000.001170.48
Gonzales, Luis,15856116.250.000.000.00116.25
Bell, Alexandria, A,13758284.130.000.000.00284.13
Cox, Devin, C,134184768.050.000.000.004768.05
Parker, Caleb, A,2631813.980.000.000.0013.98
Turner, Andrea, A,202093268.550.002049.100.001219.45
Jai, Adam,250952443.350.000.002443.350.00
Huang, Kristen,251002443.350.000.002443.350.00
Chen, Jackson, S,270751371.950.000.00782.99588.96
Russell, Fernando,27084782.990.000.00782.990.00
Hughes, Justin, M,181222439.990.000.000.002439.99
Chavez, Kara, P,13285214.350.000.000.00214.35
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
Wright, Kyle,2371626.970.000.000.0026.97
Isla, Julian, A,13732108.960.000.000.00108.96
Bailey, Mariah, L,2724354.980.000.000.0054.98
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Russell, Samuel, V,11652310.930.000.000.00310.93
Hall, Lauren, A,19648100.840.000.000.00100.84
Bryant, Samantha,18345115.470.000.000.00115.47
Johnson, Edward, H,23279124.990.000.000.00124.99
Cooper, Paige,14119148.940.000.000.00148.94
Richardson, Olivia,204683169.590.000.002049.101120.49
Wilson, Christian,27085782.990.000.00782.990.00
Miller, Katherine, B,27102782.990.000.00782.990.00
Townsend, Jeremiah, I,265031000.440.000.001000.440.00
Ross, Rachel, C,206693169.590.000.002049.101120.49
Thompson, Joshua, F,259992181.560.000.002181.560.00
White, Christopher, R,260492181.560.000.002181.560.00
Butler, Ana,260403018.330.000.002443.35574.98
Thompson, Devin,207084406.400.000.002071.422334.98
Phillips, Kaylee,211384371.380.000.002049.102322.28
Ward, Nicole, L,212724435.380.000.002071.422363.96
Adams, Connor,214232888.560.000.002049.10839.46
Henderson, Abigail,2044139.980.000.000.0039.98
Martin, Samuel,15874225.440.000.000.00225.44
Jones, Charles,22882101.450.000.000.00101.45
Anderson, Jasmine, A,235534.990.000.000.004.99
Carter, Jesse, E,22141166.280.000.000.00166.28
Howard, Natalie,1349154.960.000.000.0054.96
Kennedy, Bridget,2202639.980.000.000.0039.98
White, Greg, C,174032322.280.000.000.002322.28
Robinson, Sarah, A,2702859.980.000.000.0059.98
Scott, Kaitlyn, A,12159218.910.000.000.00218.91
Watson, Michelle, H,262352181.560.000.002181.560.00
Powell, Caleb, G,216132610.580.000.002049.10561.48
Ward, Stephanie, A,27429782.990.000.00782.990.00
Bell, Julia,216522646.060.000.002049.10596.96
Powell, David, W,266151000.440.000.001000.440.00
Wilson, Victoria, R,27536782.990.000.00782.990.00
Washington, Riley, L,185441155.480.000.001155.480.00
Davis, Richard, R,15549574.980.000.00574.980.00
James, Zoe, R,14611304.550.000.000.00304.55
Chen, Ethan,2054756.970.000.000.0056.97
Brown, Julia,18065155.470.000.000.00155.47
Sandberg, Chase,2190475.970.000.000.0075.97
Lewis, Morgan,17410168.740.000.000.00168.74
Moreno, Lance, A,2922939.980.000.000.0039.98
Hayes, Brittany,13941286.820.000.000.00286.82
Jai, Luis, A,18320185.920.000.000.00185.92
Lewis, Ethan,27998144.470.000.000.00144.47
Butler, Isabel,16241126.960.000.000.00126.96
Rivera, Makayla, A,2878334.990.000.000.0034.99
Sanders, Megan, A,15376136.240.000.000.00136.24
He, Micah,2740169.990.000.000.0069.99
Cook, Seth,2301064.470.000.000.0064.47
Harris, Destiny, M,137102341.460.000.000.002341.46
Nelson, Sierra,161322459.620.000.002459.620.00
Alexander, Ryan, J,14078839.480.000.00839.480.00
Allen, Jack, M,291372419.060.000.000.002419.06
Diaz, Hailey, W,116932294.990.000.000.002294.99
Thomas, Jessica,1684894.480.000.000.0094.48
Martin, Madison, C,2049271.970.000.000.0071.97
Wood, Gavin,16964108.540.000.000.00108.54
Coleman, Miguel, D,2740069.990.000.000.0069.99
Yuan, Yolanda, C,2215436.960.000.000.0036.96
Sanchez, Faith,270494.990.000.000.004.99
Rubio, Ruben, D,1887186.960.000.000.0086.96
Ross, Jose,2744178.980.000.000.0078.98
Harris, Jacob, G,2367939.980.000.000.0039.98
Simmons, Dylan,16133107.850.000.000.00107.85
Moore, Logan,2634889.970.000.000.0089.97
Flores, Isabelle, A,15526188.320.000.000.00188.32
Torres, Mackenzie,28153570.470.000.000.00570.47
Alexander, Thomas,207607.280.000.000.007.28
Turner, Samuel,2742069.990.000.000.0069.99
Long, Sarah,173721729.970.000.000.001729.97
Lewis, Ryan, A,203124.990.000.000.004.99
Campbell, Alex,119844730.320.000.000.004730.32
Lobao, Alexandre,1892691.950.000.000.0091.95
Lopez, Bailey, R,185571179.470.000.000.001179.47
Diaz, Ryan, J,16910141.960.000.000.00141.96
Baker, Allison,2649558.980.000.000.0058.98
Anderson, Ryan, W,132712319.990.000.000.002319.99
James, Bryce,13466133.450.000.000.00133.45
Prasad, Summer, M,2214339.980.000.000.0039.98
Wu, Randy, J,116472365.940.000.000.002365.94
Lewis, Brandon, A,2903769.990.000.000.0069.99
Perez, Kaitlyn, A,120812366.960.000.000.002366.96
Carter, Savannah, M,120902350.960.000.000.002350.96
Ramos, Derrick,18449100.940.000.000.00100.94
Collins, Sierra,185491169.460.000.000.001169.46
Lee, James, J,2881769.990.000.000.0069.99
Foster, Alyssa, I,14875839.480.000.000.00839.48
Rivera, Allison, M,13751224.910.000.000.00224.91
Brooks, Ian, W,2829064.470.000.000.0064.47
Price, Mariah, C,2074549.480.000.000.0049.48
Nelson, Jose,19217185.020.000.000.00185.02
Diaz, Brandon,236764.990.000.000.004.99
Henderson, Luke,19200109.240.000.000.00109.24
Zhang, Nathan, L,2910478.980.000.000.0078.98
Simmons, Brittany,2923139.980.000.000.0039.98
Nelson, Luis,234884.990.000.000.004.99
Hill, Eric, G,2525667.930.000.000.0067.93
Anderson, Daniel,20694146.970.000.000.00146.97
Harris, Matthew,14330806.760.000.000.00806.76
Clark, Emily, R,120862294.990.000.000.002294.99
Moreno, Marie,2773969.990.000.000.0069.99
Thomas, Megan,2907169.990.000.000.0069.99
James, Adrian, C,253404.990.000.000.004.99
Peterson, Xavier, R,2645639.980.000.000.0039.98
Campbell, Angel, D,195461174.480.000.000.001174.48
Walker, Destiny, M,169961754.980.000.000.001754.98
Bennett, Brittany, J,2233239.980.000.000.0039.98
Clark, Zachary, J,2389358.980.000.000.0058.98
Powell, Ian,2608564.470.000.000.0064.47
Jones, Samantha,1831721.980.000.000.0021.98
Alexander, Sarah,1941129.990.000.000.0029.99
Ward, Cole,214907.280.000.000.007.28
Collins, Amanda,2078339.980.000.000.0039.98
James, Emma,127812329.980.000.000.002329.98
Cooper, Brooke,195361120.490.000.000.001120.49
Sánchez, Angela, C,176551750.980.000.000.001750.98
Coleman, Samuel, N,17450123.980.000.000.00123.98
Powell, Katherine, C,14574177.600.000.000.00177.60
Reed, Melanie, A,28160574.980.000.000.00574.98
Jones, Dalton, T,189512334.970.000.000.002334.97
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Patterson, Aaron, W,191131184.460.000.000.001184.46
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Foster, Caleb,27112114.460.000.000.00114.46
Brooks, Allison,146054750.010.000.000.004750.01
Collins, Allison,28581119.980.000.000.00119.98
Rogers, Paige, H,17125539.990.000.000.00539.99
Adams, Gabriel, S,195271219.450.000.000.001219.45
Collins, Jonathan,16849119.980.000.000.00119.98
Mitchell, Evan, R,247314.990.000.000.004.99
Hall, Jason, A,29351119.980.000.000.00119.98
Thompson, Lucas, O,212774.990.000.000.004.99
Henderson, Austin,2764354.980.000.000.0054.98
Ross, Seth, M,184332329.980.000.000.002329.98
Washington, Emma,191231170.480.000.000.001170.48
Foster, Aaron,155664912.470.000.000.004912.47
Miller, Destiny,251577.280.000.000.007.28
Cook, Joan,235544.990.000.000.004.99
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
White, Emma, N,16090604.960.000.000.00604.96
Murphy, Brianna, K,2834269.990.000.000.0069.99
James, Julia,2497567.930.000.000.0067.93
Zhang, Connor, R,138532329.980.000.000.002329.98
Gray, Sebastian, B,138782366.960.000.000.002366.96
Walker, Jacob, N,29027574.980.000.000.00574.98
Turner, Mary,220154.990.000.000.004.99
Chandra, Allen,2932753.990.000.000.0053.99
Harris, Anthony,2144721.980.000.000.0021.98
Cannata, Gabrielle, C,217254.990.000.000.004.99
Kelly, Bailey, R,28284563.770.000.000.00563.77
Ward, Lucas, N,183631700.990.000.000.001700.99
Gomez, Briana, A,2878443.980.000.000.0043.98
Morris, Haley, A,2354848.970.000.000.0048.97
Li, Brandon,2933973.960.000.000.0073.96
Washington, Adam, G,2543713.980.000.000.0013.98
Chen, David,2720839.980.000.000.0039.98
Torres, Abigail,253674.990.000.000.004.99
_SUM1806517.5014313.08487820.91251094.681053288.83

Generated 2026-01-04 04:31:14.575 UTC