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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Washington, Victoria,235577.280.000.000.007.28
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Moreno, Marie,2773969.990.000.000.0069.99
Alexander, Caroline,176541759.970.000.000.001759.97
Jai, Jose,12944164.210.000.000.00164.21
Edwards, Angel, J,2912469.990.000.000.0069.99
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Clark, Emily, R,120862294.990.000.000.002294.99
Rowe, Todd,14586233.940.000.000.00233.94
Thomas, Megan,2907169.990.000.000.0069.99
Price, Oscar, G,11833240.010.000.000.00240.01
Watson, Marcus,2271585.480.000.000.0085.48
Peterson, Xavier, R,2645639.980.000.000.0039.98
Moore, Anthony, M,2473039.980.000.000.0039.98
Martinez, Carol, D,17656578.460.000.000.00578.46
Taylor, Natalie, M,14338828.740.000.000.00828.74
Hall, Kaylee, E,1975137.270.000.000.0037.27
Turner, Jeremiah, F,19207791.320.000.000.00791.32
Rubio, Kellie,27653128.970.000.000.00128.97
Watson, Michelle, H,262352181.560.000.002181.560.00
Bell, Julia,216522646.060.000.002646.060.00
Powell, Caleb, G,216132610.580.000.002049.10561.48
Winston, Ethan, R,216222612.060.000.002049.10562.96
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Powell, David, W,266151000.440.000.001000.440.00
Johnson, Andrew, F,262942443.350.000.002443.350.00
Parker, Jordan,216212616.860.000.002049.10567.76
Russell, Jessica,265721000.440.000.001000.440.00
Patterson, Grace, M,27560782.990.000.00782.990.00
Thomas, William, A,216142589.090.000.002049.10539.99
Sanchez, Trinity, J,262792181.560.000.002181.560.00
King, Jordan, C,110202316.970.000.002316.970.00
Wilson, Victoria, R,27536782.990.000.00782.990.00
Jackson, Edward,290422420.340.000.002420.340.00
Blue, Marcus, L,27550782.990.000.00782.990.00
Murphy, Chase, J,2472958.980.000.000.0058.98
Zhang, Robert,188551155.480.000.000.001155.48
Robinson, Dylan, L,1472481.530.000.000.0081.53
Foster, Kayla,1969371.950.000.000.0071.95
Torres, Victoria,17551160.920.000.000.00160.92
Allen, Sean, L,12097159.220.000.000.00159.22
Harris, Samantha, A,244874.990.000.000.004.99
Rogers, Jade, I,14332102.250.000.000.00102.25
Jones, Samantha,1831721.980.000.000.0021.98
Gray, Isabella,168203217.790.000.000.003217.79
Gonzales, Emily, P,21777180.980.000.000.00180.98
Perry, Justin, E,167583062.340.000.000.003062.34
Shan, Chad, M,2462112.940.000.000.0012.94
Richardson, Evan, J,15488165.300.000.000.00165.30
She, Shawn, J,16902141.980.000.000.00141.98
Brooks, Victoria, H,16479158.510.000.000.00158.51
Green, Mackenzie, C,280737.280.000.000.007.28
Alexander, Sarah,1941129.990.000.000.0029.99
Henderson, Abigail,2044139.980.000.000.0039.98
Griffin, Marcus,2075634.560.000.000.0034.56
Reed, Isaac, D,260747.280.000.000.007.28
Blue, Melanie, L,178611749.960.000.000.001749.96
Jones, Charles,22882101.450.000.000.00101.45
Butler, Dalton, A,133454759.510.000.000.004759.51
Allen, Jack, M,291372419.060.000.002419.060.00
Stewart, Alex, M,2008463.150.000.000.0063.15
Martinez, Dominique,287888.990.000.008.990.00
Yuan, Leonard, F,167911729.970.000.000.001729.97
Reed, Melanie, A,28160574.980.000.000.00574.98
Torres, Xavier,16840176.950.000.000.00176.95
Green, Eric,2738069.990.000.000.0069.99
Carter, Jesse, E,22141166.280.000.000.00166.28
Lal, Kyle,17360122.180.000.000.00122.18
Wilson, Jeremy, T,28341128.970.000.000.00128.97
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Garcia, Chloe, M,110372374.230.000.002374.230.00
Smith, Austin,13707149.050.000.000.00149.05
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Sánchez, Angela, C,176551750.980.000.000.001750.98
Robinson, Ian, D,138522294.990.000.000.002294.99
Jai, Luis, A,18320185.920.000.000.00185.92
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Powell, Katherine, C,14574177.600.000.000.00177.60
Barnes, Blake, A,178651789.970.000.000.001789.97
Edwards, Hailey,242584.990.000.000.004.99
Diaz, Trevor, B,2051954.960.000.000.0054.96
James, Bryce,13466133.450.000.000.00133.45
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Jones, Dalton, T,189512334.970.000.000.002334.97
Howard, Erin, L,183621725.210.000.000.001725.21
Johnson, Jacob, I,28069553.970.000.000.00553.97
Evans, Alexandra,2432268.490.000.000.0068.49
Bradley, Jocelyn,230227.280.000.000.007.28
Perez, Timothy, L,227304.990.000.000.004.99
Thomas, Matthew, K,13239185.700.000.000.00185.70
Ramirez, Garrett, M,173881763.970.000.000.001763.97
Sanchez, Jared, J,2585064.470.000.000.0064.47
Flores, Devin, A,15559172.040.000.0086.5685.48
Phillips, Andrea,1857383.740.000.000.0083.74
Peterson, Morgan, J,168341750.980.000.000.001750.98
Davis, Austin, E,133664749.040.000.000.004749.04
Thompson, Tyler,2750269.990.000.0069.990.00
Thomas, Jessica,1684894.480.000.0094.480.00
Prasad, Donald,15413318.920.000.00123.98194.94
Coleman, Luke, A,11723152.550.000.0069.9882.57
Wedge, Andrew, T,120604811.540.000.002418.482393.06
Murphy, Maria,160113657.260.000.000.003657.26
Turner, Kaylee, M,16213154.540.000.000.00154.54
Kennedy, Bridget,2202639.980.000.000.0039.98
Gonzales, Jordan,2368113.980.000.000.0013.98
Richardson, Nathaniel,120894710.030.000.002316.972393.06
Russell, Ian, T,2474613.980.000.0013.980.00
Barnes, Haley, J,2133939.980.000.0039.980.00
Phillips, Luis, G,207347.280.000.000.007.28
Thompson, Brianna, X,1864269.970.000.000.0069.97
Bryant, Jackson, J,2533239.980.000.000.0039.98
Ruiz, Philip,1807781.460.000.000.0081.46
Moore, Ian, L,2463939.980.000.000.0039.98
Thompson, Kayla, D,12363273.900.000.000.00273.90
Scott, Allison,14497804.480.000.000.00804.48
Gonzales, Trevor, K,16085143.530.000.0014.98128.55
Stewart, Gabriella,2803469.990.000.000.0069.99
Sanders, Sean,14341175.150.000.000.00175.15
Flores, Hannah,1952540.230.000.000.0040.23
Martin, James, M,1987077.250.000.000.0077.25
Patterson, Eric, A,2738478.980.000.000.0078.98
Perry, Eric,18314115.730.000.000.00115.73
Flores, Gabriel,271117.280.000.000.007.28
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Wilson, Emily,174002331.950.000.000.002331.95
Brooks, Evan,2340139.980.000.000.0039.98
Long, Sarah,173721729.970.000.000.001729.97
Gonzalez, Molly,1637021.980.000.000.0021.98
Brown, Dylan, J,124492351.960.000.000.002351.96
Butler, Jonathan,261804.990.000.000.004.99
Alexander, Jordan,2141259.980.000.0059.980.00
Washington, Hannah, A,291307.280.000.007.280.00
Alexander, Paige, W,1860459.250.000.0037.2721.98
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Hall, Taylor, J,169951735.980.000.000.001735.98
Jones, Michael, A,2210771.970.000.000.0071.97
Thomas, Jeremiah,183721760.470.000.000.001760.47
Patterson, Austin, O,270247.280.000.000.007.28
Ward, Eduardo, I,139162354.980.000.000.002354.98
Walker, Jacob, N,29027574.980.000.000.00574.98
Hernandez, Jamie,27283119.980.000.00119.980.00
Foster, Nicole, A,2349489.970.000.000.0089.97
Zhao, Clarence, R,1982671.970.000.0071.970.00
Lopez, Bailey, R,185571179.470.000.001179.470.00
Adams, Jennifer,153624745.020.000.000.004745.02
Alexander, Gavin, K,2932249.990.000.000.0049.99
Ruiz, Carrie, D,18644135.440.000.00100.4634.98
Kelly, Bailey, R,28284563.770.000.000.00563.77
Martinez, Joseph, E,2921459.980.000.0059.980.00
Wu, Randy, J,116472365.940.000.002365.940.00
Allen, Madeline,2924068.970.000.000.0068.97
Ward, Lucas, N,183631700.990.000.000.001700.99
Gomez, Briana, A,2878443.980.000.000.0043.98
Long, Rachel,2828339.980.000.000.0039.98
Bailey, Maria, C,1915034.980.000.000.0034.98
Baker, Gabriella,174041709.980.000.000.001709.98
Perez, Savannah, J,17036176.950.000.0056.97119.98
Foster, Isabelle,2637739.980.000.000.0039.98
Baker, Eduardo,180921789.450.000.000.001789.45
Chen, Ethan,2054756.970.000.000.0056.97
Stewart, Lucas, J,2934198.970.000.000.0098.97
Thomas, Zachary, D,28045119.980.000.000.00119.98
Phillips, Aaron, R,2494739.980.000.000.0039.98
Alexander, Logan, E,191161183.470.000.000.001183.47
Russell, Chloe, M,12763589.960.000.000.00589.96
Martin, Kellie, R,28195574.980.000.000.00574.98
McDonald, Aaron, J,27734119.980.000.000.00119.98
Brooks, Steven, C,14877889.470.000.000.00889.47
Roberts, Amanda,171752334.980.000.000.002334.98
Chen, Jack, E,17579151.430.000.000.00151.43
Washington, Ryan,2833294.480.000.000.0094.48
Sanchez, Stephanie,1786756.970.000.000.0056.97
Ward, Mariah, J,2158044.910.000.000.0044.91
Gray, Cody, C,144594775.010.000.000.004775.01
Baker, Allison,2649558.980.000.000.0058.98
Young, Courtney,176222374.980.000.000.002374.98
Rubio, Ruben, D,1887186.960.000.0086.960.00
Ross, Jose,2744178.980.000.0078.980.00
Harris, Jacob, G,2367939.980.000.0039.980.00
Moore, Logan,2634889.970.000.0089.970.00
Wang, Karen, P,1955331.970.000.000.0031.97
Reed, Michelle,2804669.990.000.000.0069.99
Perez, Jonathan, R,2345512.940.000.000.0012.94
Alexander, Julian,132172351.960.000.000.002351.96
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Rogers, Bryce,174022304.980.000.000.002304.98
Parker, Kaylee, M,2773878.980.000.000.0078.98
Chen, Luis, G,2125294.450.000.0094.450.00
Bell, Timothy, J,2810178.980.000.0078.980.00
Harris, Natalie,2368259.980.000.0059.980.00
Roberts, Robert, R,1898656.970.000.0056.970.00
Lobao, Alexandre,1892691.950.000.0091.950.00
Peterson, Steven, L,234497.280.000.007.280.00
Hayes, Gavin, A,194001179.470.000.000.001179.47
Powell, Ian,2608564.470.000.000.0064.47
Andersen, Latoya, J,290578.990.000.000.008.99
Butler, Jackson, J,183241735.980.000.000.001735.98
Prasad, Summer, M,2214339.980.000.0039.980.00
Anderson, David, A,2209761.960.000.0061.960.00
Stewart, Melissa,2517336.960.000.000.0036.96
James, Emma,127812329.980.000.000.002329.98
Simmons, Anna, K,124512367.920.000.000.002367.92
Foster, Jose, C,2878534.990.000.000.0034.99
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Bryant, Dakota, L,176132401.950.000.000.002401.95
Gonzales, Gavin,2448813.980.000.000.0013.98
Campbell, Timothy,2584513.980.000.000.0013.98
James, Morgan, E,2324539.980.000.000.0039.98
Patterson, Aaron, W,191131184.460.000.000.001184.46
Martin, Noah, A,1765775.970.000.0075.970.00
Martinez, Grace, M,17385208.690.000.0069.97138.72
Collins, Sierra,185491169.460.000.001169.460.00
Ramirez, Emma,29072128.970.000.000.00128.97
Martin, Christian, V,19709197.250.000.000.00197.25
Collins, Eduardo,139872329.990.000.000.002329.99
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Ross, Kelly,2607676.960.000.000.0076.96
Gonzalez, Logan, J,1748364.500.000.000.0064.50
Ortega, Sheila, M,2763239.980.000.000.0039.98
Rivera, Hailey, R,2079239.980.000.000.0039.98
Foster, Caleb,27112114.460.000.000.00114.46
Diaz, Faith, M,2236356.970.000.000.0056.97
Russell, Katherine,2877169.990.000.000.0069.99
Williams, Sydney, J,15334848.470.000.000.00848.47
Stewart, Alexandria,174761700.990.000.000.001700.99
Roberts, Hunter,282607.280.000.000.007.28
Perry, Lauren,248164.990.000.000.004.99
Carter, Jonathan,14578848.470.000.000.00848.47
Richardson, Charles, I,121144719.020.000.002325.962393.06
Adams, Gabriel, S,195271219.450.000.000.001219.45
Foster, Emma,15468436.350.000.00159.99276.36
Sanders, Lucas, W,268024.990.000.000.004.99
Long, Elizabeth, F,127822400.950.000.000.002400.95
Cook, Joan,235544.990.000.000.004.99
Robinson, Madison, W,183772394.970.000.000.002394.97
Sanchez, Rachel, C,267304.990.000.000.004.99
Rogers, Paige, H,17125539.990.000.000.00539.99
Perez, Katherine, J,2207924.270.000.000.0024.27
Chandra, Allen,2932753.990.000.000.0053.99
Nelson, Katherine,2802178.980.000.000.0078.98
Torres, Christina, M,20746119.950.000.000.00119.95
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Lee, Samantha, B,2737878.980.000.000.0078.98
White, Emma, N,16090604.960.000.000.00604.96
Cannata, Gabrielle, C,217254.990.000.000.004.99
Kelly, Erin, D,2351364.470.000.000.0064.47
Campbell, Natalie, L,115122319.990.000.000.002319.99
Robinson, Joseph,2814194.480.000.0094.480.00
Perry, Samuel,18811100.960.000.0069.9930.97

Generated 2024-11-10 08:34:30.887 UTC