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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Gonzalez, Gabriella, Z,15872235.540.000.000.00235.54
Flores, Julian,158464943.320.000.000.004943.32
Walker, Jacob, N,29027574.980.000.000.00574.98
Patterson, Eduardo,11142866.810.000.00160.73706.08
Garcia, Anna, B,15572104.550.000.000.00104.55
Roberts, Mason, D,111761106.680.000.00608.60498.08
Price, Marissa,15826160.740.000.00120.4840.26
Hayes, Hannah, J,2165656.970.000.000.0056.97
Garcia, Christian, J,164913106.330.000.00751.342354.99
Campbell, Angel, D,195461174.480.000.000.001174.48
Patterson, Nicole,1972937.270.000.000.0037.27
Malhotra, Kristi, S,151754850.330.000.000.004850.33
Evans, Kaylee,19642133.540.000.0056.9776.57
Bryant, Isabelle,233974828.110.003578.270.001249.84
Powell, Ian,2608564.470.000.000.0064.47
Adams, Jennifer,153624745.020.000.000.004745.02
Perez, Dalton,110911125.360.000.00331.76793.60
Lewis, Jeremiah,1437187.260.000.0049.9737.29
Howard, Danielle,28357133.490.000.000.00133.49
Green, Samuel, D,14096174.730.000.000.00174.73
Barnes, Elizabeth, J,249397.280.000.000.007.28
Long, Sydney,279217.280.000.000.007.28
Baker, Sara, M,11827512.470.000.00148.47364.00
Gray, Mackenzie, L,1768056.970.000.000.0056.97
Washington, Ian, M,246644368.580.003578.270.00790.31
Stewart, Melissa,2517336.960.000.000.0036.96
Raje, Mindy, A,16083561.970.000.000.00561.97
James, Emma,127812329.980.000.000.002329.98
Powell, Jack, J,1841156.960.000.000.0056.96
Shan, Christian, L,2308439.980.000.000.0039.98
Richardson, Nathaniel,120894710.030.000.002316.972393.06
Torres, Victoria,17551160.920.000.000.00160.92
Smith, Andrew,1472387.570.000.0047.5839.99
Smith, Chloe,17619163.920.000.000.00163.92
Simmons, Anna, K,124512367.920.000.000.002367.92
Lal, Jonathan,2009671.460.000.000.0071.46
Hughes, Austin, P,183681754.980.000.000.001754.98
Lee, Ian,19646197.040.000.000.00197.04
Ross, Antonio,18322148.890.000.00118.4130.48
Martin, Jill, C,11824181.030.000.0069.97111.06
Allen, Madeline,2924068.970.000.000.0068.97
Ward, Lucas, N,183631700.990.000.000.001700.99
Gomez, Briana, A,2878443.980.000.000.0043.98
Morris, Haley, A,2354848.970.000.000.0048.97
Roberts, Amber, W,215822638.060.000.002638.060.00
Thomas, Richard,27557782.990.000.00782.990.00
Thomas, Thomas,216292624.080.000.002049.10574.98
Washington, Lauren, R,229985329.250.003578.271750.980.00
Anderson, Megan, A,238594153.250.003578.27574.980.00
Perry, Oscar,227856029.570.003578.272451.300.00
Griffin, Julian, M,113284718.040.000.004718.040.00
Davis, Richard, R,15549574.980.000.00574.980.00
Kelly, Bryan,213492989.380.000.002989.380.00
Navarro, Jerome, B,11519717.280.000.00186.18531.10
Ross, Kelly,2607676.960.000.000.0076.96
Lee, John,19801193.010.000.000.00193.01
Rogers, Jade, I,14332102.250.000.000.00102.25
Brown, Nicholas, S,11506675.640.000.00207.39468.25
Peterson, Jared,11502829.370.000.00376.87452.50
Perry, Justin, E,167583062.340.000.000.003062.34
Moore, Chloe, L,2626913.980.000.000.0013.98
Richardson, Evan, J,15488165.300.000.000.00165.30
Howard, Alexandra,207363194.580.000.002049.101145.48
Jenkins, Alexandra, D,11632924.610.000.00295.46629.15
Simmons, Dylan,16133107.850.000.0038.8868.97
Hughes, Morgan, T,11642392.890.000.0049.48343.41
Ramirez, Emma,29072128.970.000.000.00128.97
Campbell, Timothy,2584513.980.000.000.0013.98
Alexander, Angelica,2271471.950.000.000.0071.95
Washington, Miranda,152014793.020.000.000.004793.02
Foster, Caleb,27112114.460.000.000.00114.46
Thompson, Kayla, D,12363273.900.000.0049.97223.93
Powell, Jordyn, K,153914828.010.000.000.004828.01
Nelson, Jose,19217185.020.000.0091.9593.07
Luo, Donna, E,248054.990.000.000.004.99
She, Martha, E,222515971.330.003578.270.002393.06
Wright, Carol, C,12928247.410.000.0033.98213.43
Martin, Samuel,15874225.440.000.0069.99155.45
Anderson, Jasmine, A,235534.990.000.000.004.99
Martinez, Dominique,287888.990.000.008.990.00
Campbell, Hailey,15507267.840.000.00228.9638.88
Diaz, Jason,17374206.630.000.0089.46117.17
Adams, Gabriel, S,195271219.450.000.000.001219.45
Hernandez, José, M,11253696.610.000.00212.93483.68
Stewart, Cody, A,212843223.580.000.002049.101174.48
Martin, Gina, E,11078793.270.000.00262.33530.94
Williams, Joshua,260514.990.000.000.004.99
Miller, Joseph, A,227134148.190.003578.270.00569.92
Russell, Katherine,2877169.990.000.000.0069.99
Martin, Alfredo, P,2148039.980.000.000.0039.98
Kapoor, Preston,2143156.970.000.000.0056.97
Anderson, Ashley,206803219.580.000.002049.101170.48
Alexander, Elijah,11738331.680.000.00141.73189.95
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Bailey, Marcus, L,18329146.530.000.0023.78122.75
Stewart, Jessica,16097103.550.000.0046.5856.97
Flores, Caleb, S,12165280.640.000.00243.3737.27
Thomas, Jessica,1684894.480.000.0094.480.00
Martin, Madison, C,2049271.970.000.0071.970.00
Allen, Allison, A,1975737.270.000.000.0037.27
White, Greg, C,174032322.280.000.000.002322.28
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Lee, Emma,16948176.430.000.0056.97119.46
Edwards, Logan,250024.990.000.000.004.99
Butler, Victoria,132844767.530.000.002374.472393.06
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Miller, Eduardo,14561158.840.000.0049.97108.87
Coleman, Miguel, D,2740069.990.000.0069.990.00
Barnes, Haley, J,2133939.980.000.0039.980.00
Rogers, Shelby,11712127.800.000.0049.8777.93
Rodriguez, Nicholas, D,14604137.950.000.00137.950.00
Davis, Austin, E,133664749.040.000.000.004749.04
Baker, Ian, V,262002756.540.000.002181.56574.98
Blue, Paige,2170313.980.000.000.0013.98
Evans, Alexandra,2432268.490.000.000.0068.49
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Watson, Devin, A,18875114.950.000.000.00114.95
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Ross, Xavier, A,12202171.470.000.0092.2579.22
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Alexander, Jordan,2141259.980.000.0059.980.00
Russell, Rachel, C,2158124.270.000.0024.270.00
Moore, Logan,2634889.970.000.0089.970.00
King, Sara,2235439.980.000.000.0039.98
Ward, Natalie, J,132412325.960.000.000.002325.96
Adams, Kaitlyn, A,11869239.600.000.0037.27202.33
Ross, Natalie, J,12916261.220.000.0068.97192.25
Stewart, Lucas, J,2934198.970.000.000.0098.97
Alexander, Aidan,17387148.190.000.00148.190.00
Campbell, Chloe,11212760.930.000.00307.78453.15
Yang, Justin, S,153634719.040.000.000.004719.04
Simmons, Jennifer,112621010.560.000.00226.90783.66
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Simmons, Haley, T,262022749.320.000.002181.56567.76
Watson, Shelby, J,14911867.970.000.000.00867.97
Powell, Jasmine, A,11505846.770.000.00441.44405.33
Morris, Abigail, C,287762.290.000.000.002.29
Sanders, Sean,14341175.150.000.000.00175.15
Diaz, Luis, D,11203801.770.000.00317.50484.27
Bailey, Lauren,15864103.550.000.009.9993.56
Sandberg, Isaac,1335053.970.000.0039.9913.98
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Young, Sierra, J,11619634.840.000.00187.43447.41
Chandra, Brandy, P,11501603.530.000.00128.21475.32
Henderson, Gabrielle, B,186031205.470.000.001205.470.00
Brown, Anna,1624795.820.000.000.0095.82
Washington, Christian, R,2668639.980.000.000.0039.98
Russell, Richard,2763322.260.000.000.0022.26
Green, Marcus, C,15974208.410.000.0091.95116.46
Cannata, Gabrielle, C,217254.990.000.000.004.99
Chapman, Nancy, E,11276840.150.000.00156.71683.44
Rubio, Javier, E,1972664.240.000.0064.240.00
King, Morgan,196811179.970.000.000.001179.97
Diaz, Luke,12054402.530.000.00139.97262.56
Green, Gabrielle, M,2181564.470.000.0064.470.00
Taylor, Lucas, V,115232376.960.000.002376.960.00
Reed, Sean, L,145974803.310.000.000.004803.31
Campbell, Alex,119844730.320.000.004730.320.00
Russell, Jacqueline,18391100.960.000.00100.960.00
Gray, Sara,292472447.050.000.002447.050.00
Ramirez, Abigail, S,1585974.140.000.0024.2749.87
Anderson, Destiny,12895336.650.000.0037.27299.38
Thompson, Ryan, M,113301111.360.000.00198.94912.42
Anderson, David, A,2209761.960.000.0061.960.00
James, Jeremiah, S,11661287.700.000.00104.97182.73
Perez, Amber, D,13318214.260.000.00116.9197.35
Davis, James,11922275.500.000.0094.96180.54
Taylor, Taylor,159054899.020.000.000.004899.02
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Reed, Kaylee, R,17371151.920.000.000.00151.92
Murphy, Catherine, L,1650692.050.000.0030.9761.08
Jackson, Charles, P,112771305.660.000.00511.23794.43
Harris, Isabella,17119214.900.000.00214.900.00
Kelly, Erin, D,2351364.470.000.000.0064.47
Davis, Daniel,11711999.220.000.00100.46898.76
Adams, Katherine, M,235184.990.000.000.004.99
Young, Julia, J,274144.990.000.000.004.99
Wilson, Chloe, A,11640409.120.000.00199.43209.69
Smith, Katherine, J,13197105.190.000.0049.9755.22
Rodriguez, Taylor,1607166.960.000.000.0066.96
Perry, Ana,112151155.520.000.00496.36659.16
Turner, Morgan,11823178.470.000.000.00178.47
Wright, Robert, C,158894848.030.000.000.004848.03
Brooks, Evan,2340139.980.000.000.0039.98
Long, Brandon, M,16110650.470.000.000.00650.47
Johnson, Cameron, R,137201155.480.000.000.001155.48
Turner, Timothy, C,14641119.860.000.0049.9769.89
Flores, Emily,13206163.190.000.0069.9793.22
Patterson, Maria, G,1333094.950.000.0079.9714.98
Rubio, Ruben, D,1887186.960.000.0086.960.00
Allen, Amanda,2235339.980.000.000.0039.98
Hughes, Nathan, B,121134737.530.000.002294.992442.54
She, Kenneth,16096212.010.000.0080.96131.05
Flores, Isabelle, A,15526188.320.000.0096.0792.25
Richardson, Melissa, E,111322371.940.000.002371.940.00
Washington, Alexandra, E,15498256.520.000.00223.9232.60
Moore, Andrew, A,13944150.130.000.00107.8542.28
Reed, Paige,221126047.323578.270.002469.050.00
Parker, Morgan, S,1677236.960.000.0014.9821.98
Butler, Jonathan,261804.990.000.000.004.99
Walker, John, M,2858969.990.000.0069.990.00
Chen, Jack, E,17579151.430.000.000.00151.43
Lal, Luke, L,11019698.230.000.00156.20542.03
Wilson, Daniel, K,142814746.300.000.002325.962420.34
Lewis, Brianna, H,14282166.240.000.0074.9891.26
Rogers, Andrea, L,14328308.660.000.00155.23153.43
Parker, Blake,15008170.530.000.0074.9895.55
Price, Nicole, N,15815141.830.000.0056.9784.86
White, Abigail, T,15866145.820.000.0038.88106.94
Luo, Jodi,2921368.490.000.000.0068.49
Garcia, Patricia,11651226.430.000.00134.9591.48
Hall, Grace, A,201894.990.000.000.004.99
Thomas, Emily,2180339.980.000.000.0039.98
Anderson, Ryan, W,132712319.990.000.000.002319.99
Morgan, Timothy,14633242.500.000.0095.55146.95
Winston, Ethan, R,216222612.060.000.002049.10562.96
Moore, Matthew, W,13267109.950.000.0074.9834.97
James, Bryce,13466133.450.000.000.00133.45
Bryant, Samantha,18345115.470.000.000.00115.47
Russell, Oscar, A,12140118.170.000.000.00118.17
Prasad, Molly,243924329.610.003578.27751.340.00
Young, Courtney,176222374.980.000.000.002374.98
Lopez, Carlos,186171147.770.000.001147.770.00
Umeda, Masaki,16717233.810.000.0038.88194.93
Murphy, Caitlin, L,14910839.480.000.000.00839.48
Miller, Victoria,15816188.020.000.00118.0569.97
Cook, Megan, J,2029956.970.000.0056.970.00
Baker, Sean, T,247782858.490.002181.56676.930.00
Turner, Amanda, L,203183241.900.002071.420.001170.48
Bennett, Antonio, C,11631707.500.000.00266.33441.17
Anderson, Emma, A,185801170.480.000.001170.480.00
Ross, Anna, D,15494275.440.000.00149.97125.47
Sanchez, Adrian, L,13179190.170.000.0077.92112.25
Garcia, Henry, B,112871009.240.000.00283.45725.79
Carter, Sydney,12959203.920.000.000.00203.92
Nelson, Sean,11841307.970.000.000.00307.97
Gonzales, Luis,15856116.250.000.00116.250.00
Cooper, Brian, L,13760128.840.000.000.00128.84
Wright, Kyle,2371626.970.000.0026.970.00
Flores, Emma, P,15543180.940.000.0078.98101.96
Morris, Alyssa,28072548.980.000.000.00548.98
Ross, Elizabeth, E,141184741.340.000.002322.282419.06
Peterson, Jessica, M,11868247.010.000.0076.95170.06
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Coleman, Isabel, S,12530337.900.000.00193.95143.95
Collins, Hailey,11709325.890.000.0091.48234.41
Davis, Marcus, T,17337123.910.000.0086.9536.96
Rogers, Bryce,174022304.980.000.000.002304.98
Phillips, James, G,16846180.950.000.00180.950.00
Diaz, Kaitlyn, B,292304.990.000.004.990.00

Generated 2024-09-19 21:55:51.127 UTC