[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_SUM2022202320242025
Griffin, Jennifer, B,14244154.960.000.000.00154.96
Hall, Elizabeth, L,13474339.480.000.000.00339.48
Young, Sierra, J,11619634.840.000.0034.99599.85
Allen, Sean, L,12097159.220.000.000.00159.22
Evans, Luke,2917615.230.000.000.0015.23
Diaz, Aidan, L,238464828.110.003578.270.001249.84
Zhang, Nathan, L,2910478.980.000.000.0078.98
Garcia, Anna, B,15572104.550.000.000.00104.55
Price, Nicole, N,15815141.830.000.000.00141.83
Brooks, Bryce,12061140.170.000.00112.2527.92
Simmons, Brittany,2923139.980.000.000.0039.98
Price, Marissa,15826160.740.000.000.00160.74
Butler, Morgan, E,2050068.490.000.000.0068.49
James, Christina,17409219.920.000.000.00219.92
Liu, Arturo,13222150.410.000.000.00150.41
Parker, Caleb, A,2631813.980.000.000.0013.98
Zeng, Jake,18054106.930.000.000.00106.93
Sharma, Thomas, A,18637121.940.000.000.00121.94
Jai, Logan, H,12031769.490.000.000.00769.49
Diaz, Richard, A,2668264.470.000.000.0064.47
Sharma, Jackson,16876151.840.000.000.00151.84
Johnson, Jonathan,220597.280.000.000.007.28
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
White, Tyler,14291258.440.000.0049.97208.47
Ross, Alexia, S,13231247.900.000.000.00247.90
Powell, Angela, R,12970471.110.000.000.00471.11
Simmons, Sarah, V,11500651.980.000.00118.96533.02
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Garcia, Brandon, V,244184329.610.003578.270.00751.34
Ramos, Kristi,151764703.030.000.000.004703.03
Griffin, Maria,1840763.250.000.000.0063.25
Davis, Thomas,167641760.470.000.000.001760.47
Sanders, Megan, A,15376136.240.000.000.00136.24
Long, Brandon, M,16110650.470.000.000.00650.47
Henderson, Eduardo, R,14359256.240.000.0078.98177.26
Shan, Chad, M,2462112.940.000.000.0012.94
Martin, Brandon, S,2169139.980.000.000.0039.98
Moore, Andrew, A,13944150.130.000.0036.27113.86
Murphy, Maria,160113657.260.000.000.003657.26
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Ortega, Javier, P,127852294.990.000.000.002294.99
Watson, Cole, A,217684118.263578.270.000.00539.99
Martin, Nicholas,233627.280.000.000.007.28
She, Shawn, J,16902141.980.000.000.00141.98
Martinez, Matthew, L,16009170.450.000.000.00170.45
Gonzales, Brittany,217104187.233578.270.000.00608.96
Turner, Timothy, C,14641119.860.000.000.00119.86
Yuan, Leonard, F,167911729.970.000.000.001729.97
King, Caleb, J,2898678.980.000.000.0078.98
Green, Isabella,26620699.10699.100.000.000.00
James, Julia,2497567.930.000.000.0067.93
Torres, Xavier,16840176.950.000.000.00176.95
Watson, Janet, S,2320859.980.000.000.0059.98
Moreno, Meredith, D,2228589.970.000.000.0089.97
Smith, Katherine, J,13197105.190.000.000.00105.19
Green, Mackenzie, C,280737.280.000.000.007.28
Washington, Caroline, D,231145996.320.003578.270.002418.05
Roberts, Thomas, J,219394163.243578.270.000.00584.97
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Morris, Mason, J,22349124.990.000.000.00124.99
Flores, Megan, N,230746021.820.003578.270.002443.55
Price, Miranda,26629699.100.00699.100.000.00
Lee, Don,188392384.970.000.000.002384.97
Flores, Julia, E,172631700.990.000.000.001700.99
Foster, Eric,229765971.330.003578.270.002393.06
Collins, Lucas, T,219214142.750.003578.270.00564.48
Miller, Eduardo,14561158.840.000.0049.97108.87
Baker, Sara, M,11827512.470.000.000.00512.47
Bryant, Isabella, L,229956060.500.003578.270.002482.23
Zukowski, Jake,220584118.260.003578.270.00539.99
Evans, Gabriel,2348789.970.000.000.0089.97
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Perez, Sydney, C,221174158.240.003578.270.00579.97
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Powell, Caleb, G,216132610.580.000.002049.10561.48
Flores, Zachary, H,233765314.250.003578.270.001735.98
Simmons, Jennifer,112621010.560.000.000.001010.56
Williams, Ryan, R,222475978.610.003578.270.002400.34
Jai, Hunter, M,28272111.950.000.000.00111.95
Powell, Vanessa,26630699.100.00699.100.000.00
Campbell, Lucas,2932953.990.000.000.0053.99
Johnson, James,234984.990.000.000.004.99
Alexander, Julia, J,15291889.470.000.000.00889.47
Rogers, Carlos,19645134.440.000.000.00134.44
Garcia, Benjamin, L,175951785.970.000.000.001785.97
She, Martha, E,222515971.330.003578.270.002393.06
Coleman, Dylan,27403132.970.000.000.00132.97
Bell, Gabrielle,223735976.320.003578.270.002398.05
Mitchell, Thomas, J,137112380.470.000.000.002380.47
King, Morgan,196811179.970.000.000.001179.97
Long, Natalie,14363192.340.000.000.00192.34
Howard, Morgan, T,229713578.270.003578.270.000.00
Martinez, Hannah, M,246664370.610.003578.270.00792.34
Martinez, Wyatt, R,228815997.330.003578.270.002419.06
Hayes, Logan, J,19026113.240.000.000.00113.24
Miller, Chloe, V,228936056.510.003578.270.002478.24
Martinez, Carol, D,17656578.460.000.000.00578.46
Peterson, Brian,12892419.470.000.000.00419.47
Smith, John,198555709.960.003399.990.002309.97
Walker, Hunter,271007.280.000.000.007.28
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Griffin, Xavier,228775962.340.003578.270.002384.07
Russell, Caleb,23552103.480.000.000.00103.48
Anderson, Lucas,2926639.980.000.000.0039.98
Powell, Katherine, C,14574177.600.000.000.00177.60
Ramirez, Abigail, S,1585974.140.000.000.0074.14
Hayes, Dalton, C,188822322.280.000.000.002322.28
Patterson, Nicole,1972937.270.000.000.0037.27
Reed, Melanie, A,28160574.980.000.000.00574.98
Stewart, Jessica,16097103.550.000.0046.5856.97
Edwards, Hailey,242584.990.000.000.004.99
Hernandez, Jonathan, J,1901465.950.000.000.0065.95
Nelson, Jose,19217185.020.000.000.00185.02
Thomas, Dylan,198737.280.000.000.007.28
Morgan, Jada, A,11520702.990.000.000.00702.99
Wright, Robert, C,158894848.030.000.000.004848.03
Smith, Megan, J,2671668.970.000.000.0068.97
Walker, John, M,2858969.990.000.000.0069.99
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Lu, Alejandro,2562039.980.000.000.0039.98
Barnes, Blake, A,178651789.970.000.000.001789.97
Suarez, Juan, R,167631700.990.000.000.001700.99
Reed, Megan, A,181181750.980.000.000.001750.98
Young, Kaitlyn, J,2506213.980.000.000.0013.98
Bell, Garrett, J,14265161.230.000.000.00161.23
Watson, Olivia, S,1386093.850.000.0014.9878.87
Taylor, Madison, A,11802215.290.000.000.00215.29
Reed, Judith, D,2534759.980.000.000.0059.98
Alexander, Edward, E,18524195.950.000.000.00195.95
Henderson, Caroline,2008256.970.000.000.0056.97
Torres, Mariah,16380195.950.000.000.00195.95
Diaz, Luke,12054402.530.000.00124.99277.54
Watson, Victoria,16125588.960.000.000.00588.96
Bennett, Maria, G,229837.280.000.000.007.28
Powell, Elijah, E,231135997.330.003578.270.002419.06
Morris, Richard,2007039.980.000.000.0039.98
Stewart, Gabriella,2803469.990.000.000.0069.99
Powell, Jack, J,1841156.960.000.000.0056.96
Lopez, Katelyn,11820232.710.000.0060.47172.24
Walker, Emma, M,2520998.960.000.000.0098.96
Thompson, Devin,207084406.400.000.002071.422334.98
Powell, Lauren, E,1966275.970.000.000.0075.97
Foster, Aaron,155664912.470.000.000.004912.47
Alexander, Taylor,17482146.940.000.000.00146.94
Torres, Haley, W,232834828.110.003578.270.001249.84
Hayes, Brittany,13941286.820.000.000.00286.82
Harris, Megan,232814828.110.003578.270.001249.84
Thomas, Samantha,2169093.970.000.000.0093.97
Ye, Alisha, J,220084141.230.003578.270.00562.96
Campbell, Gabriella,188411145.480.000.000.001145.48
Evans, Kaylee,19642133.540.000.000.00133.54
Sara, Ivan, L,2509067.930.000.000.0067.93
Thompson, Abigail,243324816.090.003578.270.001237.82
Smith, Lucas, P,1809064.910.000.000.0064.91
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Cooper, Paige,14119148.940.000.000.00148.94
Roberts, Noah, S,2704268.490.000.000.0068.49
Lewis, Ryan, A,203124.990.000.000.004.99
Coleman, Jose, S,253494.990.000.000.004.99
Patterson, Alexis,213484392.020.000.002049.102342.92
Diaz, Thomas, O,16020595.960.000.000.00595.96
Green, Gabriella, C,2803569.990.000.000.0069.99
Shan, Gabriel, T,2773169.990.000.000.0069.99
Griffin, Jack, L,1768632.280.000.000.0032.28
Cooper, Brianna,2592513.980.000.000.0013.98
Lewis, Zachary, L,14760167.260.000.000.00167.26
Alexander, Nathan, A,187951198.970.000.000.001198.97
Hall, Amber,20106131.950.000.000.00131.95
Patterson, Austin, O,270247.280.000.000.007.28
Adams, Miguel,11659213.520.000.000.00213.52
He, Micah,2740169.990.000.000.0069.99
Rogers, Sean, G,18685124.460.000.000.00124.46
Perry, Christian,246714354.600.003578.270.00776.33
Johnson, Anthony, D,270224.990.000.000.004.99
Carter, Jason,11724210.090.000.0071.58138.51
Murphy, Juan, T,246463578.270.003578.270.000.00
Coleman, Joan, W,2669964.470.000.000.0064.47
Perez, Jonathan, R,2345512.940.000.000.0012.94
Cooper, Stephanie,249762181.560.002181.560.000.00
Hall, Charles,234764.990.000.000.004.99
Blanco, Armando, F,139182397.950.000.000.002397.95
Green, Sophia, E,249772181.560.002181.560.000.00
Ward, Ian,12056213.920.000.000.00213.92
Cox, Julia, A,206703228.570.000.002049.101179.47
Adams, Haley, M,247862443.350.002443.350.000.00
Scott, Gabrielle,270614.990.000.000.004.99
Howard, Danielle,28357133.490.000.000.00133.49
Watson, Kimberly, A,201883226.900.002071.420.001155.48
Sandberg, Nicole, M,12077144.690.000.0089.4755.22
Butler, Jackson, J,183241735.980.000.000.001735.98
Huang, Kristen,251002443.350.002443.350.000.00
Brown, Samantha, G,2514739.980.000.000.0039.98
Jones, Alexander, I,2002180.960.000.000.0080.96
White, Jennifer, S,27027782.990.00782.990.000.00
Washington, Lauren, R,229985329.250.003578.271750.980.00
Lal, Jonathan,2009671.460.000.000.0071.46
Hughes, Stephanie,263161000.440.000.001000.440.00
Clark, William,2902169.990.000.000.0069.99
Foster, Edward, R,18355150.950.000.000.00150.95
Cox, Lucas, J,253932443.350.000.002443.350.00
Shan, Benjamin,235663578.270.003578.270.000.00
Gray, Jesse,14626197.040.000.000.00197.04
Clark, Anthony,27071782.990.000.00782.990.00
Carter, Madeline, A,2752269.990.000.000.0069.99
Washington, Adam, G,2543713.980.000.000.0013.98
Young, Savannah,259712749.320.000.002181.56567.76
Brown, Anthony, J,19399151.430.000.000.00151.43
Collins, Eduardo,139872329.990.000.000.002329.99
Coleman, Lucas, A,27060782.990.000.00782.990.00
Bryant, Isabelle,233974828.110.003578.270.001249.84
Brown, Dalton, N,218134118.260.003578.270.00539.99
Coleman, Logan,1868691.950.000.000.0091.95
Smith, Justin, P,1982721.980.000.000.0021.98
Chen, David,2720839.980.000.000.0039.98
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Ward, Jade, D,14661195.020.000.000.00195.02
Martin, Alfredo, P,2148039.980.000.000.0039.98
Hill, Haley, J,161033142.320.000.000.003142.32
Anderson, Megan, A,238594153.250.003578.27574.980.00
Kapoor, Preston,2143156.970.000.000.0056.97
Miller, Sydney, A,134404818.530.000.000.004818.53
Martin, Brianna, M,235834829.390.003578.270.001251.12
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Gonzalez, James, M,188421155.480.000.000.001155.48
Foster, Olivia,238063578.270.003578.270.000.00
Williams, Sydney, J,15334848.470.000.000.00848.47
Martinez, Kristina, S,2134529.930.000.000.0029.93
Long, Kaitlyn,233964891.610.003578.270.001313.34
Phillips, Adam, R,227484188.240.003578.270.00609.97
Reed, Mariah,263731565.910.000.001000.44565.47
Rodriguez, Joshua, A,235114843.110.003578.270.001264.84
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Peterson, Christina,2897694.480.000.000.0094.48
Kelly, Trinity,2609515.230.000.000.0015.23
Clark, Miguel, D,169872414.990.000.000.002414.99
Bennett, Jennifer, G,13708123.940.000.000.00123.94
Turner, Morgan,11823178.470.000.000.00178.47
Murphy, Chase, J,2472958.980.000.000.0058.98
Thomas, Isabella, M,27265782.990.000.00782.990.00
Cooper, Christina, C,265121000.440.000.001000.440.00
Ross, Rachel, C,206693169.590.000.002049.101120.49
Perry, Marcus, L,206563245.900.000.002071.421174.48
Evans, James, C,206654408.560.000.002049.102359.46
Anderson, Ashley,206803219.580.000.002049.101170.48
Diaz, Hunter, S,27242782.990.000.00782.990.00
Thompson, Joshua, F,259992181.560.000.002181.560.00

Generated 2025-12-19 03:50:09.735 UTC