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

248 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
Bell, Alexandria, A,13758284.130.000.0042.28241.85
Hall, Elizabeth, L,13474339.480.000.000.00339.48
Perry, Natalie,1712669.990.000.000.0069.99
Lewis, Brandon, A,2903769.990.000.000.0069.99
Simmons, Jennifer,112621010.560.000.00207.93802.63
Green, Chloe, J,1465892.820.000.000.0092.82
Bennett, Antonio, C,11631707.500.000.00216.34491.16
Price, Isabelle,201825749.970.003374.990.002374.98
Jackson, Charles, P,112771305.660.000.00237.821067.84
Roberts, Mason, D,111761106.680.000.00494.64612.04
Simmons, Brittany,2923139.980.000.000.0039.98
Perez, Dalton,110911125.360.000.00213.86911.50
Adams, Miguel,11659213.520.000.000.00213.52
Rivera, Rachel, S,2899678.980.000.000.0078.98
Diaz, Richard, A,2668264.470.000.000.0064.47
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Reed, Bryan,18884133.930.000.000.00133.93
Sanders, Hailey,19647282.040.000.000.00282.04
Hill, Carlos,12919257.880.000.00158.9398.95
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Williams, Morgan, C,203733226.900.000.002071.421155.48
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Gonzales, Brittany,217104187.233578.270.000.00608.96
Luo, Franklin, J,2202759.980.000.000.0059.98
Powell, Jasmine, A,11505846.770.000.00105.05741.72
Wilson, Fernando,16643126.960.000.000.00126.96
Wagner, Alexandra, E,2324439.980.000.000.0039.98
Green, Samuel, D,14096174.730.000.000.00174.73
Simmons, Sarah, V,11500651.980.000.00118.96533.02
Powell, Spencer,14904468.120.000.000.00468.12
Long, Sydney,279217.280.000.000.007.28
Wilson, Madison, H,1982821.980.000.000.0021.98
Baker, Sara, M,11827512.470.000.00148.47364.00
Washington, Ian, M,246644368.580.003578.270.00790.31
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Harris, Matthew,14330806.760.000.000.00806.76
Young, Savannah,259712749.320.002181.560.00567.76
Taylor, Christian,2076456.760.000.000.0056.76
Thompson, Kaitlyn, L,12430223.930.000.000.00223.93
Rubio, Kellie,27653128.970.000.000.00128.97
Russell, Elijah, M,118354772.300.000.002319.262453.04
Lal, Caleb, R,1586874.460.000.000.0074.46
Gonzales, Melissa, W,204704408.690.000.002071.422337.27
Foster, Antonio,12795108.540.000.0066.2642.28
Rubio, Jaime, R,15007209.830.000.0049.97159.86
White, Nicole,16731155.910.000.0084.9670.95
Henderson, Eduardo, R,14359256.240.000.0078.98177.26
Sanchez, Adrian, L,13179190.170.000.000.00190.17
Gray, Isabella,168203217.790.000.000.003217.79
Diaz, Elijah,200004495.480.003374.990.001120.49
Torres, Victoria,17551160.920.000.000.00160.92
Hill, Timothy,14871848.470.000.000.00848.47
Murphy, Chase, J,2472958.980.000.000.0058.98
Campbell, Adam, A,214002688.890.000.002071.42617.47
Zhang, Robert,188551155.480.000.000.001155.48
Navarro, Jerome, B,11519717.280.000.0022.18695.10
Moore, Hunter,14897196.270.000.0071.58124.69
Robinson, Dylan, L,1472481.530.000.000.0081.53
Brooks, Lucas, S,16089342.030.000.000.00342.03
Smith, Lucas, P,1809064.910.000.000.0064.91
Martin, Samuel,15874225.440.000.0069.99155.45
Watson, Richard,15943365.410.000.00154.98210.43
Carter, Jesse, E,22141166.280.000.000.00166.28
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Ramirez, Ian,166783162.310.000.00742.352419.96
Garcia, Benjamin, L,175951785.970.000.000.001785.97
Barnes, Alexandra, P,222686031.310.003578.270.002453.04
Wilson, Jeremy, T,28341128.970.000.000.00128.97
Anand, Brendan, L,1984721.980.000.000.0021.98
Stewart, Allison, R,18826166.430.000.0069.9996.44
Shan, Chad, M,2462112.940.000.000.0012.94
Butler, Dalton, A,133454759.510.000.000.004759.51
Stewart, Alex, M,2008463.150.000.000.0063.15
She, Shawn, J,16902141.980.000.000.00141.98
Yuan, Leonard, F,167911729.970.000.000.001729.97
Coleman, Spencer,15993597.260.000.000.00597.26
Torres, Xavier,16840176.950.000.000.00176.95
Richardson, Olivia,204683169.590.000.002049.101120.49
Bell, Eduardo,27101782.990.000.00782.990.00
Anderson, Ashley,206803219.580.000.002049.101170.48
Diaz, Hunter, S,27242782.990.000.00782.990.00
Thompson, Joshua, F,259992181.560.000.002181.560.00
Howard, Alexandra,207363194.580.000.002049.101145.48
Phillips, Kaylee,211384371.380.000.002049.102322.28
Rivera, Caitlin, L,261132730.540.000.002181.56548.98
Mitchell, Savannah,261153052.800.000.002443.35609.45
Foster, Deb,215012661.400.000.002661.400.00
Patterson, Alexis,213484392.020.000.002049.102342.92
Simmons, Haley, T,262022749.320.000.002181.56567.76
Bailey, Morgan, E,213542646.400.000.002071.42574.98
Jones, Zachary, J,27285782.990.000.00782.990.00
Collins, Connor, J,27270782.990.000.00782.990.00
Mitchell, Maria, D,27404782.990.000.00782.990.00
Bradley, Jocelyn,230227.280.000.000.007.28
Price, Devin, M,18758158.510.000.0073.5584.96
Hu, Gilbert, L,2876769.990.000.000.0069.99
Lal, Kyle,17360122.180.000.000.00122.18
King, Gabrielle,263504.990.000.000.004.99
Murphy, Maria,160113657.260.000.000.003657.26
Howard, Natalie,1349154.960.000.0014.9839.98
Kennedy, Bridget,2202639.980.000.000.0039.98
Perez, Amber, D,13318214.260.000.00116.9197.35
Rodriguez, Alexis, L,15244179.190.000.0042.28136.91
Turner, James, E,16841126.960.000.0069.9956.97
Davis, James,11922275.500.000.0034.98240.52
Martinez, Jonathan,1330366.250.000.000.0066.25
Watson, Devin, A,18875114.950.000.000.00114.95
Robinson, Emily,12183228.420.000.0054.96173.46
Scott, Allison,14497804.480.000.000.00804.48
Hughes, Nathan, B,121134737.530.000.002294.992442.54
Phillips, Aaron, R,2494739.980.000.000.0039.98
Powell, Miranda, J,153044843.000.000.000.004843.00
Chen, Ethan,2054756.970.000.000.0056.97
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Brown, Julia,18065155.470.000.000.00155.47
Brooks, Steven, C,14877889.470.000.000.00889.47
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Flores, Miguel,1975077.250.000.000.0077.25
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Sanders, Sean,14341175.150.000.000.00175.15
Jai, Luis, A,18320185.920.000.000.00185.92
Lewis, Ethan,27998144.470.000.000.00144.47
Hernandez, José, M,11253696.610.000.0098.97597.64
Davis, Marcus, T,17337123.910.000.0086.9536.96
Ramos, Kristi,151764703.030.000.000.004703.03
Collins, Luis, J,227655978.610.003578.270.002400.34
Long, Sarah,173721729.970.000.000.001729.97
Brown, Jonathan,11875265.420.000.000.00265.42
Griffin, Miguel,2146476.970.000.000.0076.97
Chen, Jonathan, G,13096200.690.000.000.00200.69
Gray, Cody, C,144594775.010.000.000.004775.01
Winston, Ethan, R,216222612.060.000.002049.10562.96
Jenkins, Samantha,113311290.330.000.00410.31880.02
Young, Courtney,176222374.980.000.000.002374.98
Ross, Alexia, S,13231247.900.000.000.00247.90
Jackson, Brianna,1537797.910.000.0074.9822.93
Flores, Stephanie,259922721.550.000.002181.56539.99
Harris, Jeremiah, B,170231735.980.000.000.001735.98
Barnes, Fernando,113001390.550.000.00248.381142.17
Wang, Benjamin, R,274547.280.000.000.007.28
Gray, Seth, M,2008785.480.000.000.0085.48
Thompson, Madison, L,187882351.960.000.000.002351.96
Alexander, Sarah,1941129.990.000.000.0029.99
Garcia, Henry, B,112871009.240.000.00219.26789.98
Griffin, Marcus,2075634.560.000.000.0034.56
Lee, Ian,19646197.040.000.000.00197.04
Blue, Melanie, L,178611749.960.000.000.001749.96
Wood, Brittany,2877753.990.000.000.0053.99
Russell, Samantha,11211723.560.000.00118.46605.10
Rivera, Amanda,11131115.920.000.000.00115.92
Foster, Alyssa, I,14875839.480.000.000.00839.48
White, Miguel, S,13988195.520.000.000.00195.52
Rivera, Allison, M,13751224.910.000.000.00224.91
Alvarez, Melody,2507068.490.000.000.0068.49
Stewart, Sara,17347119.720.000.000.00119.72
Sanders, Mason, G,2345939.980.000.000.0039.98
Edwards, Alexandra,133582386.940.000.000.002386.94
Martin, Xavier,222335997.330.003578.270.002419.06
Howard, Isaiah,259813018.330.002443.350.00574.98
Thompson, Ryan, M,113301111.360.000.00198.94912.42
Bennett, Brittany, J,2233239.980.000.000.0039.98
Bailey, Richard, N,220504160.533578.270.000.00582.26
Bryant, Isabelle,233974828.110.003578.270.001249.84
Brooks, Paige,222325985.310.003578.270.002407.04
Hayes, Gavin, A,194001179.470.000.000.001179.47
Roberts, Jordan, M,1680039.250.000.000.0039.25
Reed, Melanie, A,28160574.980.000.000.00574.98
Carter, Katherine,11861286.300.000.000.00286.30
Adams, Julia, N,2607359.980.000.000.0059.98
Jones, Dalton, T,189512334.970.000.000.002334.97
Morgan, Jada, A,11520702.990.000.00137.45565.54
Sanz, Lori, L,238654891.610.003578.270.001313.34
Russell, Isabella, A,11507645.780.000.0028.48617.30
Rogers, Jared, J,12166162.220.000.000.00162.22
Hill, Blake,11748131.540.000.000.00131.54
Srini, Ruben,18078200.940.000.0071.97128.97
Edwards, Hunter,2422067.930.000.000.0067.93
Roberts, Amber, W,215822638.060.000.002049.10588.96
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
King, Jordan, C,110202316.970.000.002316.970.00
Cooper, Brooke,195361120.490.000.000.001120.49
Powell, Jack, J,1841156.960.000.000.0056.96
Turner, Jose,11784272.690.000.000.00272.69
Foster, Jose, C,2878534.990.000.000.0034.99
Rogers, Carlos,19645134.440.000.000.00134.44
Rivera, Sara,187852350.960.000.000.002350.96
Barnes, Blake, A,178651789.970.000.000.001789.97
Peterson, Brian,12892419.470.000.00156.27263.20
Reed, Megan, A,181181750.980.000.000.001750.98
Sun, Arturo, C,11498557.540.000.00151.90405.64
Smith, Austin,13707149.050.000.000.00149.05
Howard, Erin, L,183621725.210.000.000.001725.21
Foster, Isabelle,2637739.980.000.000.0039.98
Turner, Eduardo,158764789.020.000.000.004789.02
Zukowski, Jake,220584118.263578.270.000.00539.99
Bailey, Maria, C,1915034.980.000.000.0034.98
Stewart, Marcus, R,2063221.980.000.000.0021.98
Garcia, Xavier, M,2030071.970.000.000.0071.97
Bennett, Jordyn, L,222304223.230.003578.270.00644.96
Chandra, Brandy, P,11501603.530.000.0098.23505.30
Garcia, Isabella,18382204.940.000.000.00204.94
Allen, Mason,176252431.950.000.000.002431.95
Simmons, Adam,253274.990.000.000.004.99
Young, Kaylee, S,13756298.490.000.0058.47240.02
Cooper, Grace, C,1601294.260.000.000.0094.26
Evans, Connor, J,15402131.550.000.000.00131.55
King, Aaron, L,117394758.030.000.002359.982398.05
Martinez, Dominique,287888.990.000.008.990.00
James, Christina,17409219.920.000.000.00219.92
Russell, Nicole, M,182372318.960.000.000.002318.96
Hayes, Austin,202083219.580.002049.100.001170.48
Walker, Brandon, J,159164793.270.000.000.004793.27
Davis, Nicholas,1320173.160.000.000.0073.16
Thompson, Kayla, D,12363273.900.000.000.00273.90
Kelly, Angel, E,15418232.230.000.000.00232.23
Diaz, Faith, M,2236356.970.000.000.0056.97
Sanchez, Shelby,16021539.990.000.000.00539.99
Diaz, Luke,12054402.530.000.00139.97262.56
Phillips, Andrea,1857383.740.000.000.0083.74
Reed, Sean, L,145974803.310.000.000.004803.31
Adams, Gabriel, S,195271219.450.000.000.001219.45
Bradley, Nathaniel,169551760.470.000.000.001760.47
Gonzales, Paige,2170291.940.000.0039.9851.96
Martinez, Jill,242354829.390.003578.270.001251.12
Martinez, Matthew, L,16009170.450.000.000.00170.45
Martin, James, M,1987077.250.000.000.0077.25
Ross, Natalie, J,12916261.220.000.000.00261.22
Thompson, Devin,207084406.400.000.002071.422334.98
Foster, Aaron,155664912.470.000.000.004912.47
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Jones, Natalie, A,11845197.200.000.0082.26114.94
Hayes, Brittany,13941286.820.000.000.00286.82
Bryant, Isabella, L,229956060.500.003578.270.002482.23
Washington, Emma,191231170.480.000.000.001170.48
James, Richard, D,15760109.230.000.003.99105.24
Martin, Christian, V,19709197.250.000.000.00197.25
Sharma, Kathryn,20740140.940.000.000.00140.94
Butler, Victoria,132844767.530.000.000.004767.53
Murphy, Catherine, L,1650692.050.000.000.0092.05
Russell, Xavier,12964119.950.000.000.00119.95
Brown, Nicholas, S,11506675.640.000.00121.93553.71
Rowe, Todd,14586233.940.000.000.00233.94
Perry, Christian,246714354.600.003578.270.00776.33
Campbell, Evan, W,243424828.110.003578.270.001249.84
Lewis, Zachary, L,14760167.260.000.000.00167.26
Garcia, Anna, B,15572104.550.000.000.00104.55

Generated 2025-11-03 01:48:29.617 UTC