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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
White, Abigail, T,15866145.820.000.0038.88106.94
Chavez, Kara, P,13285214.350.000.0012.94201.41
Jenkins, Megan, R,12074261.380.000.000.00261.38
Miller, Alexis, A,12196124.930.000.000.00124.93
Umeda, Masaki,16717233.810.000.000.00233.81
Moore, Matthew, W,13267109.950.000.000.00109.95
Garcia, Chloe, M,110372374.230.000.002374.230.00
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Stewart, Timothy, F,13199105.190.000.0022.9382.26
White, Tyler,14291258.440.000.0049.97208.47
Brooks, Bryce,12061140.170.000.00112.2527.92
Howard, Natalie,1349154.960.000.0014.9839.98
Prasad, Donald,15413318.920.000.00123.98194.94
Lopez, Isaiah,18968151.430.000.000.00151.43
Jones, Joshua,184012294.990.000.000.002294.99
Young, Adam,12984200.200.000.00107.2692.94
Carter, Sydney,12959203.920.000.000.00203.92
Miller, Eduardo,14561158.840.000.0049.97108.87
Alexander, Elijah,11738331.680.000.00141.73189.95
Taylor, Brianna,17027230.900.000.00145.4285.48
Foster, Antonio,12795108.540.000.0066.2642.28
Hill, Alexandra, K,15172215.450.000.0036.27179.18
Shan, Logan,1867760.960.000.0029.9930.97
Hall, Natalie, A,230704.990.000.004.990.00
Diaz, Katherine, P,115262376.960.000.002376.960.00
Serrano, Albert, E,133284708.020.000.000.004708.02
Reed, Judith, D,2534759.980.000.000.0059.98
Rubio, Ruben, D,1887186.960.000.0086.960.00
Alexander, Jordan,2141259.980.000.0059.980.00
Ross, Jose,2744178.980.000.0078.980.00
Washington, Hannah, A,291307.280.000.007.280.00
Gonzales, Trevor, K,16085143.530.000.0014.98128.55
Lopez, Katelyn,11820232.710.000.0060.47172.24
Ramirez, Brian, M,116182369.960.000.002369.960.00
Bell, Timothy, J,2810178.980.000.0078.980.00
Henderson, Eduardo, R,14359256.240.000.0078.98177.26
Lobao, Alexandre,1892691.950.000.0091.950.00
Xu, Louis,2010466.530.000.0066.530.00
Hill, Carlos,12919257.880.000.00158.9398.95
Jones, Natalie, A,11845197.200.000.0082.26114.94
Wright, Kyle,2371626.970.000.000.0026.97
Evans, Luke,2917615.230.000.000.0015.23
Price, Nicole, N,15815141.830.000.000.00141.83
Phillips, Miguel,2049812.940.000.000.0012.94
Rubio, Javier, E,1972664.240.000.0064.240.00
Martinez, Joseph, E,2921459.980.000.0059.980.00
Campbell, Alex,119844730.320.000.002329.982400.34
Anderson, David, A,2209761.960.000.0061.960.00
Morris, Jessica,289678.990.000.008.990.00
Taylor, Tyler, A,12032614.960.000.00614.960.00
Rogers, Andrea, L,14328308.660.000.00112.95195.71
Robinson, Joseph,2814194.480.000.0094.480.00
Johnson, Xavier, R,2325539.980.000.0039.980.00
Walker, Ian,16771104.550.000.0054.5849.97
Taylor, Christian,2076456.760.000.000.0056.76
Smith, Justin, P,1982721.980.000.000.0021.98
Taylor, Edward, C,17442319.880.000.00230.9088.98
Scott, Kaitlyn, A,12159218.910.000.00133.9684.95
Jackson, Brianna,1537797.910.000.0074.9822.93
Nelson, Jose,19217185.020.000.0091.9593.07
Diaz, Brandon,236764.990.000.004.990.00
Martin, Samuel,15874225.440.000.0069.99155.45
James, Maria,1624391.970.000.0069.9921.98
Hill, Eric, G,2525667.930.000.0067.930.00
Bryant, Rachel,220197.280.000.007.280.00
Li, Jordan,17026261.390.000.00261.390.00
Wang, Austin, A,1463284.970.000.009.9974.98
Lewis, Isabella,2624267.930.000.000.0067.93
Butler, Morgan, E,2050068.490.000.000.0068.49
Simmons, Dakota, T,14110819.460.000.000.00819.46
Sharma, Jackson,16876151.840.000.000.00151.84
Foster, Trevor, J,2896469.990.000.000.0069.99
Bryant, Nathan,2145059.980.000.000.0059.98
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Hall, Kyle, J,1749169.970.000.000.0069.97
Garcia, Jonathan,1888386.960.000.0029.9956.97
Sanders, Megan, A,15376136.240.000.000.00136.24
Richardson, Charles, I,121144719.020.000.002325.962393.06
Perez, Charles,266937.280.000.007.280.00
Davis, Dylan,15556588.960.000.00588.960.00
Foster, Carson, L,16959135.350.000.00120.3714.98
Sanders, Alexa, E,217414127.253578.270.00548.980.00
Price, Miranda,26629699.10699.100.000.000.00
Long, Gabrielle,198305765.923374.990.000.002390.93
Long, Natalie,14363192.340.000.000.00192.34
Sanchez, Martin, E,216317.280.000.000.007.28
Martin, Lucas, L,221144183.233578.270.000.00604.96
Powell, Vanessa,26630699.100.00699.100.000.00
Watson, Shelby, J,14911867.970.000.000.00867.97
Campbell, Hunter,17422174.920.000.000.00174.92
Reed, Bryan,18884133.930.000.000.00133.93
Turner, Sean,227324133.240.003578.270.00554.97
Brooks, Makayla,222526047.320.003578.270.002469.05
Perry, Oscar,227856029.570.003578.272451.300.00
Thomas, Thomas,216292624.080.000.002049.10574.98
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Martinez, Wyatt, R,228815997.330.003578.270.002419.06
Long, Julia, R,228895971.330.003578.270.002393.06
Stewart, Hailey,229036054.220.003578.270.002475.95
Gill, Beth,199975814.980.003374.990.002439.99
Bryant, Kyle,231644807.100.003578.271228.830.00
Thompson, Ethan,199894495.480.003374.990.001120.49
Washington, Lauren, R,229985329.250.003578.271750.980.00
Torres, Haley, W,232834828.110.003578.270.001249.84
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Alexander, Ashley, J,200074495.480.003374.990.001120.49
Coleman, Benjamin, F,234865343.230.003578.270.001764.96
Martin, Brianna, M,235834829.390.003578.270.001251.12
Jones, Madison,246614181.760.003578.27603.490.00
Bennett, Seth,244933578.270.003578.270.000.00
Perry, Christian,246714354.600.003578.270.00776.33
Washington, Ian, M,246644368.580.003578.270.00790.31
Flores, Logan, K,14631848.470.000.000.00848.47
Adams, Haley, M,247862443.350.002443.350.000.00
Richardson, Victoria, C,248172181.560.002181.560.000.00
Ross, Haley, T,253612443.350.002443.350.000.00
Huang, Kristen,251002443.350.002443.350.000.00
Price, Stephanie,258922443.350.002443.350.000.00
Price, Jocelyn, D,258752443.350.002443.350.000.00
Flores, Jordyn,252882721.550.002181.560.00539.99
Campbell, Isabella, C,203503226.900.002071.420.001155.48
Sharma, Samuel,27725119.980.000.000.00119.98
Harris, Edward,27062782.990.00782.990.000.00
Williams, Ian, M,175581750.470.000.000.001750.47
Sanders, Alexandra,259112181.560.002181.560.000.00
Russell, Fernando,27084782.990.000.00782.990.00
Hayes, Arianna,259912845.520.000.002181.56663.96
Flores, Stephanie,259922721.550.000.002181.56539.99
She, Kenneth,16096212.010.000.0080.96131.05
Rogers, Sean, G,18685124.460.000.000.00124.46
Henderson, Caroline,2008256.970.000.000.0056.97
Cook, Bryce,2864069.990.000.000.0069.99
Alexander, Aidan,17387148.190.000.0094.2453.95
Torres, Pedro, E,16958168.020.000.00153.0414.98
Reed, Erin, I,14353128.840.000.0074.9853.86
Walker, Hunter,271007.280.000.000.007.28
Deng, Damien, A,16873578.460.000.000.00578.46
Torres, Mariah,16380195.950.000.000.00195.95
Powell, Lauren, E,1966275.970.000.000.0075.97
Richardson, Olivia,204683169.590.000.002049.101120.49
Hill, Sydney,264821000.440.000.001000.440.00
Griffin, Cassidy,264961000.440.000.001000.440.00
Wilson, Christian,27085782.990.000.00782.990.00
Thomas, Isabella, M,27265782.990.000.00782.990.00
Evans, James, C,206654408.560.000.002049.102359.46
Roberts, Wyatt,15900699.970.000.00699.970.00
Richardson, Erin, R,1633188.850.000.0038.8849.97
Martin, Brandon, S,2169139.980.000.000.0039.98
Coleman, Joan, W,2669964.470.000.000.0064.47
Moore, Hunter,14897196.270.000.0071.58124.69
Nelson, James, L,245257.280.000.007.280.00
Stewart, Allison, R,18826166.430.000.0069.9996.44
Griffin, Isabelle,249864.990.000.000.004.99
Collins, Xavier, C,16646250.910.000.000.00250.91
Powell, Jordyn, K,153914828.010.000.000.004828.01
Baker, Robert, A,273007.280.000.007.280.00
Smith, Hannah, J,2526554.980.000.0054.980.00
Walker, Jasmine,134604693.040.000.000.004693.04
Morgan, Isaiah,18978118.730.000.000.00118.73
Ward, Jade, D,14661195.020.000.000.00195.02
Campbell, Gabriella,188411145.480.000.000.001145.48
Lee, Ethan, J,223597.280.000.000.007.28
Martinez, Jonathan,1330366.250.000.000.0066.25
Robinson, Lauren,2719668.490.000.0068.490.00
Thomas, Wyatt, R,12431154.540.000.0094.9859.56
Gonzalez, Jeremiah,17468128.910.000.0071.9556.96
Smith, Samuel, D,2308349.900.000.000.0049.90
Walker, Brandon, J,159164793.270.000.000.004793.27
Parker, Eduardo, M,12939169.420.000.0077.9291.50
Smith, Nathan,217647.280.000.007.280.00
Jenkins, Dakota, D,2067964.470.000.0064.470.00
Bell, Danielle,140414765.020.000.000.004765.02
Price, Riley, R,139094764.020.000.000.004764.02
Lewis, Ryan, A,203124.990.000.000.004.99
Thompson, Kayla, D,12363273.900.000.0049.97223.93
Foster, Edward, R,18355150.950.000.000.00150.95
Scott, Sean, F,2475539.980.000.000.0039.98
Foster, Isabel, M,2174571.950.000.000.0071.95
Ramirez, Makayla, L,1750998.720.000.000.0098.72
Carter, Savannah, M,120902350.960.000.000.002350.96
Wilson, Daniel, K,142814746.300.000.000.004746.30
Sanders, Hailey,19647282.040.000.000.00282.04
Morgan, Juan, C,1882191.970.000.000.0091.97
Zhang, Nathan, L,2910478.980.000.000.0078.98
Jai, Logan, H,12031769.490.000.000.00769.49
Alexander, Lauren,189502351.960.000.000.002351.96
Anderson, Isabella,137432349.980.000.000.002349.98
Phillips, Kyle,12158202.200.000.000.00202.20
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Bradley, Alexandria,176911779.470.000.000.001779.47
Chen, Jonathan, G,13096200.690.000.000.00200.69
Lee, Don,188392384.970.000.000.002384.97
Evans, Gabriel,2348789.970.000.000.0089.97
Henderson, Isabelle, K,163662563.350.000.000.002563.35
Brooks, Ian, W,2829064.470.000.000.0064.47
Wagner, Alexandra, E,2324439.980.000.000.0039.98
Richardson, Brian,2860878.980.000.000.0078.98
Lee, Alexander, S,18356149.910.000.000.00149.91
Perry, Natalie,1712669.990.000.000.0069.99
Diaz, Richard, A,2668264.470.000.000.0064.47
Hayes, Hannah, J,2165656.970.000.000.0056.97
Thomas, David,168363193.790.000.000.003193.79
Peterson, Christina,2897694.480.000.000.0094.48
Harris, Matthew,14330806.760.000.000.00806.76
Bell, Christina,2609939.980.000.000.0039.98
Alexander, Julia, J,15291889.470.000.000.00889.47
Coleman, Dylan,27403132.970.000.000.00132.97
Griffin, Haley, L,1892582.180.000.000.0082.18
Phillips, Devin,18759112.060.000.000.00112.06
Phillips, Jack, R,259952443.350.000.002443.350.00
Foster, Deb,215012661.400.000.002661.400.00
Coleman, Ashley,27297782.990.000.00782.990.00
Mitchell, Maria, D,27404782.990.000.00782.990.00
Coleman, Vanessa,215892589.090.000.002049.10539.99
Collins, Nathan, F,197041143.460.000.000.001143.46
Adams, Mackenzie, A,14640812.420.000.000.00812.42
Smith, Tyler, J,2034156.970.000.000.0056.97
Hall, Luke, E,14745902.460.000.000.00902.46
Anderson, Lucas,2926639.980.000.000.0039.98
Russell, Jacqueline,18391100.960.000.0078.9821.98
Roberts, Amber, W,215822638.060.000.002049.10588.96
Watson, Michelle, H,262352181.560.000.002181.560.00
Johnson, Andrew, F,262942443.350.000.002443.350.00
Thomas, Richard,27557782.990.000.00782.990.00
Patterson, Grace, M,27560782.990.000.00782.990.00
Garcia, Lucas,27545782.990.000.00782.990.00
Blue, Marcus, L,27550782.990.000.00782.990.00
Washington, Alexia,27613782.990.000.00782.990.00
Bryant, Zachary,216552648.070.000.002648.070.00
Jackson, Edward,290422420.340.000.002420.340.00
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Lu, Alejandro,2562039.980.000.000.0039.98
Price, Lauren, J,14079184.740.000.0037.29147.45
Russell, Melanie, B,15478182.830.000.00167.8514.98
Martin, Madison, C,2049271.970.000.0071.970.00
Washington, Alexis,1978146.260.000.007.2838.98
Bryant, Samantha,18345115.470.000.000.00115.47
Murphy, Caitlin, L,14910839.480.000.000.00839.48
Rogers, Shelby,11712127.800.000.0042.5985.21
Butler, Trevor,2741569.990.000.0069.990.00
Peterson, Jessica, M,11868247.010.000.0061.97185.04
Coleman, Miguel, D,2740069.990.000.0069.990.00
Wright, Jennifer,2650559.980.000.0059.980.00
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Hill, Fernando,247634.990.000.000.004.99
Cook, Megan, J,2029956.970.000.000.0056.97
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Hernandez, Jamie,27283119.980.000.00119.980.00
Lopez, Bailey, R,185571179.470.000.001179.470.00
Flores, Devin, A,15559172.040.000.0086.5685.48

Generated 2025-10-31 21:09:51.113 UTC