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

257 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Henderson, Olivia,188591155.480.000.000.001155.48
Reed, Michelle,2804669.990.000.000.0069.99
Foster, Jose, C,2878534.990.000.000.0034.99
Flores, Julian,158464943.320.000.000.004943.32
Johnson, Madison, L,15530846.460.000.000.00846.46
Alexander, Angelica,2271471.950.000.000.0071.95
Foster, Caleb,27112114.460.000.000.00114.46
Luo, Donna, E,248054.990.000.000.004.99
Bradley, Nathaniel,169551760.470.000.000.001760.47
Foster, Paige,2742894.480.000.000.0094.48
Price, Rachel, D,2532889.970.000.000.0089.97
Edwards, Logan,250024.990.000.000.004.99
Ross, David, M,171431763.970.000.000.001763.97
Turner, Mary,220154.990.000.000.004.99
Chandra, Allen,2932753.990.000.000.0053.99
Nelson, Katherine,2802178.980.000.000.0078.98
Harris, Anthony,2144721.980.000.000.0021.98
Richardson, Lauren, C,14867839.480.000.000.00839.48
Wang, Zachary,2214489.970.000.000.0089.97
Ramirez, Emma,29072128.970.000.000.00128.97
Adams, Katherine, M,235184.990.000.000.004.99
Campbell, Natalie, L,115122319.990.000.000.002319.99
Zukowski, Jake,220584118.263578.270.000.00539.99
Reed, Paige,221126047.320.003578.272469.050.00
Murphy, Emma,198445807.930.003374.990.002432.94
Parker, Jennifer, D,221184158.240.003578.270.00579.97
Martin, Xavier,222335997.330.003578.270.002419.06
Brown, Anna,1624795.820.000.000.0095.82
Brooks, Paige,222325985.310.003578.270.002407.04
Sandberg, Isaac,1335053.970.000.000.0053.97
Parker, Madeline, H,221826006.320.003578.270.002428.05
Rogers, Sara,198744544.450.003374.990.001169.46
Powell, Spencer,14904468.120.000.000.00468.12
Carter, Marcus, l,2147131.970.000.000.0031.97
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Walker, Hunter,271007.280.000.000.007.28
Thomas, Alexandra, C,231724809.390.003578.271231.120.00
Reed, Sean, L,145974803.310.000.000.004803.31
Morris, Chase, F,26789699.100.00699.100.000.00
Ward, Angela, M,2775669.990.000.000.0069.99
Ware, Dennis, L,237254828.110.003578.270.001249.84
Powell, Jonathan,238584712.740.003578.271134.470.00
Alexander, Ashley, J,200074495.480.003374.990.001120.49
Ramos, Kristi,151764703.030.000.000.004703.03
Thompson, Jose,237314828.110.003578.270.001249.84
Foster, Olivia,238063578.270.003578.270.000.00
Sanders, Melissa, R,242844837.340.003578.270.001259.07
Ward, Devin, J,15378170.910.000.0076.9593.96
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Thompson, Abigail,243324816.090.003578.270.001237.82
Rogers, Faith,2468259.980.000.000.0059.98
Flores, Xavier,238664828.110.003578.270.001249.84
Perry, Jonathan, T,27026699.100.00699.100.000.00
Jones, Madison,246614181.760.003578.27603.490.00
Lal, Jonathan,2009671.460.000.000.0071.46
Bennett, Seth,244933578.270.003578.270.000.00
Martinez, Hannah, M,246664370.610.003578.270.00792.34
Sanchez, Mariah, R,1922066.650.000.0038.8827.77
Morris, Richard,2007039.980.000.000.0039.98
Stewart, Julia, L,129022329.980.000.000.002329.98
Peterson, Alex, M,13423132.900.000.000.00132.90
Hughes, Morgan, T,11642392.890.000.0049.48343.41
Walker, Emma, M,2520998.960.000.000.0098.96
Collins, Nathan, F,197041143.460.000.000.001143.46
Adams, Mackenzie, A,14640812.420.000.000.00812.42
Anderson, Lucas,2926639.980.000.000.0039.98
Garcia, Brandon, V,244184329.610.003578.270.00751.34
Murphy, Juan, T,246463578.270.003578.270.000.00
She, Alisha, G,247574343.590.003578.270.00765.32
Garcia, Victoria, V,245013578.270.003578.270.000.00
Gutierrez, Jerome,127832420.460.000.000.002420.46
Cooper, Stephanie,249762181.560.002181.560.000.00
Long, Caleb, P,250462181.560.002181.560.000.00
Murphy, Olivia, V,202063204.580.002049.100.001155.48
Scott, Gabrielle,270614.990.000.000.004.99
Phillips, Miguel,2049812.940.000.000.0012.94
Martin, Morgan,248322181.560.002181.560.000.00
Gray, Alexandria, E,253632443.350.002443.350.000.00
Carter, Luis, E,258832443.350.002443.350.000.00
Washington, Robert, J,14906143.950.000.000.00143.95
Harris, Edward,27062782.990.000.00782.990.00
Sanders, Alexandra,259112181.560.000.002181.560.00
Flores, Stephanie,259922721.550.000.002181.56539.99
King, Caleb, J,2898678.980.000.000.0078.98
Alexander, Taylor,17482146.940.000.0076.9769.97
Clark, William,2902169.990.000.000.0069.99
Carter, Madeline, A,2752269.990.000.000.0069.99
Smith, Justin, P,1982721.980.000.000.0021.98
Sanchez, Adrian, L,13179190.170.000.000.00190.17
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Cook, Seth,2301064.470.000.000.0064.47
Kumar, Zachary,254334.990.000.000.004.99
Miller, Katherine, B,27102782.990.000.00782.990.00
Townsend, Jeremiah, I,265031000.440.000.001000.440.00
Thomas, Isabella, M,27265782.990.000.00782.990.00
Ross, Rachel, C,206693169.590.000.002049.101120.49
Diaz, Angela, K,27259782.990.000.00782.990.00
Cox, Julia, A,206703228.570.000.002049.101179.47
Thompson, Joshua, F,259992181.560.000.002181.560.00
Thompson, Devin,207084406.400.000.002071.422334.98
Phillips, Kaylee,211384371.380.000.002049.102322.28
James, Timothy,213312670.890.000.002670.890.00
Garcia, Hunter, J,213053204.580.000.002049.101155.48
Mitchell, Xavier, L,265331629.410.000.001000.44628.97
Foster, Deb,215012661.400.000.002661.400.00
Patterson, Alexis,213484392.020.000.002049.102342.92
Collins, Connor, J,27270782.990.000.00782.990.00
Kelly, Bryan,213492989.380.000.002989.380.00
Phillips, James, G,16846180.950.000.00123.9856.97
Walker, Brandon, J,159164793.270.000.000.004793.27
Collins, Alex, S,287812.290.000.000.002.29
Bryant, Brittany,2254548.970.000.000.0048.97
Hughes, Jasmine,276284.990.000.000.004.99
Powell, Caleb, G,216132610.580.000.002049.10561.48
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Carter, Elijah,216182611.070.000.002611.070.00
Patterson, Grace, M,27560782.990.000.00782.990.00
Wilson, Victoria, R,27536782.990.000.00782.990.00
Garcia, Lucas,27545782.990.000.00782.990.00
Blue, Marcus, L,27550782.990.000.00782.990.00
King, Jordan, C,110202316.970.000.002316.970.00
Washington, Riley, L,185441155.480.000.001155.480.00
Morgan, Brianna, D,111362380.470.000.002380.470.00
Lewis, Isabella,2624267.930.000.000.0067.93
Lopez, Katelyn,11820232.710.000.0060.47172.24
Scott, Kaitlyn, A,12159218.910.000.00133.9684.95
Foster, Trevor, J,2896469.990.000.000.0069.99
Gonzalez, Gabriella, Z,15872235.540.000.000.00235.54
Robinson, Julia,28121119.980.000.000.00119.98
Zhang, Nathan, L,2910478.980.000.000.0078.98
Jai, Logan, H,12031769.490.000.000.00769.49
Nelson, Sierra,161322459.620.000.002459.620.00
Alexander, Ryan, J,14078839.480.000.00839.480.00
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Prasad, Donald,15413318.920.000.00123.98194.94
Nelson, Jordan, H,201304.990.000.004.990.00
Wedge, Andrew, T,120604811.540.000.002418.482393.06
Zhang, Heather,166543056.320.000.00751.342304.98
Martinez, Kristina, S,2134529.930.000.000.0029.93
Foster, Isabel, M,2174571.950.000.000.0071.95
Rivera, Makayla, A,2878334.990.000.000.0034.99
Smith, Alexandra,2829261.960.000.000.0061.96
He, Micah,2740169.990.000.000.0069.99
Johnson, Anthony, D,270224.990.000.000.004.99
Rivera, Ariana,261734.990.000.000.004.99
Coleman, Joan, W,2669964.470.000.000.0064.47
Miller, Eduardo,14561158.840.000.0049.97108.87
Morgan, Andrea, M,16870149.040.000.00116.4432.60
Russell, Ian, T,2474613.980.000.0013.980.00
Barnes, Haley, J,2133939.980.000.0039.980.00
Wright, Jennifer,2650559.980.000.0059.980.00
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Patterson, Jeremy,130272319.260.000.000.002319.26
Kelly, Trinity,2609515.230.000.000.0015.23
Anderson, Isabella,137432349.980.000.000.002349.98
Bradley, Alexandria,176911779.470.000.000.001779.47
Evans, Gabriel,2348789.970.000.000.0089.97
Rubio, Ruben, D,1887186.960.000.0086.960.00
Bell, Alexandria, A,13758284.130.000.0042.28241.85
Ross, Jose,2744178.980.000.0078.980.00
Washington, Hannah, A,291307.280.000.007.280.00
Alexander, Paige, W,1860459.250.000.0037.2721.98
Mitchell, Caleb, K,268064.990.000.000.004.99
Diaz, Richard, A,2668264.470.000.000.0064.47
Hayes, Hannah, J,2165656.970.000.000.0056.97
Turner, Samuel,2742069.990.000.0069.990.00
Hall, Jose, J,17601225.420.000.00155.4569.97
Bell, Timothy, J,2810178.980.000.0078.980.00
Henderson, Eduardo, R,14359256.240.000.0078.98177.26
Rubio, Jaime, R,15007209.830.000.0049.97159.86
Morgan, Marcus, W,289682.290.000.000.002.29
Barnes, Elizabeth, J,249397.280.000.000.007.28
White, Emily, M,159174679.060.000.000.004679.06
Wilson, Madison, H,1982821.980.000.000.0021.98
Roberts, Robert, R,1898656.970.000.0056.970.00
Lobao, Alexandre,1892691.950.000.0091.950.00
Perez, Amber, D,13318214.260.000.00116.9197.35
Alexander, Julia, J,15291889.470.000.000.00889.47
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Alexander, Caroline,176541759.970.000.000.001759.97
Prasad, Summer, M,2214339.980.000.0039.980.00
Wu, Randy, J,116472365.940.000.002365.940.00
Gray, Sara,292472447.050.000.002447.050.00
Baker, Isaiah,12106169.540.000.000.00169.54
Martin, Noah, A,1765775.970.000.0075.970.00
Taylor, Tyler, A,12032614.960.000.00614.960.00
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Smith, Chloe,17619163.920.000.000.00163.92
Johnson, Xavier, R,2325539.980.000.0039.980.00
Foster, Emma,15468436.350.000.00159.99276.36
Hughes, Isabella,2304851.460.000.000.0051.46
Li, Kevin, S,2518813.980.000.000.0013.98
Brown, Anthony, J,19399151.430.000.000.00151.43
Lee, Ethan, J,223597.280.000.000.007.28
Evans, Jordan,2920939.980.000.0039.980.00
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Bell, Danielle,140414765.020.000.000.004765.02
Price, Riley, R,139094764.020.000.000.004764.02
Diaz, Thomas, O,16020595.960.000.000.00595.96
Perry, Benjamin,291652407.040.000.002407.040.00
Harris, Samuel, M,2477159.980.000.0059.980.00
Blue, Paige,2170313.980.000.000.0013.98
Perez, Timothy, L,227304.990.000.000.004.99
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Davis, Dylan,15556588.960.000.00588.960.00
Foster, Jessica,2606951.460.000.0051.460.00
Ward, Natalie, J,132412325.960.000.000.002325.96
Sandberg, Chase,2190475.970.000.000.0075.97
Diaz, Gabrielle,14893839.480.000.000.00839.48
Moore, Ian, L,2463939.980.000.000.0039.98
Price, Caroline,180511735.980.000.000.001735.98
Baker, Eduardo,180921789.450.000.000.001789.45
Collins, Jonathan,16849119.980.000.000.00119.98
Perry, Jackson, J,213064.990.000.000.004.99
Thomas, Dalton,230097.280.000.000.007.28
Brown, Dylan, J,124492351.960.000.000.002351.96
Li, Thomas,181162376.960.000.000.002376.96
Gray, Seth, M,2008785.480.000.000.0085.48
Wang, Karen, P,1955331.970.000.000.0031.97
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Gonzalez, Molly,1637021.980.000.000.0021.98
Reed, Kaylee, R,17371151.920.000.000.00151.92
Sara, Ivan, L,2509067.930.000.000.0067.93
Roberts, Noah, S,2704268.490.000.000.0068.49
Shan, Gabriel, T,2773169.990.000.000.0069.99
Cooper, Amanda, P,146064716.020.000.000.004716.02
Davis, Justin,2807412.940.000.000.0012.94
Walker, Destiny, M,169961754.980.000.000.001754.98
Stewart, Melissa,2517336.960.000.000.0036.96
Thomas, Jeremiah,183721760.470.000.000.001760.47
Patterson, Austin, O,270247.280.000.000.007.28
Perez, Jonathan, R,2345512.940.000.000.0012.94
Ward, Eduardo, I,139162354.980.000.000.002354.98
Edwards, Amber, B,2051776.970.000.000.0076.97
Gray, Sebastian, B,138782366.960.000.000.002366.96
Moore, Jennifer, A,2175964.470.000.000.0064.47
James, Morgan, E,2324539.980.000.000.0039.98
Patterson, Aaron, W,191131184.460.000.000.001184.46
Foster, Nicole, A,2349489.970.000.000.0089.97
Howard, Danielle,28357133.490.000.000.00133.49
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Martin, Christian, V,19709197.250.000.000.00197.25
Flores, Cassidy, L,233684.990.000.000.004.99
Taylor, Marcus, A,18944146.940.000.000.00146.94
Kumar, Elijah,15197156.920.000.000.00156.92
Miller, Jill,129142329.980.000.000.002329.98
Butler, Jackson, J,183241735.980.000.000.001735.98
Kelly, Bailey, R,28284563.770.000.000.00563.77
Hughes, Austin, P,183681754.980.000.000.001754.98
Ward, Lucas, N,183631700.990.000.000.001700.99
Gomez, Briana, A,2878443.980.000.000.0043.98
Nath, Alison, J,171161764.960.000.000.001764.96
Russell, Richard,2763322.260.000.000.0022.26
Williams, Joshua,260514.990.000.000.004.99
Chen, David,2720839.980.000.000.0039.98
Martin, Alfredo, P,2148039.980.000.000.0039.98
_SUM1806517.5058040.68490414.99296735.13961326.70

Generated 2024-11-14 04:59:36.642 UTC