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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Zhang, Robert,188551155.480.000.000.001155.48
Lewis, Lucas, A,232094802.110.003578.271223.840.00
Ramos, Derrick,18449100.940.000.0030.9769.97
Young, Adam,12984200.200.000.00107.2692.94
Moore, Hunter,14897196.270.000.0071.58124.69
Bryant, Isabella, L,229956060.500.003578.270.002482.23
Rodriguez, Anthony, G,238294802.110.003578.270.001223.84
Wright, Jennifer,2650559.980.000.0059.980.00
Ramirez, Ian,166783162.310.000.00742.352419.96
Ward, Angela, M,2775669.990.000.000.0069.99
Reed, Kaylee, R,17371151.920.000.000.00151.92
Evans, Maria,22544127.280.000.00127.280.00
Robinson, Dylan, L,1472481.530.000.000.0081.53
Ortega, Byron,233064828.110.003578.270.001249.84
Collins, Hailey,11709325.890.000.0021.49304.40
Allen, Sean, L,12097159.220.000.000.00159.22
Brooks, Lucas, S,16089342.030.000.000.00342.03
Young, Julia, J,274144.990.000.000.004.99
Morgan, Evan, G,14725318.830.000.0069.97248.86
Patterson, Taylor,12147271.450.000.000.00271.45
Roberts, Wyatt,15900699.970.000.00699.970.00
Sanders, Melissa, R,242844837.340.003578.270.001259.07
Henderson, Ashley,111851381.370.000.00232.801148.57
Moore, Andrew, A,13944150.130.000.0036.27113.86
Richardson, Erin, R,1633188.850.000.0038.8849.97
Sanz, Lori, L,238654891.610.003578.270.001313.34
Kumar, Elijah,15197156.920.000.000.00156.92
Ross, Jose,2744178.980.000.0078.980.00
Smith, Lucas, P,1809064.910.000.000.0064.91
Campbell, Evan, W,243424828.110.003578.270.001249.84
Murphy, Brianna, K,2834269.990.000.000.0069.99
Harris, Jacob, G,2367939.980.000.0039.980.00
Rivera, Hailey, R,2079239.980.000.000.0039.98
Perry, Jonathan, T,27026699.100.00699.100.000.00
Jenkins, Alexandra, D,11632924.610.000.00160.51764.10
Sandberg, Chase,2190475.970.000.000.0075.97
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Simmons, Caleb, M,121934833.030.000.000.004833.03
Thomas, Zachary, D,28045119.980.000.000.00119.98
Gonzales, Brittany,217104187.233578.270.000.00608.96
Martinez, Hannah, M,246664370.610.003578.270.00792.34
Dominguez, Erika, C,21251191.270.000.000.00191.27
Hernandez, Jamie,27283119.980.000.00119.980.00
James, Sara,198023374.993374.990.000.000.00
Rogers, Sean, G,18685124.460.000.000.00124.46
Chandra, Allen,2932753.990.000.000.0053.99
Ramirez, Brian, M,116182369.960.000.002369.960.00
Morris, Paige, W,220414167.233578.270.000.00588.96
Diaz, Luke,12054402.530.000.00139.97262.56
Nelson, Katherine,2802178.980.000.000.0078.98
Phillips, Isaiah,28631144.470.000.00144.470.00
Ye, Alisha, J,220084141.233578.270.000.00562.96
Carter, Jason,11724210.090.000.00113.8696.23
Torres, Christina, M,20746119.950.000.0064.9754.98
Ward, Kaylee, A,244154.990.000.004.990.00
Collins, Lucas, T,219214142.753578.270.000.00564.48
Bennett, Maria, G,229837.280.000.000.007.28
Richardson, Brian,2860878.980.000.000.0078.98
Butler, Isabel,16241126.960.000.000.00126.96
Morris, Richard,2007039.980.000.000.0039.98
Cook, Bryce,2864069.990.000.000.0069.99
Edwards, Connor,16950211.010.000.000.00211.01
Deng, Damien, A,16873578.460.000.000.00578.46
Parker, Katherine,13268289.700.000.0068.97220.73
Perry, Christian,246714354.600.003578.270.00776.33
Fernandez, Cesar,200355694.980.003374.990.002319.99
Thomas, Charles,250942443.350.002443.350.000.00
Adams, Haley, M,247862443.350.002443.350.000.00
Brown, Morgan,2919778.980.000.000.0078.98
Murphy, Catherine, L,1650692.050.000.000.0092.05
Jai, Hunter, M,28272111.950.000.000.00111.95
Harris, Isabella,17119214.900.000.0077.96136.94
Rogers, Sara,198744544.450.003374.990.001169.46
Smith, Katherine, J,13197105.190.000.000.00105.19
Harris, Anthony,2144721.980.000.000.0021.98
Gomez, Renee, L,253712181.560.002181.560.000.00
Lewis, Morgan,17410168.740.000.000.00168.74
Murphy, Dalton, N,27043782.990.00782.990.000.00
Brown, Anna,1624795.820.000.000.0095.82
Hughes, Stephanie,263161000.440.001000.440.000.00
Parker, Amanda,1808151.970.000.000.0051.97
Cox, Lucas, J,253932443.350.002443.350.000.00
Miller, Alexis, A,12196124.930.000.000.00124.93
Wang, Zachary,2214489.970.000.000.0089.97
Fernandez, Ruth,205463246.550.000.002049.101197.45
Perry, Marcus, L,206563245.900.000.002071.421174.48
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Alexander, Caroline,176541759.970.000.000.001759.97
Moore, Wyatt, F,189712351.960.000.000.002351.96
Wilson, Chloe, A,11640409.120.000.0075.48333.64
Barnes, Dalton, C,178581700.990.000.000.001700.99
Peterson, Xavier, R,2645639.980.000.000.0039.98
Hayes, Logan, J,19026113.240.000.0037.2775.97
Brooks, Victoria, H,16479158.510.000.000.00158.51
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Ward, Cole,214907.280.000.000.007.28
Collins, Isaac,260777.280.000.000.007.28
Gonzales, Emily, P,21777180.980.000.000.00180.98
Reed, Marcus,14582111.790.000.0014.9896.81
Sánchez, Angela, C,176551750.980.000.000.001750.98
Coleman, Samuel, N,17450123.980.000.000.00123.98
Flores, Arianna,217274132.243578.270.000.00553.97
James, Bryce,13466133.450.000.000.00133.45
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
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Butler, Cassidy, L,21792114.460.000.000.00114.46
Anderson, Destiny,12895336.650.000.0037.27299.38
Alexander, Edward, E,18524195.950.000.000.00195.95
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Baker, Eduardo,180921789.450.000.000.001789.45
Barnes, Ian, M,16106133.540.000.000.00133.54
Barnes, Brittany, R,15340156.040.000.0074.4681.58
Ma, Tiffany,2157739.980.000.000.0039.98
Foster, Abigail,1982346.470.000.000.0046.47
Watson, Victoria,16125588.960.000.000.00588.96
Powell, Elijah, E,231135997.330.003578.270.002419.06
Hall, Wyatt,2382713.980.000.000.0013.98
Sharma, Jackson,16876151.840.000.000.00151.84
Turner, Sean,227324133.240.003578.270.00554.97
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Williams, Ethan,243094793.120.003578.270.001214.85
Lal, Jack, R,185251735.980.000.000.001735.98
Jones, Alexandra, B,2020245.950.000.000.0045.95
Chen, Jack, E,17579151.430.000.000.00151.43
Garcia, Kayla, L,2130881.460.000.000.0081.46
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Washington, Caroline, D,231145996.320.003578.270.002418.05
Ward, Ian,12056213.920.000.000.00213.92
Thomas, Jeremiah,183721760.470.000.000.001760.47
Campbell, Chloe,11212760.930.000.00231.72529.21
Ward, Destiny,16128539.990.000.000.00539.99
Perez, Jonathan, R,2345512.940.000.000.0012.94
Johnson, Madison, L,15530846.460.000.000.00846.46
Srini, Evelyn,16855150.950.000.000.00150.95
Williams, Edward, D,14274121.560.000.000.00121.56
Thomas, David,168363193.790.000.000.003193.79
Martin, Jill, C,11824181.030.000.0069.97111.06
Gomez, Briana, A,2878443.980.000.000.0043.98
Lopez, Jack, I,2904751.460.000.000.0051.46
Griffin, James,28189567.760.000.000.00567.76
Parker, Natalie, A,251043018.330.002443.350.00574.98
Stewart, Makayla,16649115.940.000.000.00115.94
Sanders, Xavier,1672173.750.000.000.0073.75
Campbell, Timothy,2584513.980.000.000.0013.98
Rivera, Makayla, A,2878334.990.000.000.0034.99
Powell, Blake, J,2237139.980.000.000.0039.98
Carter, Jose, H,12532235.720.000.000.00235.72
Long, Natalie,14363192.340.000.000.00192.34
Cook, Steven, J,27053782.990.00782.990.000.00
Kumar, Austin,204834400.060.000.002049.102350.96
Hall, Amber,20106131.950.000.000.00131.95
Coleman, Jose, S,253494.990.000.000.004.99
White, Emily, M,159174679.060.000.000.004679.06
Johnson, Anthony, D,270224.990.000.000.004.99
Hayes, Oscar,2652729.260.000.000.0029.26
Stewart, Cody, A,212843223.580.000.002049.101174.48
Coleman, Joan, W,2669964.470.000.000.0064.47
Smith, Tyler, J,2034156.970.000.000.0056.97
Price, Nicole, N,15815141.830.000.000.00141.83
Lopez, Bailey, R,185571179.470.000.001179.470.00
Sanders, Alexandra,259112181.560.000.002181.560.00
Chen, David,2720839.980.000.000.0039.98
Diaz, Ryan, J,16910141.960.000.0071.9769.99
Blanco, Randall,263211554.410.000.001000.44553.97
Ramirez, Jennifer, E,213114472.580.000.002049.102423.48
Moreno, Lance, A,2922939.980.000.000.0039.98
Williams, Zachary, B,27099782.990.000.00782.990.00
Adams, Katherine, M,235184.990.000.000.004.99
Gutierrez, Neil, L,214897.280.000.000.007.28
Townsend, Jeremiah, I,265031000.440.000.001000.440.00
Campbell, Natalie, L,115122319.990.000.000.002319.99
Edwards, Elijah, D,281577.280.000.000.007.28
Cooper, Timothy, J,206513198.570.000.002049.101149.47
She, Alisha, G,247574343.590.003578.270.00765.32
Sanchez, Faith,270494.990.000.000.004.99
Cooper, Christina, C,265121000.440.000.001000.440.00
Torres, Abigail,253674.990.000.000.004.99
Rubio, Javier, E,1972664.240.000.0064.240.00
Phillips, Miguel,2049812.940.000.000.0012.94
Gonzales, Ashley, C,1860051.970.000.000.0051.97
Wu, Randy, J,116472365.940.000.002365.940.00
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Edwards, Eric,2462768.490.000.000.0068.49
Wilson, Emily,174002331.950.000.000.002331.95
Davis, Jasmine, M,265291549.420.000.001000.44548.98
Alexander, Aidan,17387148.190.000.0056.9791.22
Jackson, Victoria,270194.990.000.000.004.99
Thompson, Devin,207084406.400.000.002071.422334.98
Moreno, Meredith, D,2228589.970.000.000.0089.97
Walker, Richard, T,19640224.550.000.000.00224.55
Ward, Nicole, L,212724435.380.000.002071.422363.96
Roberts, Thomas, J,219394163.243578.270.000.00584.97
Harris, Joshua, L,2028095.940.000.0030.9764.97
Garcia, Hunter, J,213053204.580.000.002049.101155.48
Price, Miranda,26629699.10699.100.000.000.00
Martin, Noah, A,1765775.970.000.0075.970.00
Perez, Angel, S,213362628.350.000.002071.42556.93
Hall, Morgan,2172641.950.000.000.0041.95
Robinson, William,20103103.480.000.000.00103.48
James, Christina,17409219.920.000.000.00219.92
Martin, Lucas, L,221144183.233578.270.000.00604.96
Diaz, Thomas, O,16020595.960.000.000.00595.96
Coleman, Vanessa,215892589.090.000.002049.10539.99
Williams, Ryan, R,222475978.610.003578.270.002400.34
Baker, Allison,2649558.980.000.000.0058.98
Ward, Juan, H,215952649.560.000.002049.10600.46
Lopez, Eduardo, J,266401288.060.00699.100.00588.96
Richardson, Arianna, C,1205534.980.000.0034.980.00
Hughes, Miranda,266784.990.000.000.004.99
Sanchez, Alex, K,131014736.030.000.000.004736.03
Scott, Eric,282484.990.000.004.990.00
Smith, Justin, P,1982721.980.000.000.0021.98
Henderson, Jackson, A,221215997.330.003578.270.002419.06
Miller, Victoria,15816188.020.000.0081.46106.56
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Perry, Melissa,221284142.230.003578.270.00563.96
Perry, Samuel,18811100.960.000.00100.960.00
Walker, Brandon, J,159164793.270.000.000.004793.27
Brown, Isabella, L,266921266.860.00699.100.00567.76
Griffin, Jack, L,1768632.280.000.000.0032.28
Cooper, Alexandra,19541131.240.000.000.00131.24
Rodriguez, Brianna, J,222674167.230.003578.270.00588.96
Bailey, Lauren,15864103.550.000.000.00103.55
Henderson, Logan, C,2236656.970.000.000.0056.97
Flores, Emily,13206163.190.000.0069.9793.22
Alexander, Nathan, A,187951198.970.000.000.001198.97
Miller, Sydney, A,134404818.530.000.000.004818.53
Bell, Gabrielle,223735976.320.003578.270.002398.05
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Garcia, Isabella,18382204.940.000.000.00204.94
Henderson, Gabrielle, B,186031205.470.000.000.001205.47
Griffin, Haley, L,1892582.180.000.000.0082.18
Sanders, Allison, B,18852268.250.000.000.00268.25
Brooks, Makayla,222526047.320.003578.270.002469.05
Gray, Cindy, A,13198114.950.000.0099.9714.98
Griffin, Jennifer, B,14244154.960.000.000.00154.96
Perry, Oscar,227856029.570.003578.272451.300.00
Rodriguez, Julia, A,264884.990.000.004.990.00
Ross, Alexia, S,13231247.900.000.000.00247.90
Taylor, Ryan,170251709.980.000.000.001709.98
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Kelly, Trinity,2609515.230.000.000.0015.23
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Evans, Jordan,2920939.980.000.0039.980.00
Clark, Miguel, D,169872414.990.000.000.002414.99
Reed, Erin, I,14353128.840.000.0074.9853.86
Bryant, Rachel,220197.280.000.007.280.00

Generated 2025-11-02 13:30:29.889 UTC