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

248 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Bailey, Lauren,15864103.550.000.000.00103.55
Thomas, Edward, E,19147133.710.000.000.00133.71
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Collins, Isaac,260777.280.000.000.007.28
Butler, Trevor,2741569.990.000.0069.990.00
Gutierrez, Neil, L,214897.280.000.000.007.28
Mitchell, Maria, D,27404782.990.000.00782.990.00
Sanchez, Lucas, L,233514828.110.003578.270.001249.84
Taylor, Ryan,170251709.980.000.000.001709.98
Parker, Eduardo, M,12939169.420.000.0077.9291.50
Wang, Austin, A,1463284.970.000.009.9974.98
Phillips, Miguel,2049812.940.000.000.0012.94
Washington, Ian, M,246644368.580.003578.270.00790.31
Russell, Melanie, B,15478182.830.000.00167.8514.98
Li, Rafael, M,217527.280.000.000.007.28
Blue, Melanie, L,178611749.960.000.000.001749.96
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Hughes, Riley,2928449.990.000.000.0049.99
Foster, Alyssa, I,14875839.480.000.000.00839.48
Martinez, Jonathan,1330366.250.000.000.0066.25
Morgan, Angela,24665109.970.000.000.00109.97
Thomas, Richard,27557782.990.000.00782.990.00
Torres, Abigail,253674.990.000.000.004.99
Washington, Adam, G,2543713.980.000.000.0013.98
Wilson, Victoria, R,27536782.990.000.00782.990.00
Garcia, Cameron,186411120.490.000.000.001120.49
Hall, Lauren, A,19648100.840.000.000.00100.84
Alexander, Nathan, A,187951198.970.000.000.001198.97
Wang, Karen, P,1955331.970.000.000.0031.97
Lal, Jonathan,2009671.460.000.000.0071.46
Torres, Haley, W,232834828.110.003578.270.001249.84
Collins, Amanda,2078339.980.000.000.0039.98
Long, Natalie,14363192.340.000.000.00192.34
Zhang, Nathan, L,2910478.980.000.000.0078.98
Gray, Alexandria, E,253632443.350.002443.350.000.00
Rogers, Jared, J,12166162.220.000.000.00162.22
Collins, Jonathan,16849119.980.000.000.00119.98
Martinez, Matthew, L,16009170.450.000.000.00170.45
Yuan, Leonard, F,167911729.970.000.000.001729.97
Suarez, Juan, R,167631700.990.000.000.001700.99
Reed, Megan, A,181181750.980.000.000.001750.98
Moore, Andrew, A,13944150.130.000.0036.27113.86
Cox, Arianna, D,1892789.250.000.000.0089.25
Suri, Carolyn, S,12972175.710.000.000.00175.71
Coleman, Lucas, A,27060782.990.00782.990.000.00
Flores, Emily,13206163.190.000.0069.9793.22
Robinson, Dylan, L,1472481.530.000.000.0081.53
Gonzalez, Katherine,222345976.320.003578.270.002398.05
Harris, Noah,292562393.060.000.002393.060.00
Long, Caleb, P,250462181.560.002181.560.000.00
Patterson, Hailey, I,112231155.900.000.00267.62888.28
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Diaz, Faith, M,2236356.970.000.000.0056.97
Davis, Ethan,136604750.010.000.000.004750.01
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Martinez, Carol, D,17656578.460.000.000.00578.46
Flores, Nathan, C,2463713.980.000.000.0013.98
Green, Kaylee, C,2618567.970.000.000.0067.97
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Flores, Morgan,19817118.940.000.0039.9878.96
Collins, Luis, J,227655978.610.003578.270.002400.34
Chapman, Nancy, E,11276840.150.000.0066.26773.89
Long, Julia, R,228895971.330.003578.270.002393.06
Bryant, Zachary,216552648.070.000.002648.070.00
Thomas, Dylan,198737.280.000.000.007.28
Sanchez, Adrian, L,13179190.170.000.000.00190.17
Johnson, Cameron, R,137201155.480.000.000.001155.48
Foster, Jose, C,2878534.990.000.000.0034.99
Nelson, Adam, B,27402128.970.000.000.00128.97
Washington, Kayla, E,14655174.960.000.0069.97104.99
Barnes, Blake, A,178651789.970.000.000.001789.97
Foster, Olivia,238063578.270.003578.270.000.00
Anderson, Lucas,2926639.980.000.000.0039.98
Powell, Lauren, E,1966275.970.000.000.0075.97
Thompson, Abigail,243324816.090.003578.270.001237.82
Hayes, Oscar,2652729.260.000.000.0029.26
Russell, Nicole, M,182372318.960.000.000.002318.96
Young, Kaitlyn, J,2506213.980.000.000.0013.98
Alexander, Julian,132172351.960.000.000.002351.96
Simmons, Haley, T,262022749.320.000.002181.56567.76
Adams, Miguel,11659213.520.000.000.00213.52
Roberts, Robert, R,1898656.970.000.0056.970.00
Collins, Charles, B,29041628.450.000.000.00628.45
Ward, Stephanie, A,27429782.990.000.00782.990.00
Lewis, Jeremiah,1437187.260.000.0049.9737.29
Carter, Katherine,11861286.300.000.000.00286.30
Powell, Jasmine, A,11505846.770.000.0077.77769.00
Lee, John,19801193.010.000.000.00193.01
Peterson, Isabella,2808039.980.000.0039.980.00
Washington, Alexandra, E,15498256.520.000.0074.46182.06
Davis, Daniel,11711999.220.000.0086.48912.74
Washington, Alexis,1978146.260.000.007.2838.98
Ramirez, Richard, C,282397.280.000.007.280.00
Chandra, Allen,2932753.990.000.000.0053.99
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Powell, Katherine, C,14574177.600.000.000.00177.60
Gonzales, Nathan, M,12107222.230.000.0032.27189.96
Gonzalez, Jordan,15157213.940.000.00123.9889.96
Foster, Antonio,12795108.540.000.0066.2642.28
Harris, Anthony,2144721.980.000.000.0021.98
Stewart, Andrea, M,27252782.990.000.00782.990.00
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Torres, Taylor,16666205.440.000.00123.9881.46
Howard, Morgan, T,229713578.270.003578.270.000.00
Robinson, Julia,28121119.980.000.000.00119.98
Rivera, Sara,187852350.960.000.000.002350.96
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
Gonzales, Brittany,217104187.233578.270.000.00608.96
Thomas, Emily,2180339.980.000.000.0039.98
Hughes, Morgan, T,11642392.890.000.0049.48343.41
Rivera, Rachel, S,2899678.980.000.000.0078.98
Russell, Xavier,12964119.950.000.000.00119.95
Nath, Yolanda, A,2462513.980.000.000.0013.98
Lopez, Isaiah,18968151.430.000.000.00151.43
Cooper, Paige,14119148.940.000.000.00148.94
Jai, Kevin,1983678.960.000.0038.9839.98
Diaz, Katherine, P,115262376.960.000.002376.960.00
Torres, Erin,1218287.250.000.0037.2949.96
Alexander, Angelica,2271471.950.000.000.0071.95
Richardson, Lauren, C,14867839.480.000.000.00839.48
Lal, Caleb, R,1586874.460.000.000.0074.46
Rivera, Ariana,261734.990.000.000.004.99
Jenkins, Alexandra, D,11632924.610.000.00160.51764.10
Chen, Jack, E,17579151.430.000.000.00151.43
Hill, Jordan, J,16005198.730.000.00102.2796.46
Price, Isabelle,201825749.970.003374.990.002374.98
Wilson, Madison, H,1982821.980.000.000.0021.98
Russell, Chloe, M,12763589.960.000.000.00589.96
Smith, Noah,13175166.920.000.000.00166.92
Henderson, Hailey, C,171481775.470.000.000.001775.47
Bailey, Maria, C,1915034.980.000.000.0034.98
Moore, Hunter,14897196.270.000.0071.58124.69
White, Greg, C,174032322.280.000.000.002322.28
Washington, Riley, L,185441155.480.000.001155.480.00
Butler, Morgan, E,2050068.490.000.000.0068.49
Alvarez, Melody,2507068.490.000.000.0068.49
Li, Connor,201863191.910.002071.420.001120.49
Thompson, Lucas, O,212774.990.000.000.004.99
Martin, Kellie, R,28195574.980.000.000.00574.98
Hughes, Stephanie,263161000.440.001000.440.000.00
Turner, Mary,220154.990.000.000.004.99
Harris, Natalie,2368259.980.000.0059.980.00
King, Gabrielle,263504.990.000.000.004.99
Alexander, Ashley, J,200074495.480.003374.990.001120.49
Phillips, Mackenzie,12444228.430.000.00113.96114.47
Lewis, Ethan,27998144.470.000.000.00144.47
Brooks, Steven, C,14877889.470.000.000.00889.47
Parker, Kaylee, M,2773878.980.000.000.0078.98
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Thompson, Ethan,199894495.480.003374.990.001120.49
Wright, Jennifer,2650559.980.000.0059.980.00
Brooks, Victoria, H,16479158.510.000.000.00158.51
Rubio, Kellie,27653128.970.000.000.00128.97
Flores, Isabelle, A,15526188.320.000.0096.0792.25
Umeda, Masaki,16717233.810.000.000.00233.81
Perez, Katherine, J,2207924.270.000.000.0024.27
Ms., Coleman, Abigail, C,238684829.390.003578.270.001251.12
Reed, Bryan,18884133.930.000.000.00133.93
Gomez, Briana, A,2878443.980.000.000.0043.98
Washington, Caroline, D,231145996.320.003578.270.002418.05
Thompson, Joshua, F,259992181.560.000.002181.560.00
Torres, Christina, M,20746119.950.000.000.00119.95
Lal, Kyle,17360122.180.000.000.00122.18
Howard, Alexandra,207363194.580.000.002049.101145.48
Powell, Ian,2608564.470.000.000.0064.47
Serrano, Albert, E,133284708.020.000.000.004708.02
Foster, Carson, L,16959135.350.000.0085.4849.87
Cook, Bryce,2864069.990.000.000.0069.99
Griffin, Miguel,2146476.970.000.000.0076.97
Walker, Emma, M,2520998.960.000.000.0098.96
Gonzales, Trevor, K,16085143.530.000.0014.98128.55
Ma, Tiffany,2157739.980.000.000.0039.98
Anand, Brendan, L,1984721.980.000.000.0021.98
Brown, Anthony, J,19399151.430.000.000.00151.43
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Green, Mackenzie, C,280737.280.000.000.007.28
Allen, Amanda,2235339.980.000.000.0039.98
Martin, Samuel,15874225.440.000.0069.99155.45
Huang, Kristen,251002443.350.002443.350.000.00
Perez, Barry, M,2728269.990.000.000.0069.99
Hughes, Eduardo,15564188.520.000.000.00188.52
Sara, Ivan, L,2509067.930.000.000.0067.93
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Alexander, Elijah,11738331.680.000.00141.73189.95
Johnson, Andrew, F,262942443.350.000.002443.350.00
Evans, Elijah, S,2588439.980.000.000.0039.98
Watson, Victoria,16125588.960.000.000.00588.96
Chen, Jackson, S,270751371.950.00782.990.00588.96
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Bradley, Alexandria,176911779.470.000.000.001779.47
Turner, Sean,227324133.240.003578.270.00554.97
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Moreno, Marie,2773969.990.000.000.0069.99
Williams, Joshua,260514.990.000.000.004.99
Russell, Isabella, A,11507645.780.000.0028.48617.30
Rogers, Shelby,11712127.800.000.0042.5985.21
Simmons, James,198844588.450.003399.990.001188.46
Rodriguez, Morgan,237304828.110.003578.270.001249.84
Allen, Angel, G,15571101.850.000.0034.8966.96
Flores, Emma, P,15543180.940.000.000.00180.94
Evans, James, C,206654408.560.000.002049.102359.46
Morgan, Marcus, W,289682.290.000.000.002.29
Watson, Shelby, J,14911867.970.000.000.00867.97
Martin, Lucas, L,221144183.233578.270.000.00604.96
Evans, Jordan,2920939.980.000.0039.980.00
Lee, Ian,19646197.040.000.000.00197.04
Flores, Brittany,169062359.980.000.000.002359.98
Thompson, Tyler,2750269.990.000.0069.990.00
Carter, Jason,11724210.090.000.00113.8696.23
Wright, Robert, C,158894848.030.000.000.004848.03
Turner, Morgan,11823178.470.000.000.00178.47
Bennett, Jordyn, L,222304223.230.003578.270.00644.96
Wilson, Andrew, R,182362414.990.000.000.002414.99
Brooks, Isaac, M,233854829.390.003578.270.001251.12
Washington, Vanessa,238194802.110.003578.270.001223.84
Martin, Noah, A,1765775.970.000.0075.970.00
Jones, Dalton, T,189512334.970.000.000.002334.97
Patterson, Natalie,16123629.970.000.000.00629.97
Green, Sophia, E,249772181.560.002181.560.000.00
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Turner, Wyatt,200345769.960.003399.990.002369.97
Roberts, Rebecca,2800094.480.000.000.0094.48
Coleman, Dylan,27403132.970.000.000.00132.97
Hughes, Luke, I,270141274.080.00699.100.00574.98
Cox, Katelyn, B,2174230.970.000.000.0030.97
Diaz, Kaitlyn, B,292304.990.000.004.990.00
Wright, Jackson,11698225.950.000.000.00225.95
Hughes, Caroline, C,2830278.980.000.0078.980.00
Adams, Carlos,1982236.960.000.000.0036.96
Martin, Tyler, L,2772469.990.000.000.0069.99
Thomas, Logan, A,14091251.200.000.0053.99197.21
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Perry, Marcus, L,206563245.900.000.002071.421174.48
Alexander, Taylor,17482146.940.000.0076.9769.97
Griffin, Jason, L,112001267.110.000.00391.08876.03
Simmons, Sarah, V,11500651.980.000.00118.96533.02
Russell, Jacqueline,18391100.960.000.0078.9821.98
Zhang, Heather,166543056.320.000.00751.342304.98
Johnson, Ian, E,2173283.470.000.000.0083.47
Perry, Olivia,203754438.380.000.002071.422366.96
Cook, Megan, J,2029956.970.000.000.0056.97
Reed, Morgan, E,2877923.970.000.000.0023.97
Morris, Haley, A,2354848.970.000.000.0048.97
Hall, Amber,20106131.950.000.000.00131.95
Sanders, Isaiah,2587339.980.000.000.0039.98
Parker, Natalie, A,251043018.330.002443.350.00574.98
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Gomez, Renee, L,253712181.560.002181.560.000.00

Generated 2025-11-04 15:05:07.404 UTC