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

259 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Moore, Chloe, L,2626913.980.000.000.0013.98
Flores, Luke, L,247337.280.000.000.007.28
Washington, Hailey, S,2588559.980.000.000.0059.98
Thomas, Dalton,230097.280.000.000.007.28
Thompson, Madison, L,187882351.960.000.000.002351.96
Flores, Miguel,1975077.250.000.000.0077.25
Wood, Brittany,2877753.990.000.000.0053.99
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Collins, Isaac,260777.280.000.000.007.28
Lewis, Ethan,27998144.470.000.000.00144.47
Anderson, Madison, G,2835978.980.000.000.0078.98
Long, Sarah,173721729.970.000.000.001729.97
Chandra, Allen,2932753.990.000.000.0053.99
Lal, Jack, R,185251735.980.000.000.001735.98
Mitchell, Bailey, B,267067.280.000.007.280.00
Chen, Jack, E,17579151.430.000.000.00151.43
Reed, Isaac, D,260747.280.000.000.007.28
Butler, Jonathan,261804.990.000.000.004.99
Carter, Jesse, E,22141166.280.000.000.00166.28
Anderson, Ryan, W,132712319.990.000.000.002319.99
Henderson, Hailey, C,171481775.470.000.000.001775.47
Shan, Gabriel, T,2773169.990.000.000.0069.99
Cannata, Gabrielle, C,217254.990.000.000.004.99
Foster, Alyssa, I,14875839.480.000.000.00839.48
Coleman, Samuel, N,17450123.980.000.000.00123.98
Alvarez, Melody,2507068.490.000.000.0068.49
Russell, Caleb,23552103.480.000.000.00103.48
Scott, Mason,2355139.980.000.000.0039.98
Edwards, Hailey,242584.990.000.000.004.99
Brown, Christian,227554.990.000.000.004.99
Anderson, Tyler, E,131481137.430.000.001137.430.00
Ward, Destiny,16128539.990.000.000.00539.99
Smith, Hannah, J,2526554.980.000.0054.980.00
Zhang, Connor, R,138532329.980.000.000.002329.98
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Perez, Jonathan, R,2345512.940.000.000.0012.94
Gonzales, Jordan,2368113.980.000.000.0013.98
Gray, Sebastian, B,138782366.960.000.000.002366.96
Phillips, Haley, B,2807939.980.000.000.0039.98
Johnson, Madison, L,15530846.460.000.000.00846.46
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Srini, Evelyn,16855150.950.000.000.00150.95
Bailey, Maria, C,1915034.980.000.000.0034.98
Reed, Morgan, E,2877923.970.000.000.0023.97
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Carter, Jose, H,12532235.720.000.000.00235.72
Alexander, Gavin, K,2932249.990.000.000.0049.99
Morris, Haley, A,2354848.970.000.000.0048.97
Griffin, James,28189567.760.000.000.00567.76
Flores, Brandon, L,2562189.970.000.000.0089.97
Collins, Charles, B,29041628.450.000.000.00628.45
Kapoor, Preston,2143156.970.000.000.0056.97
Hayes, Jason,261764.990.000.000.004.99
Malhotra, Brenda,133912405.470.000.000.002405.47
Nath, Yolanda, A,2462513.980.000.000.0013.98
Robinson, Madison, W,183772394.970.000.000.002394.97
Perez, Barry, M,2728269.990.000.000.0069.99
Rogers, Paige, H,17125539.990.000.000.00539.99
Perez, Katherine, J,2207924.270.000.000.0024.27
Kelly, Erin, D,2351364.470.000.000.0064.47
Torres, Abigail,253674.990.000.000.004.99
Li, Eugene, A,15283865.950.000.000.00865.95
Coleman, Ian,2127639.980.000.000.0039.98
Butler, Isabel,16241126.960.000.0056.9769.99
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Brooks, Isaac, M,233854829.390.003578.270.001251.12
Hughes, Justin, M,181222439.990.000.000.002439.99
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Harris, Megan,232814828.110.003578.271249.840.00
Hernandez, Haley, L,11769478.950.000.0078.98399.97
Jackson, Joseph, R,235925279.260.003578.270.001700.99
Rodriguez, Anthony, G,238294802.110.003578.270.001223.84
Alexander, Ashley, J,200074495.480.003374.990.001120.49
White, Cameron,238304802.110.003578.270.001223.84
Washington, Vanessa,238194802.110.003578.270.001223.84
Rodriguez, Morgan,237304828.110.003578.270.001249.84
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Thomas, Emily,2180339.980.000.000.0039.98
Foster, Olivia,238063578.270.003578.270.000.00
Thompson, Abigail,243324816.090.003578.270.001237.82
Chander, Wayne, S,243444329.610.003578.27751.340.00
Chen, Jackson, S,270751371.950.00782.990.00588.96
Edwards, Connor,16950211.010.000.0023.97187.04
He, Micah,2740169.990.000.0069.990.00
Johnson, Anthony, D,270224.990.000.004.990.00
Martin, Brandon, S,2169139.980.000.0039.980.00
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Ross, Elizabeth, E,141184741.340.000.002322.282419.06
Jai, Kevin,1983678.960.000.0038.9839.98
She, Alisha, G,247574343.590.003578.270.00765.32
Jones, Joshua,184012294.990.000.000.002294.99
Baker, Sean, T,247782858.490.002181.56676.930.00
Cooper, Stephanie,249762181.560.002181.560.000.00
Peterson, Alex, M,13423132.900.000.000.00132.90
Thomas, Charles,250942443.350.002443.350.000.00
Griffin, Madison, A,250932181.560.002181.560.000.00
Li, Kevin, S,2518813.980.000.0013.980.00
Russell, Megan,16220562.960.000.000.00562.96
Hughes, Julia,250612443.350.002443.350.000.00
Jai, Adam,250952443.350.002443.350.000.00
Ross, Haley, T,253612443.350.002443.350.000.00
Long, Chloe,167841735.980.000.001735.980.00
Price, Stephanie,258922443.350.002443.350.000.00
Hughes, Brittany,14387898.460.000.00898.460.00
Carter, Luis, E,258832443.350.002443.350.000.00
Cook, Steven, J,27053782.990.00782.990.000.00
Martin, Jill, C,11824181.030.000.0069.97111.06
Russell, Fernando,27084782.990.00782.990.000.00
Blanco, Randall,263211554.410.001000.440.00553.97
Hall, Lauren, A,19648100.840.000.0036.5964.25
Diaz, Thomas, O,16020595.960.000.00595.960.00
Lewis, Brandon, A,2903769.990.000.0069.990.00
Ramirez, Makayla, L,1750998.720.000.0037.2761.45
Griffin, Jack, L,1768632.280.000.0032.280.00
Alexander, Nathan, A,187951198.970.000.001198.970.00
Adams, Miguel,11659213.520.000.0064.97148.55
Brooks, Ian, W,2829064.470.000.000.0064.47
Wagner, Alexandra, E,2324439.980.000.000.0039.98
Peterson, Christina,2897694.480.000.000.0094.48
Washington, Victoria,235577.280.000.000.007.28
Barnes, Emily, G,15996564.990.000.000.00564.99
Collins, Nathan, F,197041143.460.000.000.001143.46
Coleman, Jose, S,253494.990.000.000.004.99
Smith, Tyler, J,2034156.970.000.000.0056.97
Rubio, Kellie,27653128.970.000.000.00128.97
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Lal, Caleb, R,1586874.460.000.000.0074.46
Richardson, Olivia,204683169.590.002049.100.001120.49
Griffin, Cassidy,264961000.440.000.001000.440.00
Wilson, Christian,27085782.990.000.00782.990.00
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Butler, Ana,260403018.330.000.002443.35574.98
Phillips, Kaylee,211384371.380.000.002049.102322.28
Washington, Taylor,212664525.070.000.002049.102475.97
Patterson, Alexis,213484392.020.000.002049.102342.92
Campbell, Adam, A,214002688.890.000.002071.42617.47
Jones, Zachary, J,27285782.990.000.00782.990.00
Coleman, Jennifer, L,27298782.990.000.00782.990.00
Miller, Kayla, A,236734.990.000.000.004.99
Bryant, Nathan,2145059.980.000.000.0059.98
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Cook, Seth,2301064.470.000.000.0064.47
Garcia, Jonathan,1888386.960.000.0029.9956.97
White, Nicole,16731155.910.000.0084.9670.95
Lee, Alexander, S,18356149.910.000.000.00149.91
Ramos, Derrick,18449100.940.000.0030.9769.97
Morris, Jessica,289678.990.000.008.990.00
Richardson, Arianna, C,1205534.980.000.0034.980.00
Foster, Emma,15468436.350.000.00159.99276.36
Alexander, Jason,2932849.990.000.000.0049.99
Rivera, Rachel, S,2899678.980.000.000.0078.98
Simmons, Adam,253274.990.000.000.004.99
James, Morgan, E,2324539.980.000.000.0039.98
Gonzalez, Logan, J,1748364.500.000.0032.2832.22
Evans, Connor, J,15402131.550.000.000.00131.55
Diaz, Brandon,236764.990.000.004.990.00
Evans, Jordan,2920939.980.000.0039.980.00
Thompson, Kayla, D,12363273.900.000.0049.97223.93
Walker, Richard, T,19640224.550.000.000.00224.55
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Garcia, Benjamin, L,175951785.970.000.000.001785.97
Young, Jenna, W,163652490.180.000.000.002490.18
James, Maria,1624391.970.000.0069.9921.98
Bryant, Rachel,220197.280.000.007.280.00
Li, Jordan,17026261.390.000.00261.390.00
Adams, Kyle, E,1881269.990.000.0069.990.00
Ramirez, Richard, C,282397.280.000.007.280.00
Richardson, Charles, I,121144719.020.000.002325.962393.06
Foster, Paige,2742894.480.000.000.0094.48
Ward, Emma, W,2179659.980.000.000.0059.98
Flores, Cassidy, L,233684.990.000.000.004.99
Garcia, Rachel, L,129864823.010.000.002369.972453.04
Davis, Dylan,15556588.960.000.00588.960.00
Gonzales, Cameron, L,2900569.990.000.0069.990.00
Hughes, Caroline, C,2830278.980.000.0078.980.00
Martinez, Carol, D,17656578.460.000.000.00578.46
Williams, Destiny, S,15881564.990.000.00564.990.00
Roberts, Wyatt,15900699.970.000.00699.970.00
Kumar, Elijah,15197156.920.000.000.00156.92
Murphy, Brianna, K,2834269.990.000.000.0069.99
King, Sara,2235439.980.000.000.0039.98
Jones, Samantha,1831721.980.000.000.0021.98
Alexander, Sarah,1941129.990.000.000.0029.99
Ward, Cole,214907.280.000.000.007.28
Collins, Amanda,2078339.980.000.000.0039.98
Ross, Kaitlyn,16121614.470.000.000.00614.47
Foster, Aaron,155664912.470.000.000.004912.47
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Griffin, Seth, R,17585164.460.000.0078.9885.48
Henderson, Abigail,2044139.980.000.000.0039.98
Sanders, Sean,14341175.150.000.000.00175.15
Nath, Alison, J,171161764.960.000.000.001764.96
Richardson, Lauren, C,14867839.480.000.000.00839.48
Johnson, Jacob, I,28069553.970.000.000.00553.97
Smith, Megan, J,2671668.970.000.000.0068.97
Baker, Robert, A,273007.280.000.007.280.00
Ross, Aaron, N,118882376.960.000.002376.960.00
Murphy, Maria,160113657.260.000.000.003657.26
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Robinson, Ian, D,138522294.990.000.000.002294.99
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Kumar, Cameron, S,185711120.490.000.001120.490.00
Martin, Joshua, A,276077.280.000.007.280.00
Price, Caroline,180511735.980.000.000.001735.98
Parker, Eduardo, M,12939169.420.000.00110.2059.22
Parker, Jeremy,2866878.980.000.0078.980.00
Watson, Erin, B,227724.990.000.004.990.00
Van, Bobby,27757132.970.000.00132.970.00
Long, Gavin,13762186.030.000.0036.59149.44
Srini, Ruben,18078200.940.000.0071.97128.97
Chen, Ethan,2054756.970.000.000.0056.97
Brown, Julia,18065155.470.000.000.00155.47
Roberts, Rebecca,2800094.480.000.000.0094.48
Johnson, Jonathan,220597.280.000.007.280.00
Collins, Jonathan,16849119.980.000.000.00119.98
Hall, Wyatt,2382713.980.000.000.0013.98
Nath, Carl, H,29001624.970.000.000.00624.97
Bell, Chase,180911750.980.000.000.001750.98
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Gutierrez, Neil, L,214897.280.000.000.007.28
Edwards, Elijah, D,281577.280.000.000.007.28
Brooks, Evan,2340139.980.000.000.0039.98
Jones, Alexandra, B,2020245.950.000.000.0045.95
Luo, Jodi,2921368.490.000.000.0068.49
Gonzalez, Molly,1637021.980.000.000.0021.98
Sara, Ivan, L,2509067.930.000.000.0067.93
Roberts, Noah, S,2704268.490.000.000.0068.49
Sanders, Mason, G,2345939.980.000.000.0039.98
Reed, Michelle,2804669.990.000.000.0069.99
Patterson, Austin, O,270247.280.000.000.007.28
Ward, Eduardo, I,139162354.980.000.000.002354.98
Perry, James,192051249.840.000.000.001249.84
Blanco, Armando, F,139182397.950.000.000.002397.95
Foster, Nicole, A,2349489.970.000.000.0089.97
Howard, Danielle,28357133.490.000.000.00133.49
Garcia, Xavier, M,2030071.970.000.000.0071.97
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Allen, Mason,176252431.950.000.000.002431.95
Butler, Jackson, J,183241735.980.000.000.001735.98
Hughes, Austin, P,183681754.980.000.000.001754.98
Ward, Lucas, N,183631700.990.000.000.001700.99
Li, Brandon,2933973.960.000.000.0073.96
Stewart, Makayla,16649115.940.000.000.00115.94
Russell, Nicole, M,182372318.960.000.000.002318.96
Chen, David,2720839.980.000.000.0039.98
Russell, Katherine,2877169.990.000.000.0069.99
Williams, Sydney, J,15334848.470.000.000.00848.47
Diaz, Gabrielle,14893839.480.000.000.00839.48
Davis, Jonathan,2925913.980.000.000.0013.98
Patterson, Cassidy, A,175861750.980.000.000.001750.98
Gray, Marcus, T,183892401.450.000.000.002401.45
Henderson, Austin,2764354.980.000.000.0054.98
Jackson, Andrew,2047985.480.000.000.0085.48
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Lee, Samantha, B,2737878.980.000.000.0078.98
Morgan, Isabella, L,28602144.470.000.000.00144.47
James, Julia,2497567.930.000.000.0067.93
_SUM1806517.5081404.32496236.54389766.13839110.51

Generated 2024-09-21 02:30:14.253 UTC