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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Flores, Gabriel,271117.280.000.000.007.28
Collins, Isaac,260777.280.000.000.007.28
Perry, Ryan,132494795.340.000.000.004795.34
Jones, Nicole,14504112.270.000.000.00112.27
Simmons, Dylan,16133107.850.000.0038.8868.97
Peterson, Alex, M,13423132.900.000.000.00132.90
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Sanders, Allison, B,18852268.250.000.000.00268.25
Smith, Alexandra,2829261.960.000.000.0061.96
Nelson, Luis,234884.990.000.000.004.99
Diaz, Jason,17374206.630.000.0089.46117.17
Thomas, Jeremiah,183721760.470.000.000.001760.47
King, Caleb, J,2898678.980.000.000.0078.98
Brown, Dylan, J,124492351.960.000.000.002351.96
Jones, Samantha,1831721.980.000.000.0021.98
Srini, Ruben,18078200.940.000.000.00200.94
Price, Marissa,15826160.740.000.00120.4840.26
Gonzalez, Jeremiah,17468128.910.000.0071.9556.96
Hughes, Riley,2928449.990.000.000.0049.99
Young, Jenna, W,163652490.180.000.000.002490.18
Flores, Hannah,1952540.230.000.000.0040.23
Collins, Sierra,185491169.460.000.001169.460.00
Griffin, Haley, L,1892582.180.000.000.0082.18
Harris, Megan,232814828.110.003578.271249.840.00
Evans, Alexandra,2432268.490.000.000.0068.49
Peterson, Christina,2897694.480.000.000.0094.48
Campbell, Evan, W,243424828.110.003578.270.001249.84
Taylor, Ryan,170251709.980.000.000.001709.98
Navarro, Jerome, B,11519717.280.000.0022.18695.10
Nelson, James, L,245257.280.000.007.280.00
Butler, Benjamin, C,189722369.970.000.000.002369.97
Perez, Dalton,110911125.360.000.00213.86911.50
Cannata, Gabrielle, C,217254.990.000.000.004.99
Flores, Julia, E,172631700.990.000.000.001700.99
Foster, Nicole, A,2349489.970.000.000.0089.97
Foster, Alyssa, I,14875839.480.000.000.00839.48
Miller, Katherine, B,27102782.990.000.00782.990.00
Gonzales, Nathan, M,12107222.230.000.0032.27189.96
Foster, Abigail,1982346.470.000.000.0046.47
Price, Mariah, C,2074549.480.000.000.0049.48
Thompson, Brianna, X,1864269.970.000.000.0069.97
Rivera, Amanda,11131115.920.000.000.00115.92
Flores, Emma, P,15543180.940.000.000.00180.94
Lee, Ian,19646197.040.000.000.00197.04
Miller, Alexis, A,12196124.930.000.000.00124.93
Torres, Mackenzie,28153570.470.000.000.00570.47
Sanchez, Jeremiah, E,2226521.980.000.0021.980.00
Russell, Fernando,27084782.990.000.00782.990.00
Campbell, Lucas,2932953.990.000.000.0053.99
Hill, Alexandra, K,15172215.450.000.0036.27179.18
Wilson, Andrew, R,182362414.990.000.000.002414.99
Powell, Vanessa,26630699.100.00699.100.000.00
Lewis, Ethan,27998144.470.000.000.00144.47
Smith, Katherine, J,13197105.190.000.000.00105.19
Young, Adam,12984200.200.000.00107.2692.94
Coleman, Samuel, N,17450123.980.000.000.00123.98
Edwards, Alexandra,133582386.940.000.000.002386.94
Lal, Jonathan,2009671.460.000.000.0071.46
Collins, Connor, J,27270782.990.000.00782.990.00
Hughes, Justin, M,181222439.990.000.000.002439.99
Alexander, Sarah,1941129.990.000.000.0029.99
Murphy, Olivia, V,202063204.580.002049.100.001155.48
Lopez, Carlos,186171147.770.000.000.001147.77
Washington, Hailey, S,2588559.980.000.000.0059.98
Roberts, Robert, R,1898656.970.000.0056.970.00
Sanchez, Jared, J,2585064.470.000.000.0064.47
Morris, Paige, W,220414167.233578.270.000.00588.96
Diaz, Elijah,200004495.480.003374.990.001120.49
Rogers, Jared, J,12166162.220.000.000.00162.22
Fernandez, Ruth,205463246.550.000.002049.101197.45
Stewart, Lucas, J,2934198.970.000.000.0098.97
Powell, David, W,266151000.440.000.001000.440.00
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Roberts, Amanda,171752334.980.000.000.002334.98
Bryant, Rachel,220197.280.000.007.280.00
Campbell, Adam, A,214002688.890.000.002071.42617.47
Lopez, Katelyn,11820232.710.000.0060.47172.24
Jai, Edwin,169211754.980.000.000.001754.98
Hayes, Dalton, C,188822322.280.000.000.002322.28
Hill, Carlos,12919257.880.000.00158.9398.95
Yuan, Brendan, S,247444.990.000.000.004.99
Carter, Jonathan,14578848.470.000.000.00848.47
Moore, Chloe, L,2626913.980.000.000.0013.98
Hughes, Edward,200234530.470.003374.990.001155.48
Anand, Brendan, L,1984721.980.000.000.0021.98
Umeda, Masaki,16717233.810.000.000.00233.81
Price, Oscar, G,11833240.010.000.000.00240.01
Lopez, Bailey, R,185571179.470.000.001179.470.00
Griffin, Melissa, L,287807.950.000.000.007.95
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Gomez, Briana, A,2878443.980.000.000.0043.98
Fernandez, Darren,2899278.980.000.000.0078.98
Ross, Natalie, J,12916261.220.000.000.00261.22
Long, Morgan, H,213522625.390.000.002071.42553.97
Martin, Kellie, R,28195574.980.000.000.00574.98
Walker, Destiny, M,169961754.980.000.000.001754.98
Alexander, Julian,132172351.960.000.000.002351.96
Garcia, Xavier, M,2030071.970.000.000.0071.97
Stewart, Melissa,2517336.960.000.000.0036.96
Garcia, Jonathan,1888386.960.000.0029.9956.97
Torres, Dalton,235037.280.000.007.280.00
Roberts, Rebecca,2800094.480.000.000.0094.48
Thompson, Kayla, D,12363273.900.000.000.00273.90
Bryant, Connor,238424828.110.003578.270.001249.84
Brown, Morgan,2919778.980.000.000.0078.98
Thomas, Thomas,216292624.080.000.002049.10574.98
Ross, David, M,171431763.970.000.000.001763.97
Gonzales, Miranda,11660324.720.000.000.00324.72
Carter, Jesse, E,22141166.280.000.000.00166.28
Lee, Kayla, M,2078115.230.000.000.0015.23
Rogers, Bryce,174022304.980.000.000.002304.98
Gonzalez, Jordan,15157213.940.000.00123.9889.96
Evans, Elijah, S,2588439.980.000.000.0039.98
Patterson, Aaron, W,191131184.460.000.000.001184.46
Reed, Melanie, A,28160574.980.000.000.00574.98
Jenkins, Dakota, D,2067964.470.000.0064.470.00
Anderson, Lucas,2926639.980.000.000.0039.98
Foster, Deb,215012661.400.000.002661.400.00
Foster, Edward, R,18355150.950.000.000.00150.95
Ramirez, Ian,166783162.310.000.00742.352419.96
Smith, Hannah, J,2526554.980.000.0054.980.00
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Coleman, Miguel, D,2740069.990.000.0069.990.00
Patterson, Eduardo,11142866.810.000.0072.26794.55
Washington, Emma,191231170.480.000.000.001170.48
Morris, Chase, F,26789699.100.00699.100.000.00
James, Richard, D,15760109.230.000.003.99105.24
Brooks, Victoria, H,16479158.510.000.000.00158.51
Russell, Kaitlyn, M,244913578.270.003578.270.000.00
Edwards, Angel, J,2912469.990.000.000.0069.99
Williams, Sydney, J,15334848.470.000.000.00848.47
Jai, Adam,250952443.350.002443.350.000.00
Blanco, Randall,263211554.410.000.001000.44553.97
Davis, Ethan,136604750.010.000.000.004750.01
Shan, Logan,1867760.960.000.0029.9930.97
Flores, Arianna,217274132.243578.270.000.00553.97
Phillips, Luis, G,207347.280.000.000.007.28
Barnes, Brittany, R,15340156.040.000.0074.4681.58
Wilson, Madison, H,1982821.980.000.000.0021.98
Kumar, Austin,204834400.060.000.002049.102350.96
Martin, Christian, V,19709197.250.000.000.00197.25
Green, Sophia, E,249772181.560.002181.560.000.00
Coleman, Jennifer, L,27298782.990.000.00782.990.00
Turner, Adam, K,16109548.980.000.000.00548.98
Kelly, Erin, D,2351364.470.000.000.0064.47
Diaz, Katherine, P,115262376.960.000.002376.960.00
She, Martha, E,222515971.330.003578.270.002393.06
Richardson, Evan, J,15488165.300.000.000.00165.30
Hayes, Gavin, A,194001179.470.000.000.001179.47
Griffin, Miguel,2146476.970.000.000.0076.97
Gray, Marcus, T,183892401.450.000.000.002401.45
Green, Gabriella, C,2803569.990.000.000.0069.99
Lewis, Seth,26782699.100.00699.100.000.00
Turner, Jeremiah, F,19207791.320.000.000.00791.32
Carter, Madeline, A,2752269.990.000.000.0069.99
Russell, Richard,2763322.260.000.000.0022.26
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Brooks, Paige,222325985.310.003578.270.002407.04
Ross, Miranda,145984839.000.000.000.004839.00
Turner, Blake,12136131.740.000.000.00131.74
Flores, Julian,158464943.320.000.000.004943.32
Phillips, Haley, B,2807939.980.000.000.0039.98
Smith, Lucas, P,1809064.910.000.000.0064.91
Wilson, Grace,17539205.920.000.000.00205.92
Rodriguez, Morgan,237304828.110.003578.270.001249.84
Thompson, Kaitlyn, L,12430223.930.000.000.00223.93
Griffin, Madison, A,250932181.560.002181.560.000.00
Diaz, Gabrielle,14893839.480.000.000.00839.48
Sanz, Lori, L,238654891.610.003578.270.001313.34
Bryant, Brittany,2254548.970.000.000.0048.97
Smith, Tyler, J,2034156.970.000.000.0056.97
Hughes, Caroline, C,2830278.980.000.0078.980.00
Foster, Aaron,155664912.470.000.000.004912.47
Price, Stephanie,258922443.350.002443.350.000.00
Martin, Nicholas,233627.280.000.000.007.28
Perry, Samuel,18811100.960.000.00100.960.00
Lewis, Rachel, J,14900839.480.000.000.00839.48
Clark, Lauren,170341750.980.000.000.001750.98
Washington, Taylor,212664525.070.000.002049.102475.97
Wu, Randy, J,116472365.940.000.002365.940.00
Henderson, Caroline,2008256.970.000.000.0056.97
Ramirez, Jennifer, E,213114472.580.000.002049.102423.48
Richardson, Charles, I,121144719.020.000.002325.962393.06
Stewart, Marcus, R,2063221.980.000.000.0021.98
Barnes, Blake, A,178651789.970.000.000.001789.97
Dominguez, Erika, C,21251191.270.000.000.00191.27
Edwards, Eric,2462768.490.000.000.0068.49
Jai, Kevin,1983678.960.000.0038.9839.98
Brown, Isabella, L,266921266.860.00699.100.00567.76
Perry, James,192051249.840.000.000.001249.84
Simmons, Nicole, S,2617729.480.000.000.0029.48
Smith, Austin,13707149.050.000.000.00149.05
Foster, Paige,2742894.480.000.000.0094.48
Jackson, Andrew,2047985.480.000.000.0085.48
Diaz, Trevor, B,2051954.960.000.000.0054.96
Johnson, Jonathan,220597.280.000.000.007.28
Russell, Megan,16220562.960.000.000.00562.96
Evans, James, C,206654408.560.000.002049.102359.46
Carter, Jose, H,12532235.720.000.000.00235.72
Reed, Sean, L,145974803.310.000.000.004803.31
Gonzalez, James, M,188421155.480.000.000.001155.48
Sharma, Thomas, A,18637121.940.000.000.00121.94
Hill, Haley, J,161033142.320.000.00792.342349.98
Huang, Kristen,251002443.350.002443.350.000.00
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Thomas, William, A,216142589.090.000.002049.10539.99
Blue, Marcus, L,27550782.990.000.00782.990.00
Lal, Robert, L,14084138.680.000.000.00138.68
Turner, Kaylee, M,16213154.540.000.000.00154.54
Russell, Ian, T,2474613.980.000.0013.980.00
Gonzales, Trevor, K,16085143.530.000.0014.98128.55
Parker, Amanda,1808151.970.000.000.0051.97
Green, Xavier,2356739.980.000.000.0039.98
Anderson, Emma, A,185801170.480.000.000.001170.48
Howard, Erin, L,183621725.210.000.000.001725.21
Williams, Joshua,260514.990.000.000.004.99
Mitchell, Maria, D,27404782.990.000.00782.990.00
Gonzalez, Logan, J,1748364.500.000.0032.2832.22
Van, Bobby,27757132.970.000.00132.970.00
White, Emily, M,159174679.060.000.000.004679.06
Flores, Isabelle, A,15526188.320.000.0096.0792.25
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Brown, Christian,227554.990.000.000.004.99
Harris, Emily, P,1986298.480.000.000.0098.48
Cooper, Timothy, J,206513198.570.000.002049.101149.47
Reed, Morgan, E,2877923.970.000.000.0023.97
Young, Kaylee, S,13756298.490.000.0058.47240.02
Sun, Arturo, C,11498557.540.000.0012.94544.60
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Bell, Alexandria, A,13758284.130.000.0042.28241.85
Ross, Antonio,18322148.890.000.000.00148.89
Coleman, Vanessa,215892589.090.000.002049.10539.99
Blue, Melanie, L,178611749.960.000.000.001749.96
Barnes, Haley, J,2133939.980.000.0039.980.00
Jackson, Hannah, G,131432404.970.000.000.002404.97
James, Christina,17409219.920.000.000.00219.92
Henderson, Jackson, A,221215997.330.003578.270.002419.06
Adams, Mackenzie, A,14640812.420.000.000.00812.42
Ortega, Byron,233064828.110.003578.270.001249.84
Butler, Jonathan,261804.990.000.000.004.99
Coleman, Isabel, S,12530337.900.000.00123.98213.92
Taylor, Edward, C,17442319.880.000.00230.9088.98
Davis, Thomas,167641760.470.000.000.001760.47
Reed, Michelle,2804669.990.000.000.0069.99
Bailey, Morgan, E,213542646.400.000.002071.42574.98
Moore, Wyatt, F,189712351.960.000.000.002351.96
Russell, Gail, L,212634.990.000.000.004.99
Campbell, Alex,119844730.320.000.002329.982400.34
Watson, Victoria,16125588.960.000.000.00588.96
Morris, Mason, J,22349124.990.000.000.00124.99
Diaz, Kaitlyn, B,292304.990.000.004.990.00
Ross, Elizabeth, E,141184741.340.000.000.004741.34
Ortega, Sheila, M,2763239.980.000.000.0039.98
Hill, Eric, G,2525667.930.000.0067.930.00
Smith, Andrew,1472387.570.000.0014.9872.59
Flores, Caleb, S,12165280.640.000.00243.3737.27
Garcia, Cameron,186411120.490.000.000.001120.49

Generated 2025-11-04 15:03:18.850 UTC