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

240 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Adams, Mason, T,2052864.470.000.000.0064.47
Wood, Gavin,16964108.540.000.0021.9886.56
Russell, Katherine,2877169.990.000.000.0069.99
Anderson, Isabella,137432349.980.000.000.002349.98
Phillips, Andrea,1857383.740.000.000.0083.74
Taylor, Natalie, M,14338828.740.000.000.00828.74
Carter, Bailey,213322616.860.000.002049.10567.76
Brooks, Ian, W,2829064.470.000.000.0064.47
Morris, Alyssa,28072548.980.000.000.00548.98
Garcia, Patricia,11651226.430.000.000.00226.43
Ramirez, Richard, C,282397.280.000.000.007.28
White, James,253317.280.000.000.007.28
Cooper, Alexandra,19541131.240.000.000.00131.24
Smith, Chloe,17619163.920.000.000.00163.92
Hayes, Jason,261764.990.000.000.004.99
Garcia, Anna, B,15572104.550.000.000.00104.55
Rogers, Amanda, A,13920266.970.000.000.00266.97
Rogers, Paige, H,17125539.990.000.000.00539.99
Turner, Amanda, L,203183241.900.002071.420.001170.48
Foster, Edward, R,18355150.950.000.000.00150.95
Coleman, Miguel, D,2740069.990.000.0069.990.00
Ross, Antonio,18322148.890.000.000.00148.89
Johnson, Edward, H,23279124.990.000.000.00124.99
Peterson, Brian,12892419.470.000.000.00419.47
Torres, Haley, W,232834828.110.003578.270.001249.84
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Brown, Anthony, J,19399151.430.000.000.00151.43
Sanders, Isaiah,2587339.980.000.000.0039.98
Wilson, Tyler, L,15879196.930.000.000.00196.93
Young, Courtney,176222374.980.000.000.002374.98
Carter, Jose, H,12532235.720.000.000.00235.72
Long, Chloe,167841735.980.000.000.001735.98
Washington, Christian, R,2668639.980.000.000.0039.98
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Richardson, Melissa, E,111322371.940.000.000.002371.94
Cooper, Angela,195261179.470.000.000.001179.47
Thompson, Kaitlyn, L,12430223.930.000.000.00223.93
Perry, Oscar,227856029.570.003578.272451.300.00
Hall, Amber,20106131.950.000.000.00131.95
Peterson, Jessica, M,11868247.010.000.0061.97185.04
Nelson, Jennifer,171471700.990.000.000.001700.99
Coleman, Spencer,15993597.260.000.000.00597.26
Reed, Bryan,18884133.930.000.000.00133.93
Chen, Jack, E,17579151.430.000.000.00151.43
Young, Adam,12984200.200.000.0037.29162.91
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Walker, Jasmine,134604693.040.000.000.004693.04
Thomas, Matthew, K,13239185.700.000.000.00185.70
Price, Oscar, G,11833240.010.000.000.00240.01
Stewart, Destiny,13144281.470.000.000.00281.47
Perez, Kaitlyn, A,120812366.960.000.000.002366.96
Young, Kaylee, S,13756298.490.000.000.00298.49
Russell, Oscar, A,12140118.170.000.000.00118.17
Perry, Melissa,221284142.230.003578.270.00563.96
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Murphy, Richard, M,222994145.540.003578.270.00567.27
Morgan, Abigail, C,244314334.600.003578.270.00756.33
James, Emma,127812329.980.000.000.002329.98
Campbell, Gabriella,188411145.480.000.000.001145.48
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Moore, Fernando,265821000.440.000.001000.440.00
Harris, Destiny, M,137102341.460.000.000.002341.46
Diaz, Thomas, O,16020595.960.000.000.00595.96
Thompson, Abigail,243324816.090.003578.270.001237.82
Flores, Emma, P,15543180.940.000.000.00180.94
Simmons, Anna, K,124512367.920.000.000.002367.92
Roberts, Thomas, J,219394163.240.003578.270.00584.97
Jackson, Hannah, G,131432404.970.000.000.002404.97
Morgan, Andrea, M,16870149.040.000.0039.47109.57
Russell, Ian, T,2474613.980.000.0013.980.00
Hill, Jordan, J,16005198.730.000.000.00198.73
Price, Devin, M,18758158.510.000.000.00158.51
Taylor, Marcus, A,18944146.940.000.000.00146.94
Baker, Ian, V,262002756.540.000.002181.56574.98
Lewis, Isabella,2624267.930.000.000.0067.93
Thomas, Isabella, M,27265782.990.000.00782.990.00
Long, Natalie,14363192.340.000.000.00192.34
Jenkins, Dakota, D,2067964.470.000.000.0064.47
Williams, Morgan, C,203733226.900.000.002071.421155.48
Hayes, Luis,12880200.730.000.000.00200.73
Thomas, Seth,14567161.280.000.0096.0765.21
Flores, Xavier,238664828.110.003578.270.001249.84
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Johnson, Christopher,119794813.760.000.000.004813.76
Miller, Andrew, C,271104.990.000.000.004.99
Ward, Mariah, J,2158044.910.000.000.0044.91
Blue, Makayla,1900029.990.000.000.0029.99
Li, Connor,201863191.910.002071.420.001120.49
Phillips, Jack, R,259952443.350.000.002443.350.00
Hughes, Luis,130841798.960.000.000.001798.96
Moore, Jennifer, A,2175964.470.000.000.0064.47
Kelly, Bryan,213492989.380.000.002989.380.00
Evans, Kaylee,19642133.540.000.000.00133.54
Barnes, Blake, A,178651789.970.000.000.001789.97
Adams, Julia, N,2607359.980.000.000.0059.98
Gonzales, Ashley, C,1860051.970.000.000.0051.97
Nath, Kenneth, W,170372334.970.000.000.002334.97
Cooper, Christina, C,265121000.440.000.001000.440.00
Ross, Aaron, N,118882376.960.000.000.002376.96
Hughes, Stephanie,263161000.440.000.001000.440.00
Gomez, Rebekah,13486225.440.000.000.00225.44
Foster, Paige,2742894.480.000.000.0094.48
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Sanchez, Shelby,16021539.990.000.000.00539.99
James, Morgan, E,2324539.980.000.000.0039.98
Russell, Chloe, M,12763589.960.000.000.00589.96
Gonzales, Jordan,2368113.980.000.000.0013.98
Gonzales, Gavin,2448813.980.000.000.0013.98
Thomas, Samantha,2169093.970.000.000.0093.97
Tang, Carl,2123832.270.000.000.0032.27
Diaz, Gabrielle,14893839.480.000.000.00839.48
Parker, James,11808610.190.000.000.00610.19
Carter, Jonathan,14578848.470.000.000.00848.47
Smith, Lucas, P,1809064.910.000.000.0064.91
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Gonzales, Luis,15856116.250.000.0037.2778.98
Reed, Kaylee, R,17371151.920.000.000.00151.92
Campbell, Hunter,17422174.920.000.000.00174.92
Bryant, Isabelle,233974828.110.003578.270.001249.84
Brooks, Steven, C,14877889.470.000.000.00889.47
Sanchez, Grace,120802354.990.000.000.002354.99
Bailey, Marcus, L,18329146.530.000.0023.78122.75
Moreno, Meredith, D,2228589.970.000.000.0089.97
Collins, Luis, J,227655978.610.003578.270.002400.34
Clark, William,2902169.990.000.000.0069.99
Long, Rachel,2828339.980.000.000.0039.98
Collins, Xavier, C,16646250.910.000.000.00250.91
Jackson, Brianna,1537797.910.000.000.0097.91
Patterson, Abigail, H,144784795.010.000.000.004795.01
Bryant, Gabriel,2765669.990.000.000.0069.99
Butler, Jonathan,261804.990.000.000.004.99
Cooper, Ariana,17348205.420.000.000.00205.42
Carter, Isaac,137191129.480.000.000.001129.48
Griffin, Melissa, L,287807.950.000.000.007.95
Washington, Vanessa,238194802.110.003578.270.001223.84
Chow, Candice,1923260.960.000.000.0060.96
Luo, Franklin, J,2202759.980.000.000.0059.98
Jenkins, Samantha,113311290.330.000.0013.981276.35
Brooks, Makayla,222526047.320.003578.270.002469.05
Torres, Mackenzie,28153570.470.000.000.00570.47
Roberts, Robert, R,1898656.970.000.000.0056.97
Peterson, Isabella,2808039.980.000.000.0039.98
Wilson, Andrew, R,182362414.990.000.000.002414.99
Flores, Stephanie,259922721.550.000.002181.56539.99
Stewart, Amanda, M,1531094.440.000.000.0094.44
Long, Jordan,199884555.470.003399.990.001155.48
Wright, Robert, C,158894848.030.000.000.004848.03
Coleman, Ian,2127639.980.000.000.0039.98
Harris, Megan,232814828.110.003578.270.001249.84
Sanchez, Allison,1666741.720.000.000.0041.72
Ortega, Sheila, M,2763239.980.000.000.0039.98
Thompson, Lucas, O,212774.990.000.000.004.99
Powell, Jack, J,1841156.960.000.000.0056.96
Ward, Destiny,16128539.990.000.000.00539.99
Yang, Aaron, C,2519654.980.000.000.0054.98
Jackson, Charles, P,112771305.660.000.0034.991270.67
Srini, Evelyn,16855150.950.000.000.00150.95
Thomas, Wyatt, R,12431154.540.000.000.00154.54
Green, Gabrielle, M,2181564.470.000.000.0064.47
Collins, Eduardo,139872329.990.000.000.002329.99
Bailey, Hailey, R,262704.990.000.000.004.99
James, Sara,198023374.993374.990.000.000.00
Butler, Ana,260403018.330.000.002443.35574.98
Perez, Barry, M,2728269.990.000.000.0069.99
Hill, Katherine, L,2670139.980.000.000.0039.98
Diaz, Jason,17374206.630.000.0089.46117.17
Lal, Robert, L,14084138.680.000.000.00138.68
Green, Marcus, C,15974208.410.000.000.00208.41
Ross, Elizabeth, E,141184741.340.000.000.004741.34
White, Jennifer, S,27027782.990.00782.990.000.00
Rivera, Allison, M,13751224.910.000.000.00224.91
Jones, Samantha,1831721.980.000.000.0021.98
Jones, Madison,246614181.760.003578.27603.490.00
Stewart, Sara,17347119.720.000.000.00119.72
Hall, Eduardo,16847189.940.000.000.00189.94
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Torres, Abigail,253674.990.000.000.004.99
Lazecky, Petr,258642443.350.000.002443.350.00
Walker, Hunter,271007.280.000.000.007.28
She, Martha, E,222515971.330.003578.270.002393.06
Gonzales, Emily, P,21777180.980.000.000.00180.98
Smith, Tyler, J,2034156.970.000.000.0056.97
Bailey, Lauren,15864103.550.000.000.00103.55
Bell, Gabrielle,223735976.320.003578.270.002398.05
Watson, Devin, A,18875114.950.000.000.00114.95
Watson, Richard,15943365.410.000.000.00365.41
Richardson, Brian,2860878.980.000.000.0078.98
Moore, Jessica, J,2008576.760.000.000.0076.76
Nelson, Katherine,2802178.980.000.000.0078.98
Ross, Anna, D,15494275.440.000.000.00275.44
Butler, Jackson, J,183241735.980.000.000.001735.98
Brooks, Mariah,216202620.400.000.002071.42548.98
Wu, Randy, J,116472365.940.000.000.002365.94
Turner, Mary,220154.990.000.000.004.99
Watson, Cole, A,217684118.263578.270.000.00539.99
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Hall, Lauren, A,19648100.840.000.000.00100.84
Lewis, Brianna, H,14282166.240.000.000.00166.24
Morgan, Isabella, L,28602144.470.000.000.00144.47
Henderson, Olivia,188591155.480.000.000.001155.48
Collins, Sierra,185491169.460.000.000.001169.46
Sanchez, Jeremiah, E,2226521.980.000.000.0021.98
Garcia, Alexandra, J,14107819.460.000.000.00819.46
Simmons, Dylan,16133107.850.000.0038.8868.97
Hill, Fernando,247634.990.000.000.004.99
Powell, Miranda, J,153044843.000.000.000.004843.00
Butler, Trevor,2741569.990.000.0069.990.00
Allen, Madeline,2924068.970.000.000.0068.97
Martin, Nicholas,233627.280.000.000.007.28
White, Emma, N,16090604.960.000.000.00604.96
Peterson, Christina,2897694.480.000.000.0094.48
Lal, Caleb, R,1586874.460.000.000.0074.46
Torres, Victoria,17551160.920.000.000.00160.92
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Chen, Ethan,2054756.970.000.000.0056.97
Edwards, Logan,250024.990.000.000.004.99
Adams, Miguel,11659213.520.000.000.00213.52
Perez, Savannah, J,17036176.950.000.000.00176.95
Simmons, Dakota, T,14110819.460.000.000.00819.46
Taylor, Ryan,170251709.980.000.000.001709.98
Barnes, Haley, J,2133939.980.000.0039.980.00
Roberts, Jordan, M,1680039.250.000.000.0039.25
Henderson, Ashley,111851381.370.000.000.001381.37
Allen, Amanda,2235339.980.000.000.0039.98
Alexander, Elijah,11738331.680.000.0049.48282.20
Brown, Anna,1624795.820.000.000.0095.82
Diaz, Angela, K,27259782.990.000.00782.990.00
Coleman, Jennifer, L,27298782.990.000.00782.990.00
Jenkins, Megan, R,12074261.380.000.000.00261.38
Hernandez, Sierra,27393123.980.000.000.00123.98
Wright, Kyle,2371626.970.000.000.0026.97
Rodriguez, Nicholas, D,14604137.950.000.0058.9778.98
Perry, Dalton, A,16149192.040.000.000.00192.04
King, Morgan,196811179.970.000.000.001179.97
Gonzales, Trevor, K,16085143.530.000.0014.98128.55
Lewis, Brandon, A,2903769.990.000.000.0069.99
Foster, Nicole, A,2349489.970.000.000.0089.97
Allen, Sean, L,12097159.220.000.000.00159.22
Russell, Caleb,23552103.480.000.000.00103.48
Kelly, Bailey, R,28284563.770.000.000.00563.77

Generated 2025-12-21 13:53:14.782 UTC