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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Garcia, Carmen, J,247812181.560.002181.560.000.00
Chapman, Nancy, E,11276840.150.000.0066.26773.89
Rodriguez, Taylor,1607166.960.000.000.0066.96
Rodriguez, Nicholas, D,14604137.950.000.0058.9778.98
Wood, Alexandria, M,248242181.560.002181.560.000.00
Lewis, Jeremiah,1437187.260.000.0049.9737.29
Flores, Nathan, C,2463713.980.000.000.0013.98
Collins, Nathan, F,197041143.460.000.000.001143.46
Adams, Haley, M,247862443.350.002443.350.000.00
Bell, Alexandria, A,13758284.130.000.0042.28241.85
Bradley, Alexandria,176911779.470.000.000.001779.47
Adams, Mackenzie, A,14640812.420.000.000.00812.42
Richardson, Victoria, C,248172181.560.002181.560.000.00
Turner, Jose,11784272.690.000.000.00272.69
Scott, Allison,14497804.480.000.000.00804.48
Smith, Tyler, J,2034156.970.000.000.0056.97
Jai, Adam,250952443.350.002443.350.000.00
Thomas, David,168363193.790.000.000.003193.79
Gonzales, Trevor, K,16085143.530.000.0014.98128.55
White, Miguel, S,13988195.520.000.000.00195.52
Huang, Kristen,251002443.350.002443.350.000.00
White, Abigail, T,15866145.820.000.0038.88106.94
Stewart, Olivia, B,1874923.780.000.000.0023.78
Hall, Luke, E,14745902.460.000.000.00902.46
White, Jennifer, S,27027782.990.00782.990.000.00
Hernandez, Eduardo, J,18919300.940.000.00300.940.00
Evans, Gabriel,2348789.970.000.000.0089.97
Wilson, Daniel, K,142814746.300.000.000.004746.30
Gray, Alexandria, E,253632443.350.002443.350.000.00
Brown, Fernando,1900191.950.000.0069.9721.98
Moore, Seth,138512331.950.000.000.002331.95
Alexander, Nathan, A,187951198.970.000.000.001198.97
Lazecky, Petr,258642443.350.002443.350.000.00
Torres, Erin,1218287.250.000.0037.2949.96
Rogers, Jade, I,14332102.250.000.000.00102.25
Griffin, Thomas, J,19015125.430.000.0094.4630.97
Price, Stephanie,258922443.350.002443.350.000.00
Gray, Mariah,222787.280.000.007.280.00
Gray, Isabella,168203217.790.000.000.003217.79
Ortega, Javier, P,127852294.990.000.000.002294.99
Carter, Luis, E,258832443.350.002443.350.000.00
Lee, William,13185149.840.000.0069.9779.87
Perry, Justin, E,167583062.340.000.000.003062.34
Clark, Lauren,170341750.980.000.000.001750.98
Cook, Steven, J,27053782.990.00782.990.000.00
Butler, Jackson, J,183241735.980.000.000.001735.98
Richardson, Evan, J,15488165.300.000.000.00165.30
Brown, Samantha, G,2514739.980.000.000.0039.98
Coleman, Lucas, A,27060782.990.000.00782.990.00
Martin, Jill, C,11824181.030.000.0069.97111.06
Jai, Hunter, M,28272111.950.000.000.00111.95
Morgan, Angela,24665109.970.000.000.00109.97
Sanders, Alexandra,259112181.560.000.002181.560.00
Griffin, Jennifer, B,14244154.960.000.000.00154.96
Clark, Joseph, D,153954780.020.000.000.004780.02
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Russell, Fernando,27084782.990.000.00782.990.00
Baker, Robert, A,273007.280.000.007.280.00
Price, Oscar, G,11833240.010.000.000.00240.01
Sharma, Yolanda, K,250483046.840.002443.350.00603.49
Hall, Jan, M,11740334.120.000.00235.1598.97
James, Juan,232674862.090.003578.271283.820.00
Carter, Jesse, E,22141166.280.000.000.00166.28
Green, Sophia, E,249772181.560.002181.560.000.00
Ward, Juan, H,215952649.560.000.002049.10600.46
Watson, Richard,15943365.410.000.000.00365.41
Wilson, Jeremy, T,28341128.970.000.000.00128.97
Thomas, Charles,250942443.350.002443.350.000.00
Roberts, Seth, H,11510258.150.000.0039.47218.68
Simmons, David, E,120172339.970.000.000.002339.97
Patterson, Eric, A,2738478.980.000.000.0078.98
Gray, Brianna,249603008.820.002443.350.00565.47
Jai, Edwin,169211754.980.000.000.001754.98
Torres, Dalton,235037.280.000.000.007.28
Prasad, Donald,15413318.920.000.00123.98194.94
Turner, Andrea, A,202093268.550.002049.100.001219.45
Carter, Madeline, A,2752269.990.000.000.0069.99
Gomez, Krista,12760273.180.000.000.00273.18
Perry, Eric,18314115.730.000.000.00115.73
Gomez, Renee, L,253712181.560.002181.560.000.00
Hughes, Miranda,266784.990.000.000.004.99
Howard, Alexandra,207363194.580.000.002049.101145.48
Flores, Gabriel,271117.280.000.000.007.28
Hughes, Stephanie,263161000.440.001000.440.000.00
Bell, Alex, M,167543118.600.000.00756.332362.27
Gonzales, Gavin,2448813.980.000.000.0013.98
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Harris, Edward,27062782.990.000.00782.990.00
Peterson, Christina,2897694.480.000.000.0094.48
Gray, Jesse,14626197.040.000.000.00197.04
Coleman, Luke, A,11723152.550.000.0069.9882.57
Gonzalez, James, M,188421155.480.000.000.001155.48
Barnes, Emily, G,15996564.990.000.000.00564.99
Collins, Xavier, C,16646250.910.000.000.00250.91
Brown, Dylan, J,124492351.960.000.000.002351.96
Flores, Eduardo, S,2896962.980.000.000.0062.98
Bell, Christina,2609939.980.000.000.0039.98
Campbell, Timothy,2584513.980.000.000.0013.98
Murphy, Maria,160113657.260.000.000.003657.26
Thomas, Logan, A,14091251.200.000.0053.99197.21
Walker, Brandon, J,159164793.270.000.000.004793.27
Carter, Jose, H,12532235.720.000.000.00235.72
Turner, Kaylee, M,16213154.540.000.000.00154.54
Price, Mariah, C,2074549.480.000.000.0049.48
Bryant, Gabriel,2765669.990.000.000.0069.99
Liu, Arturo,13222150.410.000.000.00150.41
Kennedy, Bridget,2202639.980.000.000.0039.98
Dominguez, Erika, C,21251191.270.000.000.00191.27
Bryant, Brittany,2254548.970.000.000.0048.97
James, Richard, D,15760109.230.000.000.00109.23
Flores, Kevin,15878225.920.000.0069.97155.95
Alexander, Taylor,17482146.940.000.0076.9769.97
Cooper, Alexandra,19541131.240.000.000.00131.24
Parker, Jeremy,2866878.980.000.000.0078.98
Griffin, Marcus,2075634.560.000.000.0034.56
Smith, Justin, P,1982721.980.000.000.0021.98
Russell, Elijah, M,118354772.300.000.002319.262453.04
Sanders, Chloe, C,231375314.250.003578.270.001735.98
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Barnes, Brittany, R,15340156.040.000.0074.4681.58
Phillips, Devin,18759112.060.000.000.00112.06
Bryant, Zachary,216552648.070.000.002049.10598.97
Hall, Taylor, J,169951735.980.000.000.001735.98
White, Edward, J,15847205.460.000.000.00205.46
Lal, Caleb, R,1586874.460.000.000.0074.46
Van, Bobby,27757132.970.000.000.00132.97
Jones, Michael, A,2210771.970.000.000.0071.97
Harris, Matthew,14330806.760.000.000.00806.76
Miller, Kayla, A,236734.990.000.000.004.99
Powell, Sydney, M,14886539.990.000.000.00539.99
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Flores, Madison,14416769.490.000.000.00769.49
Young, Adam,12984200.200.000.0037.29162.91
Thompson, Kayla, D,12363273.900.000.000.00273.90
Hughes, Jasmine,276284.990.000.000.004.99
Martinez, Kristina, S,2134529.930.000.000.0029.93
Williams, Joshua,260514.990.000.000.004.99
Bell, Julia,216522646.060.000.002646.060.00
Martin, John, A,144364776.010.000.000.004776.01
Reed, Mariah,263731565.910.000.001000.44565.47
Chen, David,2720839.980.000.000.0039.98
Winston, Ethan, R,216222612.060.000.002049.10562.96
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Harrison, Trevor, A,18055143.910.000.0036.96106.95
Kumar, Elijah,15197156.920.000.000.00156.92
Powell, David, W,266151000.440.000.001000.440.00
Lewis, Ethan,27998144.470.000.000.00144.47
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Anderson, Ashley,206803219.580.000.002049.101170.48
Parker, Jordan,216212616.860.000.002049.10567.76
Edwards, Elijah, D,281577.280.000.000.007.28
Kumar, Austin,204834400.060.000.002049.102350.96
Rivera, Allison, M,13751224.910.000.000.00224.91
Patterson, Grace, M,27560782.990.000.00782.990.00
Cooper, Brooke,195361120.490.000.000.001120.49
Hill, Sydney,264821000.440.000.001000.440.00
Gray, Jared, A,264494.990.000.000.004.99
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Henderson, Olivia,188591155.480.000.000.001155.48
Townsend, Jeremiah, I,265031000.440.000.001000.440.00
Coleman, Logan,1868691.950.000.000.0091.95
Wilson, Victoria, R,27536782.990.000.00782.990.00
Shan, Christian, L,2308439.980.000.000.0039.98
Cox, Julia, A,206703228.570.000.002049.101179.47
Clark, Destiny, L,28600119.980.000.000.00119.98
Blue, Marcus, L,27550782.990.000.00782.990.00
Smith, Chloe,17619163.920.000.000.00163.92
Washington, Taylor,212664525.070.000.002049.102475.97
Patterson, Maria, G,1333094.950.000.000.0094.95
Adams, Jennifer,153624745.020.000.000.004745.02
Nelson, Sierra,161322459.620.000.002459.620.00
Stewart, Cody, A,212843223.580.000.002049.101174.48
Sanders, Xavier,1672173.750.000.000.0073.75
Sanders, Sean,14341175.150.000.000.00175.15
Thomas, Seth,14567161.280.000.0096.0765.21
Collins, Connor, J,27270782.990.000.00782.990.00
Carter, Sydney,12959203.920.000.000.00203.92
Jai, Luis, A,18320185.920.000.000.00185.92
Walker, Richard, T,19640224.550.000.000.00224.55
Harris, Destiny, M,137102341.460.000.000.002341.46
Watson, Cole, A,217684118.263578.270.000.00539.99
Flores, Hannah,1952540.230.000.000.0040.23
Johnson, Cameron, R,137201155.480.000.000.001155.48
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
Richardson, Nathaniel,120894710.030.000.002316.972393.06
Harris, Joshua, L,2028095.940.000.0030.9764.97
Flores, Brittany,169062359.980.000.000.002359.98
James, Sara,198023374.993374.990.000.000.00
Garcia, Chloe, M,110372374.230.000.002374.230.00
Morgan, Andrea, M,16870149.040.000.00116.4432.60
Gonzales, Kayla,214947.280.000.000.007.28
Edwards, Eric,2462768.490.000.000.0068.49
Wilson, Emily,174002331.950.000.000.002331.95
Bradley, Evan,18506101.940.000.000.00101.94
Carter, Isaac,137191129.480.000.000.001129.48
Hall, Morgan,2172641.950.000.000.0041.95
Brooks, Evan,2340139.980.000.000.0039.98
Campbell, Lucas,2932953.990.000.000.0053.99
Prasad, Erick, E,28786127.950.000.000.00127.95
Long, Natalie,14363192.340.000.000.00192.34
Long, Sarah,173721729.970.000.000.001729.97
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
King, Gabrielle,263504.990.000.000.004.99
Martin, Lucas, L,221144183.233578.270.000.00604.96
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Young, Jenna, W,163652490.180.000.000.002490.18
Williams, Austin,2035432.220.000.000.0032.22
Flores, Zachary, H,233765314.250.003578.270.001735.98
Ross, Kelly,2607676.960.000.000.0076.96
Hall, Jose, J,17601225.420.000.00155.4569.97
Perry, Natalie,1712669.990.000.000.0069.99
Murphy, Emma,198445807.930.003374.990.002432.94
Gonzalez, Logan, J,1748364.500.000.000.0064.50
Nelson, Jose,19217185.020.000.0091.9593.07
Mitchell, Caleb, K,268064.990.000.000.004.99
Williams, Ryan, R,222475978.610.003578.270.002400.34
Powell, Katherine, C,14574177.600.000.000.00177.60
Foster, Alyssa, I,14875839.480.000.000.00839.48
Parker, Caleb, A,2631813.980.000.000.0013.98
Lopez, Eduardo, J,266401288.060.00699.100.00588.96
Mehta, Carmen, C,2743694.480.000.000.0094.48
Lee, Kayla, M,2078115.230.000.000.0015.23
Butler, Benjamin, C,189722369.970.000.000.002369.97
Sanchez, Alex, K,131014736.030.000.000.004736.03
Anand, Brendan, L,1984721.980.000.000.0021.98
Sanders, Mason, G,2345939.980.000.000.0039.98
Sanders, Isaiah,2587339.980.000.000.0039.98
Morris, Abigail, C,287762.290.000.000.002.29
Mitchell, Thomas, J,137112380.470.000.000.002380.47
Edwards, Alexandra,133582386.940.000.000.002386.94
Martin, Samuel,15874225.440.000.0069.99155.45
Smith, John,198555709.960.003399.990.002309.97
Moore, Wyatt, F,189712351.960.000.000.002351.96
Bradley, Nathaniel,169551760.470.000.000.001760.47
Howard, Brianna, D,246304.990.000.000.004.99
Campbell, Hunter,17422174.920.000.000.00174.92
Butler, Jonathan,261804.990.000.000.004.99
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Martin, Thomas, A,169521735.980.000.000.001735.98
Parker, Madeline, H,221826006.320.003578.270.002428.05
James, Bryce,13466133.450.000.000.00133.45
Griffin, Miguel,2146476.970.000.000.0076.97
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Rogers, Carlos,19645134.440.000.000.00134.44
Wedge, Andrew, T,120604811.540.000.002418.482393.06
Walker, Ian,16771104.550.000.0054.5849.97
Blue, Makayla,1900029.990.000.000.0029.99

Generated 2024-11-10 07:13:59.460 UTC