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

248 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Hayes, Austin,202083219.580.002049.100.001170.48
Brown, Morgan,2919778.980.000.000.0078.98
Long, Caleb, P,250462181.560.002181.560.000.00
White, Nicole,16731155.910.000.0084.9670.95
Murphy, Olivia, V,202063204.580.002049.100.001155.48
Davis, Thomas,167641760.470.000.000.001760.47
Turner, Andrea, A,202093268.550.002049.100.001219.45
Stewart, Alex, M,2008463.150.000.000.0063.15
Hughes, Stephanie,263161000.440.001000.440.000.00
Yuan, Leonard, F,167911729.970.000.000.001729.97
Howard, Isaiah,259813018.330.002443.350.00574.98
Alexander, Julia, J,15291889.470.000.000.00889.47
Bailey, Marcus, L,18329146.530.000.0023.78122.75
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Ross, Alexia, S,13231247.900.000.00104.97142.93
Mehta, Carmen, C,2743694.480.000.000.0094.48
Chen, Jackson, S,270751371.950.00782.990.00588.96
Hu, Gilbert, L,2876769.990.000.000.0069.99
Coleman, Lucas, A,27060782.990.00782.990.000.00
Bryant, Jackson, J,2533239.980.000.000.0039.98
Russell, Fernando,27084782.990.00782.990.000.00
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Perry, Olivia,203754438.380.002071.420.002366.96
Richardson, Olivia,204683169.590.002049.100.001120.49
Blanco, Randall,263211554.410.001000.440.00553.97
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Moore, Andrew, A,13944150.130.000.00107.8542.28
Ward, Cole,214907.280.000.000.007.28
Chavez, Kara, P,13285214.350.000.00119.8994.46
Griffin, Marcus,2075634.560.000.000.0034.56
Cox, Katelyn, B,2174230.970.000.0030.970.00
Collins, Amanda,2078339.980.000.000.0039.98
Jenkins, Megan, R,12074261.380.000.000.00261.38
Ross, Kaitlyn,16121614.470.000.000.00614.47
Johnson, Anthony, D,270224.990.000.004.990.00
Alexander, Logan, E,191161183.470.000.000.001183.47
Coleman, Joan, W,2669964.470.000.0064.470.00
Blue, Melanie, L,178611749.960.000.000.001749.96
Bryant, Samantha,18345115.470.000.000.00115.47
Wood, Brittany,2877753.990.000.000.0053.99
Jai, Kevin,1983678.960.000.0038.9839.98
Russell, Chloe, M,12763589.960.000.000.00589.96
Johnson, Edward, H,23279124.990.000.000.00124.99
Alexander, Taylor,17482146.940.000.0076.9769.97
Roberts, Amber, W,215822638.060.000.002638.060.00
Hughes, Miranda,266784.990.000.000.004.99
Lee, Ethan, J,223597.280.000.007.280.00
Hill, Haley, J,161033142.320.000.00792.342349.98
Price, Riley, R,139094764.020.000.002344.962419.06
James, Bryce,13466133.450.000.000.00133.45
Hall, Noah, A,1525175.250.000.0068.976.28
Jones, Dalton, T,189512334.970.000.000.002334.97
Lewis, Ryan, A,203124.990.000.004.990.00
Martinez, Kristina, S,2134529.930.000.000.0029.93
Washington, Alexandra, E,15498256.520.000.00223.9232.60
Scott, Sean, F,2475539.980.000.000.0039.98
Diaz, Thomas, O,16020595.960.000.00595.960.00
Foster, Isabel, M,2174571.950.000.000.0071.95
Gonzalez, Jackson, S,14480194.940.000.000.00194.94
Gonzales, Jordan,2368113.980.000.000.0013.98
Bailey, Lauren,15864103.550.000.009.9993.56
Diaz, Trevor, B,2051954.960.000.000.0054.96
Carter, Savannah, M,120902350.960.000.002350.960.00
Howard, Erin, L,183621725.210.000.000.001725.21
Alexander, Nathan, A,187951198.970.000.001198.970.00
Taylor, Zachary, M,27082782.990.00782.990.000.00
Shan, Logan,1867760.960.000.0029.9930.97
Diaz, Angela, K,27259782.990.000.00782.990.00
Martin, Samuel,15874225.440.000.0069.99155.45
Cox, Julia, A,206703228.570.000.002049.101179.47
Flores, Isabelle, A,15526188.320.000.0096.0792.25
Phillips, Jack, R,259952443.350.000.002443.350.00
Torres, Mackenzie,28153570.470.000.000.00570.47
Jai, Connor, D,27253782.990.000.00782.990.00
Gonzalez, James, M,188421155.480.000.000.001155.48
White, Christopher, R,260492181.560.000.002181.560.00
Roberts, Seth, H,11510258.150.000.0039.47218.68
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Moore, Jonathan,2047896.460.000.000.0096.46
Thompson, Devin,207084406.400.000.002071.422334.98
Zhang, Nathan, L,2910478.980.000.000.0078.98
Davis, Emily,27267782.990.000.00782.990.00
Yang, Aaron, C,2519654.980.000.000.0054.98
Moore, Ian, L,2463939.980.000.000.0039.98
Alexander, Lauren,189502351.960.000.000.002351.96
Foster, Isabelle,2637739.980.000.000.0039.98
Collins, Nathan, F,197041143.460.000.000.001143.46
Turner, Eduardo,158764789.020.000.000.004789.02
Powell, Blake, J,2237139.980.000.000.0039.98
Collins, Allison,28581119.980.000.000.00119.98
Washington, Victoria,235577.280.000.000.007.28
Price, Caroline,180511735.980.000.000.001735.98
Watson, Marcus,2271585.480.000.000.0085.48
Ma, Tiffany,2157739.980.000.000.0039.98
Martin, Nicholas,233627.280.000.000.007.28
Mitchell, Evan, R,247314.990.000.000.004.99
Flores, Brittany,169062359.980.000.000.002359.98
Martin, Kellie, R,28195574.980.000.000.00574.98
Gonzales, Kayla,214947.280.000.000.007.28
Cooper, Angela,195261179.470.000.000.001179.47
Alexander, Gavin, K,2932249.990.000.000.0049.99
Stewart, Cindy,14496804.480.000.000.00804.48
Long, Gavin,13762186.030.000.0036.59149.44
Thomas, Edward, E,19147133.710.000.000.00133.71
Bennett, Brittany, J,2233239.980.000.000.0039.98
Gonzalez, Molly,1637021.980.000.000.0021.98
Andersen, Latoya, J,290578.990.000.000.008.99
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Evans, Jesse,2191639.980.000.000.0039.98
Gonzalez, Morgan,130651700.990.000.000.001700.99
Parker, Caleb, A,2631813.980.000.000.0013.98
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Hayes, Hannah, J,2165656.970.000.000.0056.97
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Li, Brandon,2933973.960.000.000.0073.96
Campbell, Timothy,2584513.980.000.000.0013.98
Carter, Jose, H,12532235.720.000.000.00235.72
Watson, Michelle, H,262352181.560.000.002181.560.00
Ward, Stephanie, A,27429782.990.000.00782.990.00
Bell, Julia,216522646.060.000.002646.060.00
Johnson, Andrew, F,262942443.350.000.002443.350.00
Blue, Marcus, L,27550782.990.000.00782.990.00
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
Washington, Alexia,27613782.990.000.00782.990.00
Morgan, Brianna, D,111362380.470.000.002380.470.00
Davis, Richard, R,15549574.980.000.00574.980.00
Collins, Charles, B,29041628.450.000.000.00628.45
Alexander, Luke,290432447.050.000.002447.050.00
Martinez, Dominique,287888.990.000.008.990.00
Russell, Melanie, B,15478182.830.000.00167.8514.98
Thomas, Jessica,1684894.480.000.0094.480.00
Simmons, Anna, K,124512367.920.000.000.002367.92
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
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Alexander, Jordan,2141259.980.000.0059.980.00
Diaz, Faith, M,2236356.970.000.000.0056.97
Walker, Richard, T,19640224.550.000.000.00224.55
Brooks, Allison,146054750.010.000.000.004750.01
Bell, Timothy, J,2810178.980.000.0078.980.00
Ward, Kaylee, A,244154.990.000.004.990.00
Lobao, Alexandre,1892691.950.000.0091.950.00
Lopez, Bailey, R,185571179.470.000.001179.470.00
Perez, Amber, D,13318214.260.000.00116.9197.35
Peterson, Steven, L,234497.280.000.007.280.00
Adams, Katherine, M,235184.990.000.000.004.99
Washington, Emma,191231170.480.000.000.001170.48
Edwards, Logan,250024.990.000.000.004.99
Flores, Cassidy, L,233684.990.000.000.004.99
Wu, Randy, J,116472365.940.000.002365.940.00
Anderson, David, A,2209761.960.000.0061.960.00
Foster, Carson, L,16959135.350.000.00120.3714.98
Washington, Hailey, S,2588559.980.000.000.0059.98
Hill, Timothy,14871848.470.000.000.00848.47
Morris, Jessica,289678.990.000.008.990.00
Turner, Kaylee, M,16213154.540.000.000.00154.54
Murphy, Brianna, K,2834269.990.000.000.0069.99
Simmons, Caleb, M,121934833.030.000.002394.972438.06
Nelson, Katherine,2802178.980.000.000.0078.98
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Jones, Charles,22882101.450.000.000.00101.45
Anderson, Jasmine, A,235534.990.000.000.004.99
Nelson, Kevin,1476584.970.000.000.0084.97
Wilson, Jeremy, T,28341128.970.000.000.00128.97
Collins, Jose,2474839.980.000.0039.980.00
Flores, Morgan,19817118.940.000.0039.9878.96
Evans, Jordan,2920939.980.000.0039.980.00
Lewis, Morgan,17410168.740.000.000.00168.74
Wang, Zachary,2214489.970.000.000.0089.97
Bryant, Rachel,220197.280.000.007.280.00
Peterson, Isabella,2808039.980.000.0039.980.00
Martin, Jeremiah, E,173451764.960.000.000.001764.96
James, Zoe, R,14611304.550.000.000.00304.55
Sandberg, Chase,2190475.970.000.000.0075.97
Stewart, Lucas, J,2934198.970.000.000.0098.97
Brown, Christian,227554.990.000.000.004.99
Gonzales, Jose,2201439.980.000.000.0039.98
Moore, Jennifer, A,2175964.470.000.000.0064.47
Srini, Evelyn,16855150.950.000.000.00150.95
Howard, Danielle,28357133.490.000.000.00133.49
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Green, Xavier,2356739.980.000.000.0039.98
Russell, Arianna,22728149.930.000.00149.930.00
Harris, Anthony,2144721.980.000.000.0021.98
Nath, Alison, J,171161764.960.000.000.001764.96
Adams, Kyle, E,1881269.990.000.0069.990.00
Blue, Paige,2170313.980.000.000.0013.98
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Chen, Ethan,2054756.970.000.000.0056.97
Roberts, Rebecca,2800094.480.000.000.0094.48
Simmons, Nicole, S,2617729.480.000.000.0029.48
Adams, Mason, T,2052864.470.000.0064.470.00
Roberts, Wyatt,15900699.970.000.00699.970.00
Jackson, Victoria,270194.990.000.000.004.99
Gray, Mariah,222787.280.000.007.280.00
Smith, Hannah, J,2526554.980.000.0054.980.00
Edwards, Alexandra,133582386.940.000.000.002386.94
Harris, Noah,292562393.060.000.002393.060.00
Robinson, Lauren,2719668.490.000.0068.490.00
Peterson, Melissa, S,249954.990.000.004.990.00
Edwards, Hunter,2422067.930.000.000.0067.93
Watson, Erin, B,227724.990.000.004.990.00
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
Garcia, Xavier, M,2030071.970.000.000.0071.97
Clark, Destiny, L,28600119.980.000.00119.980.00
Russell, Nicole, M,182372318.960.000.000.002318.96
Jones, Kayla, C,1854194.260.000.0069.9924.27
Yuan, Brendan, S,247444.990.000.000.004.99
Gray, Marcus, T,183892401.450.000.000.002401.45
Lewis, Rachel, J,14900839.480.000.000.00839.48
Lee, Samantha, B,2737878.980.000.000.0078.98
Morgan, Isabella, L,28602144.470.000.000.00144.47
Mohamed, Samantha, A,292772419.060.000.002419.060.00
Gonzales, Cameron, L,2900569.990.000.0069.990.00
Hughes, Caroline, C,2830278.980.000.0078.980.00
Moreno, Lance, A,2922939.980.000.000.0039.98
Brooks, Steven, C,14877889.470.000.000.00889.47
Flores, Miguel,1975077.250.000.000.0077.25
Roberts, Amanda,171752334.980.000.000.002334.98
Williams, Destiny, S,15881564.990.000.00564.990.00
Richardson, Erin, R,1633188.850.000.0088.850.00
Sanchez, Stephanie,1786756.970.000.000.0056.97
Wilson, Emily,174002331.950.000.000.002331.95
Brooks, Evan,2340139.980.000.000.0039.98
Long, Sarah,173721729.970.000.000.001729.97
Sanchez, Jeremiah, E,2226521.980.000.0021.980.00
Hernandez, Sierra,27393123.980.000.00123.980.00
Hall, Grace, A,201894.990.000.000.004.99
Hernandez, Eduardo, J,18919300.940.000.00300.940.00
Kelly, Julia,2379867.930.000.0067.930.00
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Rogers, Bryce,174022304.980.000.000.002304.98
Martin, Joshua, A,276077.280.000.007.280.00
Torres, Dalton,235037.280.000.007.280.00
Smith, Nathan,217647.280.000.007.280.00
Lewis, Christopher,1875586.960.000.0086.960.00
Baker, Gabriella,174041709.980.000.000.001709.98
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Martin, Tyler, L,2772469.990.000.000.0069.99
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Hughes, Antonio, P,15913712.270.000.00712.270.00
Sanchez, Katherine, S,24399132.940.000.00132.940.00
Johnson, Jonathan,220597.280.000.007.280.00
Hill, Katherine, L,2670139.980.000.0039.980.00
Stewart, Alexandria,174761700.990.000.000.001700.99

Generated 2024-09-21 04:44:19.238 UTC