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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Rogers, Andrea, L,14328308.660.000.0049.97258.69
Perry, Samuel,18811100.960.000.00100.960.00
Foster, Emma,15468436.350.000.00159.99276.36
Sandberg, Chase,2190475.970.000.000.0075.97
Stewart, Destiny,13144281.470.000.00134.98146.49
Bell, Danielle,140414765.020.000.000.004765.02
Wilson, Andrew, R,182362414.990.000.000.002414.99
Long, Xavier,112512318.960.000.000.002318.96
Tang, Carl,2123832.270.000.000.0032.27
Green, Isabella,26620699.10699.100.000.000.00
Morris, Paige, W,220414167.233578.270.000.00588.96
Collins, Lucas, T,219214142.753578.270.000.00564.48
Jones, Nicole,14504112.270.000.000.00112.27
Parker, Jennifer, D,221184158.240.003578.270.00579.97
Brown, Anna,1624795.820.000.000.0095.82
Campbell, Hunter,17422174.920.000.000.00174.92
Bennett, Jordyn, L,222304223.230.003578.270.00644.96
Ross, Anna, D,15494275.440.000.0029.99245.45
Davis, Nicholas,1320173.160.000.000.0073.16
Rogers, Carlos,19645134.440.000.000.00134.44
Carter, Marcus, l,2147131.970.000.000.0031.97
Miller, Joseph, A,227134148.190.003578.270.00569.92
Brooks, Makayla,222526047.320.003578.270.002469.05
Perry, Oscar,227856029.570.003578.272451.300.00
Ross, Antonio,18322148.890.000.000.00148.89
Long, Julia, R,228895971.330.003578.270.002393.06
Gray, Jesse,14626197.040.000.000.00197.04
Hernandez, José, M,11253696.610.000.0098.97597.64
Stewart, Hailey,229036054.220.003578.270.002475.95
Flores, Logan, K,14631848.470.000.000.00848.47
Fernandez, Darren,2899278.980.000.000.0078.98
Allen, Amanda,2235339.980.000.000.0039.98
Rogers, Sean, G,18685124.460.000.000.00124.46
Rivera, Caitlin, L,261132730.540.000.002181.56548.98
Thompson, Ethan,199894495.480.003374.990.001120.49
Foster, Eric,229765971.330.003578.270.002393.06
Griffin, Maria,1840763.250.000.000.0063.25
Parker, James,11808610.190.000.000.00610.19
Harris, Isabella,17119214.900.000.0077.96136.94
Perry, Ryan,132494795.340.000.000.004795.34
Anderson, Megan, A,238594153.250.003578.27574.980.00
Smith, Katherine, J,13197105.190.000.000.00105.19
Martin, Brianna, M,235834829.390.003578.270.001251.12
Rogers, Jared, J,12166162.220.000.000.00162.22
Sanders, Melissa, R,242844837.340.003578.270.001259.07
Flores, Xavier,238664828.110.003578.270.001249.84
Henderson, Sarah, M,238674802.110.003578.270.001223.84
Long, Brandon, M,16110650.470.000.000.00650.47
Hughes, Luke, I,270141274.080.00699.100.00574.98
Perry, Jonathan, T,27026699.100.00699.100.000.00
Patterson, Maria, G,1333094.950.000.000.0094.95
Walker, Isabella,243864143.740.003578.27565.470.00
Russell, Kaitlyn, M,244913578.270.003578.270.000.00
Perry, Christian,246714354.600.003578.270.00776.33
Fernandez, Cesar,200355694.980.003374.990.002319.99
Stewart, Julia, L,129022329.980.000.000.002329.98
Turner, Adam, K,16109548.980.000.000.00548.98
Robinson, Abigail, R,183792362.270.000.000.002362.27
Sharma, Yolanda, K,250483046.840.002443.35603.490.00
Perez, Jordan, A,292674.990.000.000.004.99
Watson, Kimberly, A,201883226.900.002071.420.001155.48
Ross, Haley, T,253612443.350.002443.350.000.00
Thomas, Victoria, A,15536249.530.000.000.00249.53
Hughes, Stephanie,263161000.440.001000.440.000.00
Hernandez, Marcus,185952329.990.000.000.002329.99
Brown, Benjamin, D,151874725.320.000.000.004725.32
Cook, Steven, J,27053782.990.00782.990.000.00
Suarez, Juan, R,167631700.990.000.000.001700.99
Flores, Stephanie,259922721.550.000.002181.56539.99
Murphy, Shelby,244894.990.000.000.004.99
Hill, Fernando,247634.990.000.000.004.99
Smith, Andrew,1472387.570.000.0014.9872.59
Adams, Mackenzie, A,14640812.420.000.000.00812.42
Coleman, Jose, S,253494.990.000.000.004.99
Wright, Jackson,11698225.950.000.000.00225.95
Clark, Lauren,170341750.980.000.000.001750.98
Ward, Ian,12056213.920.000.000.00213.92
Parker, Amanda,1808151.970.000.000.0051.97
Scott, Gabrielle,270614.990.000.000.004.99
Evans, Luke,2917615.230.000.000.0015.23
Thomas, Samantha,2169093.970.000.000.0093.97
Brown, Samantha, G,2514739.980.000.000.0039.98
Morgan, Angela,24665109.970.000.000.00109.97
Washington, Thomas, C,2745137.430.000.000.0037.43
Green, Blake, P,11719287.200.000.000.00287.20
James, Christina,17409219.920.000.000.00219.92
Robinson, Sarah, A,2702859.980.000.000.0059.98
Reed, Catherine, M,203807.280.000.000.007.28
Zeng, Jake,18054106.930.000.000.00106.93
Foster, Trevor, J,2896469.990.000.000.0069.99
Collins, Hailey,11709325.890.000.0021.49304.40
Reed, Mariah,263731565.910.000.001000.44565.47
Wilson, Christian,27085782.990.000.00782.990.00
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Howard, Alexandra,207363194.580.000.002049.101145.48
Thompson, Devin,207084406.400.000.002071.422334.98
Stewart, Cody, A,212843223.580.000.002049.101174.48
Ward, Nicole, L,212724435.380.000.002071.422363.96
Adams, Connor,214232888.560.000.002049.10839.46
Dominguez, Erika, C,21251191.270.000.000.00191.27
Carter, Sydney,12959203.920.000.000.00203.92
Bell, Alex, M,167543118.600.000.00756.332362.27
Barnes, Brittany, R,15340156.040.000.0074.4681.58
Ramirez, Sydney,267007.280.000.000.007.28
Butler, Isabel,16241126.960.000.000.00126.96
Rivera, Makayla, A,2878334.990.000.000.0034.99
Williams, Edward, D,14274121.560.000.000.00121.56
Ward, Jade, D,14661195.020.000.000.00195.02
Bryant, Gabriel,2765669.990.000.000.0069.99
Walker, Jasmine,134604693.040.000.000.004693.04
Cooper, Alexandra,19541131.240.000.000.00131.24
Brown, Anthony, J,19399151.430.000.000.00151.43
Morgan, Isaiah,18978118.730.000.000.00118.73
Roberts, Amber, W,215822638.060.000.002049.10588.96
Hayes, Brittany,13941286.820.000.000.00286.82
Hall, Fernando,2210090.950.000.000.0090.95
Hayes, Carson, A,124472331.950.000.000.002331.95
Robinson, William,20103103.480.000.000.00103.48
Lewis, Ryan, A,203124.990.000.000.004.99
Garcia, Jonathan,1888386.960.000.0029.9956.97
Davis, Marcus, T,17337123.910.000.0086.9536.96
Kumar, Zachary,254334.990.000.000.004.99
Simmons, Jose,2464739.980.000.000.0039.98
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Ward, Stephanie, A,27429782.990.000.00782.990.00
Brooks, Mariah,216202620.400.000.002071.42548.98
Parker, Jordan,216212616.860.000.002049.10567.76
Patterson, Grace, M,27560782.990.000.00782.990.00
Bryant, Zachary,216552648.070.000.002648.070.00
Adams, Kaitlyn, A,11869239.600.000.0037.27202.33
Stewart, Lucas, J,2934198.970.000.000.0098.97
Thomas, Zachary, D,28045119.980.000.000.00119.98
Ross, Miranda,145984839.000.000.000.004839.00
Stewart, Cindy,14496804.480.000.000.00804.48
Thames, Bernard,2380368.490.000.000.0068.49
Diaz, Brandon,236764.990.000.004.990.00
Moreno, Lance, A,2922939.980.000.000.0039.98
Gutierrez, Neil, L,214897.280.000.000.007.28
Sanders, Sean,14341175.150.000.000.00175.15
Roberts, Amanda,171752334.980.000.000.002334.98
Jai, Luis, A,18320185.920.000.000.00185.92
Lewis, Ethan,27998144.470.000.000.00144.47
Patterson, Eric, A,2738478.980.000.000.0078.98
Roberts, Carlos,2319639.980.000.000.0039.98
Russell, Gail, L,212634.990.000.000.004.99
Diaz, Kaitlyn, B,292304.990.000.004.990.00
Peterson, Isabella,2808039.980.000.0039.980.00
Wang, Austin, A,1463284.970.000.009.9974.98
Rodriguez, Taylor,1607166.960.000.000.0066.96
Wilson, Emily,174002331.950.000.000.002331.95
Brooks, Evan,2340139.980.000.000.0039.98
White, Nicole,16731155.910.000.0084.9670.95
Perez, Charles,266937.280.000.007.280.00
Hughes, Caroline, C,2830278.980.000.0078.980.00
Gray, Cody, C,144594775.010.000.000.004775.01
Luo, Jodi,2921368.490.000.000.0068.49
Young, Courtney,176222374.980.000.000.002374.98
Jones, Michael, A,2210771.970.000.000.0071.97
Roberts, Wyatt,15900699.970.000.00699.970.00
Richardson, Erin, R,1633188.850.000.0038.8849.97
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Griffin, Seth, R,17585164.460.000.0078.9885.48
Nelson, James, L,245257.280.000.007.280.00
Hernandez, Sierra,27393123.980.000.00123.980.00
Gonzales, Paige,2170291.940.000.0039.9851.96
Hughes, Destiny, P,28027119.980.000.000.00119.98
Anderson, Isabella,137432349.980.000.000.002349.98
Edwards, Madeline,2077146.470.000.000.0046.47
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Bradley, Alexandria,176911779.470.000.000.001779.47
Parker, Eduardo, M,12939169.420.000.0077.9291.50
Edwards, Hunter,2422067.930.000.000.0067.93
Stewart, Olivia, B,1874923.780.000.000.0023.78
Chen, Jonathan, G,13096200.690.000.000.00200.69
Perry, Brandon,22095141.980.000.000.00141.98
Evans, Gabriel,2348789.970.000.000.0089.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
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Carter, Jose, H,12532235.720.000.000.00235.72
Allen, Mason,176252431.950.000.000.002431.95
Morgan, Evan, G,14725318.830.000.0069.97248.86
Gill, Robyn, J,127651750.980.000.001750.980.00
Ross, Aaron, N,118882376.960.000.002376.960.00
Smith, Hannah, J,2526554.980.000.0054.980.00
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Harris, Noah,292562393.060.000.002393.060.00
Robinson, Lauren,2719668.490.000.0068.490.00
Torres, Dalton,235037.280.000.007.280.00
Baker, Mason, A,132702394.950.000.000.002394.95
Martin, Katherine, J,2027339.980.000.000.0039.98
Richardson, Devin, G,2131836.960.000.000.0036.96
Flores, Brandon, L,2562189.970.000.000.0089.97
Raje, Mindy, A,16083561.970.000.000.00561.97
James, Emma,127812329.980.000.000.002329.98
Smith, Chloe,17619163.920.000.000.00163.92
Stewart, Makayla,16649115.940.000.000.00115.94
Parker, Jeremy,2866878.980.000.0078.980.00
Smith, Eduardo,2069139.980.000.0039.980.00
Cox, Sara, P,2775869.990.000.000.0069.99
Van, Bobby,27757132.970.000.000.00132.97
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Ross, Kelly,2607676.960.000.000.0076.96
Bradley, Evan,18506101.940.000.000.00101.94
Torres, Christina, M,20746119.950.000.000.00119.95
Martin, James, M,1987077.250.000.000.0077.25
Clark, Destiny, L,28600119.980.000.000.00119.98
Diaz, Faith, M,2236356.970.000.000.0056.97
Luo, Donna, E,248054.990.000.000.004.99
Brooks, Allison,146054750.010.000.000.004750.01
Reed, Gabriella, A,2743778.980.000.000.0078.98
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Campbell, Lucas,2932953.990.000.000.0053.99
Mitchell, Thomas, J,137112380.470.000.000.002380.47
Peterson, Xavier, R,2645639.980.000.000.0039.98
Wilson, Eduardo,15323804.470.000.000.00804.47
Martinez, Carol, D,17656578.460.000.000.00578.46
Griffin, Miguel,2146476.970.000.000.0076.97
Rogers, Paige, H,17125539.990.000.000.00539.99
Perez, Katherine, J,2207924.270.000.000.0024.27
Ross, Seth, M,184332329.980.000.000.002329.98
Lewis, Rachel, J,14900839.480.000.000.00839.48
Li, Thomas,181162376.960.000.000.002376.96
Ward, Cole,214907.280.000.000.007.28
Collins, Isaac,260777.280.000.000.007.28
Edwards, Logan,250024.990.000.000.004.99
Flores, Cassidy, L,233684.990.000.000.004.99
Miller, Destiny,251577.280.000.000.007.28
Smith, Megan, J,2671668.970.000.000.0068.97
Srini, Evelyn,16855150.950.000.000.00150.95
Morgan, Isabella, L,28602144.470.000.000.00144.47
Murphy, Brianna, K,2834269.990.000.000.0069.99
Turner, Mary,220154.990.000.000.004.99
Chandra, Allen,2932753.990.000.000.0053.99
Nelson, Katherine,2802178.980.000.000.0078.98
Robinson, Ian, D,138522294.990.000.000.002294.99
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Barnes, Blake, A,178651789.970.000.000.001789.97
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Harris, Anthony,2144721.980.000.000.0021.98
Cannata, Gabrielle, C,217254.990.000.000.004.99
Ma, Tiffany,2157739.980.000.000.0039.98
Taylor, Taylor,159054899.020.000.000.004899.02
Wang, Zachary,2214489.970.000.000.0089.97
Nath, Carl, H,29001624.970.000.000.00624.97
Bell, Chase,180911750.980.000.000.001750.98
Garcia, Kayla, L,2130881.460.000.000.0081.46
Sara, Ivan, L,2509067.930.000.000.0067.93
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Blanco, Armando, F,139182397.950.000.000.002397.95
Hughes, Austin, P,183681754.980.000.000.001754.98
Long, Rachel,2828339.980.000.000.0039.98
Gonzales, Gavin,2448813.980.000.000.0013.98
Collins, Charles, B,29041628.450.000.000.00628.45
Kapoor, Preston,2143156.970.000.000.0056.97
_SUM1806517.5065197.22486223.00320298.81934798.47

Generated 2025-11-06 23:01:58.504 UTC