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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Robinson, Joseph,2814194.480.000.0094.480.00
Edwards, Angel, J,2912469.990.000.000.0069.99
Hall, Grace, A,201894.990.000.000.004.99
Sanders, Angel,16219553.970.000.000.00553.97
Bryant, Samantha,18345115.470.000.000.00115.47
Lopez, Isaiah,18968151.430.000.000.00151.43
Thomas, Victoria, A,15536249.530.000.000.00249.53
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Ross, Antonio,18322148.890.000.000.00148.89
Davis, Jonathan,2925913.980.000.000.0013.98
Yang, Jordan, K,14458133.950.000.000.00133.95
Price, Riley, R,139094764.020.000.000.004764.02
Ross, Seth, M,184332329.980.000.000.002329.98
Sanders, Hailey,19647282.040.000.000.00282.04
Washington, Hailey, S,2588559.980.000.000.0059.98
Parker, Jennifer, D,221184158.240.003578.270.00579.97
Wright, Carol, C,12928247.410.000.0033.98213.43
Sanders, Xavier,1672173.750.000.000.0073.75
Gray, Cody, C,144594775.010.000.000.004775.01
Flores, Julian,158464943.320.000.000.004943.32
Cooper, Andrea,2932378.980.000.000.0078.98
Taylor, Ryan,170251709.980.000.000.001709.98
Campbell, Isabella, C,203503226.900.002071.420.001155.48
Wilson, Tyler, L,15879196.930.000.000.00196.93
Yang, Aaron, C,2519654.980.000.000.0054.98
Cox, Arianna, D,1892789.250.000.000.0089.25
Collins, Nathan, F,197041143.460.000.000.001143.46
Rowe, Todd,14586233.940.000.000.00233.94
Ross, Rachel, C,206693169.590.000.002049.101120.49
Foster, Nicole, A,2349489.970.000.000.0089.97
Garcia, Brandon, V,244184329.610.003578.270.00751.34
Young, Adam,12984200.200.000.0037.29162.91
Torres, Abigail,253674.990.000.000.004.99
Flores, Jordyn,252882721.550.002181.560.00539.99
Taylor, Zachary, M,27082782.990.000.00782.990.00
Sanchez, Stephanie,1786756.970.000.000.0056.97
Lopez, Jack, I,2904751.460.000.000.0051.46
White, Greg, C,174032322.280.000.000.002322.28
Stewart, Amanda, M,1531094.440.000.000.0094.44
Martinez, Grace, M,17385208.690.000.0069.97138.72
Harris, Anthony,2144721.980.000.000.0021.98
Blanco, Randall,263211554.410.000.001000.44553.97
Perry, James,192051249.840.000.000.001249.84
Price, Marissa,15826160.740.000.00120.4840.26
Garcia, Jonathan,1888386.960.000.0029.9956.97
Garcia, Patricia,11651226.430.000.0099.97126.46
Ma, Tiffany,2157739.980.000.000.0039.98
McDonald, Aaron, J,27734119.980.000.000.00119.98
Walker, Thomas,1307193.980.000.000.0093.98
Hall, Charles,234764.990.000.000.004.99
Watson, Janet, S,2320859.980.000.000.0059.98
Lal, Kyle,17360122.180.000.000.00122.18
Washington, Caroline, D,231145996.320.003578.270.002418.05
King, Aaron, L,117394758.030.000.002359.982398.05
Coleman, Luke, A,11723152.550.000.0069.9882.57
Ward, Destiny,16128539.990.000.000.00539.99
Perry, Lauren,248164.990.000.000.004.99
Perez, Barry, M,2728269.990.000.000.0069.99
Rivera, Ariana,261734.990.000.000.004.99
Chapman, Nancy, E,11276840.150.000.0066.26773.89
Gonzales, Paige,2170291.940.000.0039.9851.96
Powell, Lauren, E,1966275.970.000.000.0075.97
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Johnson, Christopher,119794813.760.000.002352.212461.55
Flores, Arianna,217274132.243578.270.000.00553.97
Bryant, Gabriel,2765669.990.000.000.0069.99
Smith, Chloe,17619163.920.000.000.00163.92
Perry, Justin, E,167583062.340.000.000.003062.34
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Moore, Seth,138512331.950.000.000.002331.95
Gray, Sebastian, B,138782366.960.000.000.002366.96
Phillips, James, G,16846180.950.000.00123.9856.97
Wilson, Nathan, L,13936218.930.000.000.00218.93
Lal, Luke, L,11019698.230.000.00139.93558.30
White, Abigail, T,15866145.820.000.0038.88106.94
Long, Julia, R,228895971.330.003578.270.002393.06
Srini, Evelyn,16855150.950.000.000.00150.95
Martin, Joshua, A,276077.280.000.000.007.28
Wilson, Jeremy, T,28341128.970.000.000.00128.97
Barnes, Dalton, C,178581700.990.000.000.001700.99
Torres, Erin,1218287.250.000.0037.2949.96
Davis, Austin, E,133664749.040.000.000.004749.04
Foster, Kayla,1969371.950.000.000.0071.95
Alexander, Lauren,189502351.960.000.000.002351.96
Edwards, Eric,2462768.490.000.000.0068.49
Gonzales, Kayla,214947.280.000.000.007.28
Martin, Tyler, L,2772469.990.000.000.0069.99
Evans, Connor, J,15402131.550.000.000.00131.55
Cooper, Christina, C,265121000.440.000.001000.440.00
Martin, Xavier,222335997.330.003578.270.002419.06
Martin, Jill, C,11824181.030.000.0069.97111.06
Gonzales, Jordan,2368113.980.000.000.0013.98
Powell, Jonathan,238584712.740.003578.271134.470.00
James, Maria,1624391.970.000.0069.9921.98
Gonzalez, Katherine,222345976.320.003578.270.002398.05
Bryant, Dakota, L,176132401.950.000.000.002401.95
Hernandez, Jonathan, J,1901465.950.000.000.0065.95
Bailey, Jessica, L,12945218.440.000.000.00218.44
Green, Eric,2738069.990.000.000.0069.99
Harris, Natalie,2368259.980.000.0059.980.00
King, Morgan,196811179.970.000.000.001179.97
Hernandez, Sierra,27393123.980.000.00123.980.00
Chen, Luis, G,2125294.450.000.0094.450.00
Jai, Hunter, M,28272111.950.000.000.00111.95
Coleman, Spencer,15993597.260.000.000.00597.26
Edwards, Madeline,2077146.470.000.000.0046.47
Morgan, Isabella, L,28602144.470.000.000.00144.47
Sanders, Lucas, W,268024.990.000.000.004.99
Reed, Judith, D,2534759.980.000.000.0059.98
Morris, Seth,189592341.460.000.000.002341.46
Butler, Jackson, J,183241735.980.000.000.001735.98
Ware, Dennis, L,237254828.110.003578.270.001249.84
Alexander, Elijah,11738331.680.000.00141.73189.95
Henderson, Caroline,2008256.970.000.000.0056.97
Brown, Julia,18065155.470.000.000.00155.47
Jones, Alexander, I,2002180.960.000.000.0080.96
Russell, Jessica,265721000.440.000.001000.440.00
Davis, Jasmine, M,265291549.420.000.001000.44548.98
Davis, Daniel,11711999.220.000.0081.49917.73
Wright, Jackson,11698225.950.000.000.00225.95
Watson, Victoria,16125588.960.000.000.00588.96
Barnes, Ian, M,16106133.540.000.000.00133.54
Prasad, Donald,15413318.920.000.00123.98194.94
Bryant, Brittany,2254548.970.000.000.0048.97
Phillips, Aaron, R,2494739.980.000.000.0039.98
Sanders, Chloe, C,231375314.250.003578.270.001735.98
Ruiz, Philip,1807781.460.000.000.0081.46
Allen, Sean, L,12097159.220.000.000.00159.22
Yuan, Brendan, S,247444.990.000.000.004.99
Diaz, Trevor, B,2051954.960.000.000.0054.96
Kelly, Bryan,213492989.380.000.002989.380.00
Shan, Gabriel, T,2773169.990.000.000.0069.99
Davis, Justin,2807412.940.000.000.0012.94
Rodriguez, Lucas, P,15942191.870.000.000.00191.87
Green, Mackenzie, C,280737.280.000.000.007.28
Green, Xavier,2356739.980.000.000.0039.98
Bell, Alexandria, A,13758284.130.000.0042.28241.85
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Alexander, Paige, W,1860459.250.000.0037.2721.98
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Scott, Mason,2355139.980.000.000.0039.98
Evans, Maria,22544127.280.000.00127.280.00
Murphy, Brianna, K,2834269.990.000.000.0069.99
Bell, Danielle,140414765.020.000.000.004765.02
Li, Thomas,181162376.960.000.000.002376.96
Thompson, Jose,237314828.110.003578.270.001249.84
Baker, Sean, T,247782858.490.002181.56676.930.00
Wright, Jennifer,2650559.980.000.0059.980.00
Griffin, Seth, R,17585164.460.000.0078.9885.48
Barnes, Blake, A,178651789.970.000.000.001789.97
Phillips, Kaylee,211384371.380.000.002049.102322.28
Hayes, Dalton, C,188822322.280.000.000.002322.28
Navarro, Jerome, B,11519717.280.000.0022.18695.10
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Long, Gabrielle,198305765.923374.990.000.002390.93
Martin, Lucas, L,221144183.233578.270.000.00604.96
Flores, Morgan,19817118.940.000.0039.9878.96
Gray, Jesse,14626197.040.000.000.00197.04
Henderson, Sarah, M,238674802.110.003578.270.001223.84
Brooks, Evan,2340139.980.000.000.0039.98
Stewart, Hailey,229036054.220.003578.270.002475.95
Young, Julia, J,274144.990.000.000.004.99
Sanchez, Jared, J,2585064.470.000.000.0064.47
Moore, Anthony, M,2473039.980.000.000.0039.98
Anand, Brendan, L,1984721.980.000.000.0021.98
Perry, Eric,18314115.730.000.000.00115.73
Smith, Katherine, J,13197105.190.000.000.00105.19
Green, Gabrielle, M,2181564.470.000.000.0064.47
Williams, Edward, D,14274121.560.000.000.00121.56
Evans, Elijah, S,2588439.980.000.000.0039.98
Torres, Victoria,17551160.920.000.000.00160.92
Nelson, Luis,234884.990.000.000.004.99
Roberts, Hunter,282607.280.000.000.007.28
Harrison, Trevor, A,18055143.910.000.0036.96106.95
Walker, Richard, T,19640224.550.000.000.00224.55
Cook, Steven, J,27053782.990.00782.990.000.00
Reed, Bryan,18884133.930.000.000.00133.93
Ortega, Javier, P,127852294.990.000.000.002294.99
Stewart, Cody, A,212843223.580.000.002049.101174.48
Ward, Natalie, J,132412325.960.000.000.002325.96
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Ward, Cole,214907.280.000.000.007.28
Kelly, Julia,2379867.930.000.0067.930.00
Chen, Jack, E,17579151.430.000.000.00151.43
Coleman, Ashley,27297782.990.000.00782.990.00
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Johnson, Edward, H,23279124.990.000.000.00124.99
Green, Samuel, D,14096174.730.000.000.00174.73
Parker, Eduardo, M,12939169.420.000.000.00169.42
Martin, Alfredo, P,2148039.980.000.000.0039.98
Foster, Isabel, M,2174571.950.000.000.0071.95
Adams, Haley, M,247862443.350.002443.350.000.00
Russell, Kaitlyn, M,244913578.270.003578.270.000.00
Bailey, Marcus, L,18329146.530.000.0023.78122.75
Garcia, Henry, B,112871009.240.000.00219.26789.98
Hughes, Zachary,12203157.910.000.000.00157.91
Roberts, Carlos,2319639.980.000.000.0039.98
Cooper, Brian, L,13760128.840.000.000.00128.84
Sanchez, Mariah, R,1922066.650.000.0038.8827.77
Flores, Brandon, L,2562189.970.000.000.0089.97
Morris, Mackenzie, N,2647413.980.000.000.0013.98
Carter, Bailey,213322616.860.000.002616.860.00
Perry, Samuel,18811100.960.000.0069.9930.97
Peterson, Julia, P,16497132.710.000.000.00132.71
Watson, Marcus,2271585.480.000.000.0085.48
Parker, Katherine,13268289.700.000.0068.97220.73
Taylor, Edward, C,17442319.880.000.00230.9088.98
Martinez, Carol, D,17656578.460.000.000.00578.46
Mitchell, Thomas, J,137112380.470.000.000.002380.47
Hall, Amber,20106131.950.000.000.00131.95
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Lee, Emma,16948176.430.000.000.00176.43
Price, Caroline,180511735.980.000.000.001735.98
Kelly, Bailey, R,28284563.770.000.000.00563.77
Madan, Carmen, V,155674720.270.000.000.004720.27
Phillips, Kyle,12158202.200.000.000.00202.20
Phillips, Luis, G,207347.280.000.000.007.28
Bell, Brooke, H,2325339.980.000.000.0039.98
Collins, Amanda,2078339.980.000.000.0039.98
Diaz, Brandon,236764.990.000.004.990.00
White, James,253317.280.000.000.007.28
Jones, Nicole,14504112.270.000.000.00112.27
Campbell, Timothy,2584513.980.000.000.0013.98
Ward, Eduardo, I,139162354.980.000.000.002354.98
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Collins, Alex, S,287812.290.000.000.002.29
Long, Rachel,2828339.980.000.000.0039.98
Collins, Jonathan,16849119.980.000.000.00119.98
Johnson, Cameron, R,137201155.480.000.000.001155.48
James, Zoe, R,14611304.550.000.000.00304.55
Reed, Michelle,2804669.990.000.000.0069.99
Bennett, Seth,244933578.270.003578.270.000.00
Thompson, Lucas, O,212774.990.000.000.004.99
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Alexander, Caroline,176541759.970.000.000.001759.97
Griffin, Melissa, L,287807.950.000.000.007.95
Li, Kevin, S,2518813.980.000.000.0013.98
Rogers, Jade, I,14332102.250.000.000.00102.25
Cox, Devin, C,134184768.050.000.000.004768.05
Russell, Isabella, A,11507645.780.000.0028.48617.30
Allen, Madeline,2924068.970.000.000.0068.97
Harris, Destiny, M,137102341.460.000.000.002341.46
Powell, Ian,2608564.470.000.000.0064.47
Robinson, Jennifer, L,265041000.440.000.001000.440.00
Jai, Kevin,1983678.960.000.0038.9839.98
Collins, Hailey,11709325.890.000.0021.49304.40
Li, Jordan,17026261.390.000.00261.390.00

Generated 2024-11-10 02:18:59.876 UTC