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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Powell, David, W,266151000.440.000.001000.440.00
Powell, Elijah, E,231135997.330.003578.270.002419.06
Murphy, Olivia, V,202063204.580.002049.100.001155.48
Thomas, William, A,216142589.090.000.002049.10539.99
Thompson, Ethan,199894495.480.003374.990.001120.49
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Garcia, Lucas,27545782.990.000.00782.990.00
James, Juan,232674862.090.003578.271283.820.00
Washington, Robert, J,14906143.950.000.000.00143.95
Washington, Alexia,27613782.990.000.00782.990.00
Flores, Logan, K,14631848.470.000.000.00848.47
Russell, Samantha,11211723.560.000.00118.46605.10
Bryant, Zachary,216552648.070.000.002049.10598.97
Foster, Eric,229765971.330.003578.270.002393.06
Peterson, Jessica, M,11868247.010.000.0061.97185.04
Russell, Elijah, M,118354772.300.000.002319.262453.04
Bryant, Isabella, L,229956060.500.003578.270.002482.23
Harris, Destiny, M,137102341.460.000.000.002341.46
Jackson, Edward,290422420.340.000.002420.340.00
Harris, Megan,232814828.110.003578.270.001249.84
Morgan, Timothy,14633242.500.000.0071.58170.92
Roberts, Seth, H,11510258.150.000.0039.47218.68
Shan, Benjamin,235663578.270.003578.270.000.00
Davis, Marcus, T,17337123.910.000.0086.9536.96
Moore, Jonathan,2047896.460.000.000.0096.46
Rodriguez, Morgan,237304828.110.003578.270.001249.84
Turner, Morgan,11823178.470.000.000.00178.47
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Thomas, Dylan,198737.280.000.000.007.28
Kumar, Zachary,254334.990.000.000.004.99
Russell, Samuel, V,11652310.930.000.000.00310.93
Sanz, Lori, L,238654891.610.003578.270.001313.34
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Long, Jordyn,1733847.250.000.000.0047.25
Campbell, Evan, W,243424828.110.003578.270.001249.84
Collins, Xavier, C,16646250.910.000.000.00250.91
Foster, Carson, L,16959135.350.000.0085.4849.87
Martinez, Jill,242354829.390.003578.270.001251.12
Powell, Jordyn, K,153914828.010.000.000.004828.01
Harris, Samantha, A,244874.990.000.000.004.99
Ms., Coleman, Abigail, C,238684829.390.003578.270.001251.12
Chapman, Nancy, E,11276840.150.000.0066.26773.89
Washington, Hailey, S,2588559.980.000.000.0059.98
Wright, Robert, C,158894848.030.000.000.004848.03
Torres, Mackenzie,28153570.470.000.000.00570.47
Carter, Katherine,11861286.300.000.000.00286.30
Hughes, Luke, I,270141274.080.00699.100.00574.98
Edwards, Madeline,2077146.470.000.000.0046.47
Harris, Matthew,14330806.760.000.000.00806.76
Martinez, Hannah, M,246664370.610.003578.270.00792.34
Williams, Morgan, C,203733226.900.000.002071.421155.48
Jai, Jose,12944164.210.000.000.00164.21
Richardson, Melissa, E,111322371.940.000.000.002371.94
Rodriguez, Taylor,1607166.960.000.000.0066.96
Martin, John, A,144364776.010.000.000.004776.01
Henderson, Caroline,2008256.970.000.000.0056.97
Gonzales, Brittany,217104187.233578.270.000.00608.96
Nelson, Sierra,161322459.620.000.002459.620.00
Rivera, Caitlin, L,261132730.540.000.002181.56548.98
Cooper, Alexandra,19541131.240.000.000.00131.24
Alexander, Ryan, J,14078839.480.000.00839.480.00
Bennett, Maria, G,229837.280.000.000.007.28
Smith, Noah,13175166.920.000.000.00166.92
Thomas, Seth,14567161.280.000.0096.0765.21
Watson, Emma,17481126.940.000.000.00126.94
Brown, Morgan,2919778.980.000.000.0078.98
Carter, Jesse, E,22141166.280.000.000.00166.28
Suarez, Juan, R,167631700.990.000.000.001700.99
Jai, Hunter, M,28272111.950.000.000.00111.95
Wilson, Jeremy, T,28341128.970.000.000.00128.97
Rodriguez, Lucas, P,15942191.870.000.000.00191.87
Foster, Antonio,12795108.540.000.0066.2642.28
Zhang, Robert,188551155.480.000.000.001155.48
Cook, Bryce,2864069.990.000.000.0069.99
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Allen, Sean, L,12097159.220.000.000.00159.22
Fernandez, Ruth,205463246.550.000.002049.101197.45
Coleman, Dylan,27403132.970.000.000.00132.97
James, Adrian, C,253404.990.000.000.004.99
Martinez, Wyatt, R,228815997.330.003578.270.002419.06
Wilson, Eduardo,15323804.470.000.000.00804.47
Smith, Chloe,17619163.920.000.000.00163.92
Jones, Samantha,1831721.980.000.000.0021.98
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Ross, Anna, D,15494275.440.000.0029.99245.45
Turner, Wyatt,200345769.960.003399.990.002369.97
Ross, Kaitlyn,16121614.470.000.000.00614.47
Wood, Brittany,2877753.990.000.000.0053.99
Collins, Isaac,260777.280.000.000.007.28
Sánchez, Angela, C,176551750.980.000.000.001750.98
Jenkins, Austin, D,15748296.910.000.000.00296.91
Jai, Luis, A,18320185.920.000.000.00185.92
Powell, Katherine, C,14574177.600.000.000.00177.60
Flores, Arianna,217274132.243578.270.000.00553.97
Nelson, Jose,19217185.020.000.0091.9593.07
Morgan, Jada, A,11520702.990.000.00137.45565.54
Rivera, Sara,187852350.960.000.000.002350.96
Stewart, Alex, M,2008463.150.000.000.0063.15
Smith, Austin,13707149.050.000.000.00149.05
Moore, Ian, L,2463939.980.000.000.0039.98
Foster, Isabelle,2637739.980.000.000.0039.98
Zukowski, Jake,220584118.263578.270.000.00539.99
Collins, Allison,28581119.980.000.000.00119.98
Torres, Mariah,16380195.950.000.000.00195.95
Price, Caroline,180511735.980.000.000.001735.98
Barnes, Brittany, R,15340156.040.000.0074.4681.58
Ma, Tiffany,2157739.980.000.000.0039.98
Stewart, Gabriella,2803469.990.000.000.0069.99
Flores, Luke, L,247337.280.000.000.007.28
Ross, Rachel, C,206693169.590.000.002049.101120.49
Li, Rafael, M,217527.280.000.000.007.28
Perry, Jackson, J,213064.990.000.000.004.99
Williams, Ethan,243094793.120.003578.270.001214.85
Flores, Megan, N,230746021.820.003578.270.002443.55
Rodriguez, Natalie,2077330.970.000.000.0030.97
Baker, Sara, M,11827512.470.000.00148.47364.00
Hayes, Brittany,13941286.820.000.000.00286.82
Thomas, Matthew, K,13239185.700.000.000.00185.70
Patterson, Alexis,213484392.020.000.002049.102342.92
Perry, Christian,246714354.600.003578.270.00776.33
Carter, Jason,11724210.090.000.00113.8696.23
Sanders, Hailey,19647282.040.000.000.00282.04
Blanco, Armando, F,139182397.950.000.000.002397.95
Cox, Julia, A,206703228.570.000.002049.101179.47
Williams, Edward, D,14274121.560.000.000.00121.56
Thomas, David,168363193.790.000.000.003193.79
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Martin, Jill, C,11824181.030.000.0069.97111.06
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
Long, Rachel,2828339.980.000.000.0039.98
Howard, Alexandra,207363194.580.000.002049.101145.48
Ramirez, Emma,29072128.970.000.000.00128.97
Campbell, Timothy,2584513.980.000.000.0013.98
Carter, Jose, H,12532235.720.000.000.00235.72
Brown, Dalton, N,218134118.263578.270.000.00539.99
Stewart, Cody, A,212843223.580.000.002049.101174.48
Kapoor, Preston,2143156.970.000.000.0056.97
Ramirez, Jennifer, E,213114472.580.000.002049.102423.48
Bailey, Marcus, L,18329146.530.000.0023.78122.75
Young, Kaitlyn, J,2506213.980.000.000.0013.98
Torres, Abigail,253674.990.000.000.004.99
Flores, Caleb, S,12165280.640.000.00243.3737.27
Turner, Blake,12136131.740.000.000.00131.74
Scott, Adam,15863243.010.000.000.00243.01
Thomas, Jessica,1684894.480.000.0094.480.00
Powell, Blake, J,2237139.980.000.000.0039.98
Alexander, Aidan,17387148.190.000.0056.9791.22
Coleman, Luke, A,11723152.550.000.0069.9882.57
Lopez, Carlos,186171147.770.000.000.001147.77
Sanchez, Martin, E,216317.280.000.000.007.28
Wedge, Andrew, T,120604811.540.000.002418.482393.06
Reed, Judith, D,2534759.980.000.000.0059.98
Martin, Lucas, L,221144183.233578.270.000.00604.96
Alexander, Elijah,11738331.680.000.00141.73189.95
Gutierrez, Jerome,127832420.460.000.000.002420.46
Mitchell, Jonathan, L,221095971.333578.270.002393.060.00
Russell, Ian, T,2474613.980.000.0013.980.00
Parker, Amanda,1808151.970.000.000.0051.97
Ross, Isabelle, D,18554155.450.000.0069.9785.48
Young, Adam,12984200.200.000.0037.29162.91
Brown, Samantha, G,2514739.980.000.000.0039.98
Williams, Ryan, R,222475978.610.003578.270.002400.34
Butler, Dalton, A,133454759.510.000.000.004759.51
Morgan, Angela,24665109.970.000.000.00109.97
Powell, Vanessa,26630699.100.00699.100.000.00
Torres, Xavier,16840176.950.000.000.00176.95
Stewart, Grace, H,247737.280.000.000.007.28
Parker, Jennifer, D,221184158.240.003578.270.00579.97
Phillips, Kyle,12158202.200.000.000.00202.20
Wright, Kyle,2371626.970.000.000.0026.97
Perry, Jennifer, J,221205962.340.003578.272384.070.00
Patterson, Taylor,12147271.450.000.000.00271.45
Mitchell, Kaylee, R,14566401.490.000.000.00401.49
Simmons, Mariah,266831270.820.00699.100.00571.72
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Campbell, Hunter,17422174.920.000.000.00174.92
Rubio, Ruben, D,1887186.960.000.0086.960.00
Murphy, Juan, T,246463578.270.003578.270.000.00
Perry, Melissa,221284142.230.003578.270.00563.96
Washington, Hannah, A,291307.280.000.007.280.00
Hayes, Austin,202083219.580.002049.100.001170.48
Sandberg, Isaac,1335053.970.000.000.0053.97
Russell, Rachel, C,2158124.270.000.0024.270.00
Long, Caleb, P,250462181.560.002181.560.000.00
Lee, John,19801193.010.000.000.00193.01
Simmons, Dylan,16133107.850.000.0038.8868.97
Wood, Alexandria, M,248242181.560.002181.560.000.00
Johnson, James,234984.990.000.000.004.99
Alexander, Paige, W,1860459.250.000.0037.2721.98
Richardson, Victoria, C,248172181.560.002181.560.000.00
Brown, Isabella, L,266921266.860.00699.100.00567.76
Bradley, Jocelyn,230227.280.000.000.007.28
Jai, Adam,250952443.350.002443.350.000.00
Bell, Gabrielle,223735976.320.003578.270.002398.05
Green, Eric,2738069.990.000.000.0069.99
Price, Jocelyn, D,258752443.350.002443.350.000.00
Moore, Taylor, A,199874564.450.003374.990.001189.46
King, Gabrielle,263504.990.000.000.004.99
Clark, Anthony,27071782.990.00782.990.000.00
Griffin, Xavier,228775962.340.003578.270.002384.07
Williams, Austin,2035432.220.000.000.0032.22
Cook, Steven, J,27053782.990.00782.990.000.00
Lewis, Lucas, A,232094802.110.003578.271223.840.00
Griffin, Jordan,13095328.890.000.0069.97258.92
Russell, Fernando,27084782.990.000.00782.990.00
Bailey, Morgan, E,213542646.400.000.002071.42574.98
Hall, Jose, J,17601225.420.000.00155.4569.97
Perry, Olivia,203754438.380.000.002071.422366.96
Harris, Emily, P,1986298.480.000.000.0098.48
Chen, Luis, G,2125294.450.000.0094.450.00
Carter, Sydney,12959203.920.000.000.00203.92
Brooks, Isaac, M,233854829.390.003578.270.001251.12
Sandberg, Chase,2190475.970.000.000.0075.97
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Ortega, Byron,233064828.110.003578.270.001249.84
Roberts, Rebecca,2800094.480.000.000.0094.48
Walker, Brandon, J,159164793.270.000.000.004793.27
Torres, Haley, W,232834828.110.003578.270.001249.84
Walker, Thomas,1307193.980.000.000.0093.98
Nelson, Jennifer,171471700.990.000.000.001700.99
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Chow, Candice,1923260.960.000.000.0060.96
Collins, Alex, S,287812.290.000.000.002.29
Stewart, Jessica,16097103.550.000.0046.5856.97
Howard, Brianna, D,246304.990.000.000.004.99
Hill, Haley, J,161033142.320.000.00792.342349.98
Wilson, Fernando,16643126.960.000.000.00126.96
Turner, James, E,16841126.960.000.0069.9956.97
Garcia, Isabella,18382204.940.000.000.00204.94
Ware, Dennis, L,237254828.110.003578.270.001249.84
Lobao, Alexandre,1892691.950.000.0091.950.00
Evans, Kaylee,19642133.540.000.000.00133.54
Murphy, Catherine, L,1650692.050.000.000.0092.05
Peterson, Steven, L,234497.280.000.007.280.00
Lewis, Isabella,2624267.930.000.000.0067.93
Garcia, Cameron,186411120.490.000.000.001120.49
Prasad, Summer, M,2214339.980.000.0039.980.00
Zeng, Jake,18054106.930.000.000.00106.93
Wilson, Hunter, R,2723013.980.000.000.0013.98
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Sharma, Jackson,16876151.840.000.000.00151.84
Campbell, Kevin, S,121774811.500.000.002404.462407.04
Green, Kaylee, C,2618567.970.000.000.0067.97
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Thompson, Jose,237314828.110.003578.270.001249.84
Phillips, Aaron, R,2494739.980.000.000.0039.98
Ramirez, Sydney,267007.280.000.000.007.28

Generated 2024-11-10 02:35:04.982 UTC