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

248 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
She, Alisha, G,247574343.590.003578.270.00765.32
Robinson, Madison, W,183772394.970.000.000.002394.97
Gonzales, Cameron, L,2900569.990.000.0069.990.00
Garcia, Victoria, V,245013578.270.003578.270.000.00
Perez, Barry, M,2728269.990.000.000.0069.99
Hughes, Caroline, C,2830278.980.000.0078.980.00
Garcia, Carmen, J,247812181.560.002181.560.000.00
Rogers, Paige, H,17125539.990.000.000.00539.99
Nelson, Henry,193941155.480.000.000.001155.48
Wood, Alexandria, M,248242181.560.002181.560.000.00
Ross, Elizabeth, E,141184741.340.000.002322.282419.06
Ward, Mariah, J,2158044.910.000.000.0044.91
Griffin, Melissa, L,287807.950.000.000.007.95
Adams, Haley, M,247862443.350.002443.350.000.00
Hughes, Isabella,2304851.460.000.0051.460.00
Thompson, Lucas, O,212774.990.000.000.004.99
Hall, Eduardo,16847189.940.000.000.00189.94
Martin, Morgan,248322181.560.002181.560.000.00
Kelly, Trinity,2609515.230.000.000.0015.23
Rogers, Olivia,12020804.470.000.000.00804.47
Williams, Destiny, S,15881564.990.000.00564.990.00
Sanders, Paige,252872983.340.002443.350.00539.99
Hayes, Carson, A,124472331.950.000.002331.950.00
Richardson, Charles, I,121144719.020.000.002325.962393.06
Richardson, Erin, R,1633188.850.000.0088.850.00
White, Jennifer, S,27027782.990.00782.990.000.00
Cox, Devin, C,134184768.050.000.002329.992438.06
Smith, Zachary, W,2378358.980.000.0058.980.00
Wilson, Andrew, R,182362414.990.000.000.002414.99
Lazecky, Petr,258642443.350.002443.350.000.00
Mitchell, Caleb, K,268064.990.000.000.004.99
Perez, Charles,266937.280.000.007.280.00
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Price, Stephanie,258922443.350.002443.350.000.00
Diaz, Richard, A,2668264.470.000.000.0064.47
Davis, Dylan,15556588.960.000.00588.960.00
Washington, Christian, R,2668639.980.000.000.0039.98
Price, Jocelyn, D,258752443.350.002443.350.000.00
Garcia, Christian, J,164913106.330.000.00751.342354.99
Garcia, Rachel, L,129864823.010.000.002369.972453.04
Hughes, Samantha,2721564.470.000.000.0064.47
Flores, Jordyn,252882721.550.002181.560.00539.99
Diaz, Alyssa,139084715.330.000.002294.992420.34
Johnson, Ian, E,2173283.470.000.000.0083.47
Bennett, Brittany, J,2233239.980.000.000.0039.98
Cook, Steven, J,27053782.990.00782.990.000.00
Ward, Emma, W,2179659.980.000.000.0059.98
Chen, Jonathan, G,13096200.690.000.000.00200.69
Andersen, Latoya, J,290578.990.000.000.008.99
Harris, Edward,27062782.990.00782.990.000.00
Long, Sydney,279217.280.000.000.007.28
Jones, Michael, A,2210771.970.000.000.0071.97
Sanchez, Jeremiah, E,2226521.980.000.0021.980.00
Ortega, Javier, P,127852294.990.000.000.002294.99
Wilson, Madison, H,1982821.980.000.000.0021.98
Gray, Seth, M,2008785.480.000.000.0085.48
Hernandez, Sierra,27393123.980.000.00123.980.00
Clark, Lauren,170341750.980.000.000.001750.98
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Wang, Karen, P,1955331.970.000.000.0031.97
Stewart, Allison, R,18826166.430.000.0069.9996.44
Sandberg, Nicole, M,12077144.690.000.0094.4650.23
Carter, Elijah,216182611.070.000.002611.070.00
Davis, Justin,2807412.940.000.000.0012.94
Simmons, Anna, K,124512367.920.000.000.002367.92
Brown, Samantha, G,2514739.980.000.000.0039.98
Thomas, Thomas,216292624.080.000.002049.10574.98
James, Julia,2497567.930.000.000.0067.93
White, Abigail, T,15866145.820.000.0038.88106.94
Morgan, Angela,24665109.970.000.000.00109.97
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Lewis, Brianna, H,14282166.240.000.0074.9891.26
Hernandez, Eduardo, J,18919300.940.000.00300.940.00
James, Christina,17409219.920.000.000.00219.92
Russell, Elijah, M,118354772.300.000.002319.262453.04
Deng, Wayne,2145336.960.000.0036.960.00
Bryant, Samantha,18345115.470.000.000.00115.47
Butler, Morgan, E,2050068.490.000.0068.490.00
Hall, Elizabeth, L,13474339.480.000.0068.97270.51
Peterson, Mason, A,185701174.480.000.001174.480.00
Jai, Kevin,1983678.960.000.0038.9839.98
Foster, Trevor, J,2896469.990.000.0069.990.00
Rogers, Jade, I,14332102.250.000.000.00102.25
Long, Xavier,112512318.960.000.000.002318.96
Johnson, Edward, H,23279124.990.000.000.00124.99
Dominguez, Erika, C,21251191.270.000.000.00191.27
Perry, Justin, E,167583062.340.000.000.003062.34
Nelson, Adam, B,27402128.970.000.000.00128.97
Kelly, Julia,2379867.930.000.0067.930.00
Luo, Franklin, J,2202759.980.000.000.0059.98
Simmons, Adam,253274.990.000.000.004.99
Hall, Jan, M,11740334.120.000.00235.1598.97
James, Morgan, E,2324539.980.000.000.0039.98
Wagner, Alexandra, E,2324439.980.000.000.0039.98
Gonzalez, Logan, J,1748364.500.000.0032.2832.22
Jai, Edwin,169211754.980.000.000.001754.98
Martin, Joshua, A,276077.280.000.007.280.00
Henderson, Abigail,2044139.980.000.000.0039.98
Torres, Dalton,235037.280.000.007.280.00
Wright, Carol, C,12928247.410.000.0033.98213.43
Diaz, Faith, M,2236356.970.000.000.0056.97
Ramirez, Ian,166783162.310.000.00742.352419.96
Torres, Mackenzie,28153570.470.000.000.00570.47
Henderson, Hailey, C,171481775.470.000.000.001775.47
Zhang, Nathan, L,2910478.980.000.000.0078.98
Nelson, Sierra,161322459.620.000.002459.620.00
Yang, Aaron, C,2519654.980.000.000.0054.98
Alexander, Ryan, J,14078839.480.000.00839.480.00
Alexander, Lauren,189502351.960.000.000.002351.96
Diaz, Hailey, W,116932294.990.000.002294.990.00
Smith, Nathan,217647.280.000.007.280.00
Peterson, Christina,2897694.480.000.000.0094.48
Lewis, Christopher,1875586.960.000.0086.960.00
Clark, Emily, R,120862294.990.000.000.002294.99
Martin, Nicholas,233627.280.000.000.007.28
Young, Kaylee, S,13756298.490.000.0058.47240.02
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Moreno, Marie,2773969.990.000.000.0069.99
Hughes, Antonio, P,15913712.270.000.00712.270.00
Thomas, Megan,2907169.990.000.000.0069.99
Sanchez, Katherine, S,24399132.940.000.00132.940.00
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Martin, James, M,1987077.250.000.0039.9837.27
Thompson, Tyler,2750269.990.000.0069.990.00
Simmons, Caleb, M,121934833.030.000.002394.972438.06
Martin, Madison, C,2049271.970.000.0071.970.00
Washington, Emma,191231170.480.000.000.001170.48
Coleman, Luke, A,11723152.550.000.0069.9882.57
Griffin, Haley, L,1892582.180.000.000.0082.18
Martin, John, A,144364776.010.000.000.004776.01
Allen, Sean, L,12097159.220.000.000.00159.22
Evans, Alexandra,2432268.490.000.000.0068.49
Watson, Devin, A,18875114.950.000.000.00114.95
Moore, Hunter,14897196.270.000.0071.58124.69
Brooks, Lucas, S,16089342.030.000.000.00342.03
Richardson, Nathaniel,120894710.030.000.002316.972393.06
Evans, Maria,22544127.280.000.00127.280.00
Ward, Natalie, J,132412325.960.000.000.002325.96
Hayes, Jeremiah, W,20086128.550.000.0056.9771.58
She, Shawn, J,16902141.980.000.000.00141.98
Coleman, Spencer,15993597.260.000.000.00597.26
Green, Mackenzie, C,280737.280.000.000.007.28
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Lewis, Ethan,27998144.470.000.000.00144.47
Rubio, Ruben, D,1887186.960.000.0086.960.00
Russell, Rachel, C,2158124.270.000.0024.270.00
Moore, Logan,2634889.970.000.0089.970.00
Hernandez, Jamie,27283119.980.000.00119.980.00
Phillips, Isaiah,28631144.470.000.00144.470.00
Bradley, Jocelyn,230227.280.000.000.007.28
Carter, Isaac,137191129.480.000.000.001129.48
Edwards, Logan,250024.990.000.000.004.99
Flores, Cassidy, L,233684.990.000.000.004.99
Richardson, Brian,2860878.980.000.000.0078.98
Jai, Hunter, M,28272111.950.000.000.00111.95
Johnson, Jonathan,220597.280.000.007.280.00
Hill, Katherine, L,2670139.980.000.0039.980.00
Murphy, Brianna, K,2834269.990.000.000.0069.99
Coleman, Dylan,27403132.970.000.000.00132.97
Anand, Brendan, L,1984721.980.000.000.0021.98
Young, Jenna, W,163652490.180.000.000.002490.18
Mitchell, Thomas, J,137112380.470.000.000.002380.47
Nelson, Katherine,2802178.980.000.000.0078.98
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Peterson, Xavier, R,2645639.980.000.000.0039.98
Flores, Julian,158464943.320.000.000.004943.32
Wang, Zachary,2214489.970.000.000.0089.97
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Collins, Isaac,260777.280.000.000.007.28
Russell, Caleb,23552103.480.000.000.00103.48
Edwards, Hailey,242584.990.000.000.004.99
Johnson, Jacob, I,28069553.970.000.000.00553.97
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Robinson, Ian, D,138522294.990.000.000.002294.99
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Butler, Cassidy, L,21792114.460.000.000.00114.46
Phillips, Haley, B,2807939.980.000.000.0039.98
Baker, Eduardo,180921789.450.000.000.001789.45
Stewart, Gabriella,2803469.990.000.000.0069.99
Nath, Carl, H,29001624.970.000.000.00624.97
Perry, Jackson, J,213064.990.000.000.004.99
Bell, Chase,180911750.980.000.000.001750.98
Rodriguez, Natalie,2077330.970.000.000.0030.97
Hughes, Riley,2928449.990.000.000.0049.99
Ward, Destiny,16128539.990.000.000.00539.99
Perez, Jonathan, R,2345512.940.000.000.0012.94
Perry, James,192051249.840.000.000.001249.84
Walker, Jacob, N,29027574.980.000.000.00574.98
Foster, Nicole, A,2349489.970.000.000.0089.97
Alexander, Gavin, K,2932249.990.000.000.0049.99
Li, Brandon,2933973.960.000.000.0073.96
Campbell, Timothy,2584513.980.000.000.0013.98
Collins, Charles, B,29041628.450.000.000.00628.45
Adams, Katherine, M,235184.990.000.000.004.99
Hayes, Gavin, A,194001179.470.000.000.001179.47
Roberts, Jordan, M,1680039.250.000.000.0039.25
Powell, Ian,2608564.470.000.000.0064.47
Nelson, James, L,245257.280.000.007.280.00
Garcia, Jonathan,1888386.960.000.0029.9956.97
Mitchell, Bailey, B,267067.280.000.007.280.00
Rogers, Faith,2468259.980.000.000.0059.98
Stewart, Melissa,2517336.960.000.000.0036.96
Thomas, Emily,2180339.980.000.000.0039.98
Griffin, Stephanie, L,2826127.920.000.000.0027.92
Morgan, Evan, G,14725318.830.000.0069.97248.86
Baker, Robert, A,273007.280.000.007.280.00
Gill, Robyn, J,127651750.980.000.001750.980.00
Ross, Aaron, N,118882376.960.000.002376.960.00
Anderson, Tyler, E,131481137.430.000.001137.430.00
Ramirez, Melanie, V,163632481.820.000.002481.820.00
Morris, Alyssa,28072548.980.000.000.00548.98
Hall, Kyle, J,1749169.970.000.000.0069.97
Cook, Seth,2301064.470.000.000.0064.47
Harris, Destiny, M,137102341.460.000.000.002341.46
Kumar, Zachary,254334.990.000.000.004.99
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Simmons, David, E,120172339.970.000.002339.970.00
Foster, Caleb,27112114.460.000.000.00114.46
Luo, Donna, E,248054.990.000.000.004.99
Gonzalez, Gabriella, Z,15872235.540.000.000.00235.54
Griffin, Isabelle,249864.990.000.000.004.99
Butler, Benjamin, C,189722369.970.000.000.002369.97
Lee, Ian,19646197.040.000.000.00197.04
Alexander, Thomas,207607.280.000.000.007.28
Henderson, Luke,19200109.240.000.000.00109.24
Parker, Jeremy,2866878.980.000.0078.980.00
Smith, Eduardo,2069139.980.000.0039.980.00
Barnes, Kayla,2425639.980.000.0039.980.00
Edwards, Madeline,2077146.470.000.000.0046.47
Perry, Brandon,22095141.980.000.000.00141.98
Cox, Nathaniel, A,196612521.270.000.000.002521.27
Gray, Jared, A,264494.990.000.004.990.00
Martin, Christian, V,19709197.250.000.000.00197.25
Sanders, Lucas, W,268024.990.000.000.004.99
Cook, Joan,235544.990.000.000.004.99
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Robinson, Zachary, L,137092332.280.000.000.002332.28
Miller, Andrew, C,271104.990.000.000.004.99
Lee, Alexander, S,18356149.910.000.000.00149.91
Sanchez, Grace,120802354.990.000.002354.990.00
Taylor, Marcus, A,18944146.940.000.000.00146.94
Reed, Kaylee, R,17371151.920.000.000.00151.92
King, Sara,2235439.980.000.000.0039.98
Ross, David, M,171431763.970.000.000.001763.97
Campbell, Lucas,2932953.990.000.000.0053.99
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Moore, Wyatt, F,189712351.960.000.000.002351.96

Generated 2024-09-21 06:46:53.588 UTC