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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Wilson, Andrew, R,182362414.990.000.000.002414.99
Sanders, Alexa, E,217414127.253578.270.000.00548.98
Tang, Carl,2123832.270.000.000.0032.27
Long, Xavier,112512318.960.000.000.002318.96
James, Sara,198023374.993374.990.000.000.00
Morris, Paige, W,220414167.233578.270.000.00588.96
Perez, Dalton,110911125.360.000.0067.971057.39
Mitchell, Lucas, C,198294533.450.003374.990.001158.46
Martin, Lucas, L,221144183.230.003578.270.00604.96
Mitchell, Jonathan, L,221095971.330.003578.272393.060.00
Ross, Isabelle, D,18554155.450.000.000.00155.45
Watson, Shelby, J,14911867.970.000.000.00867.97
Patterson, Hailey, I,112231155.900.000.00103.961051.94
Simmons, Mariah,266831270.820.00699.100.00571.72
Dominguez, Meghan,14370122.560.000.000.00122.56
Diaz, Luis, D,11203801.770.000.000.00801.77
Brooks, Paige,222325985.310.003578.270.002407.04
Campbell, Hunter,17422174.920.000.000.00174.92
Brown, Nicholas, S,11506675.640.000.000.00675.64
Ross, Anna, D,15494275.440.000.000.00275.44
Turner, Sean,227324133.240.003578.270.00554.97
Brown, Isabella, L,266921266.860.00699.100.00567.76
Carter, Marcus, l,2147131.970.000.000.0031.97
Rodriguez, Brianna, J,222674167.230.003578.270.00588.96
Henderson, Gabrielle, B,186031205.470.000.000.001205.47
Brooks, Makayla,222526047.320.003578.270.002469.05
Thomas, Thomas,216292624.080.000.002049.10574.98
Turner, Courtney, A,229753578.270.003578.270.000.00
Taylor, Ryan,170251709.980.000.000.001709.98
Long, Julia, R,228895971.330.003578.270.002393.06
Hughes, Samantha,2721564.470.000.000.0064.47
Thomas, Alexandra, C,231724809.390.003578.271231.120.00
Richardson, Caitlin, T,230576021.820.003578.270.002443.55
Sanders, Chloe, C,231375314.250.003578.270.001735.98
Gill, Beth,199975814.980.003374.990.002439.99
Torres, Erin,1218287.250.000.000.0087.25
James, Juan,232674862.090.003578.270.001283.82
Flores, Logan, K,14631848.470.000.000.00848.47
Harris, Emily, P,1986298.480.000.000.0098.48
James, Jeremiah, S,11661287.700.000.000.00287.70
Sanchez, Lucas, L,233514828.110.003578.270.001249.84
Yang, Jordan, K,14458133.950.000.000.00133.95
Wilson, Fernando,16643126.960.000.000.00126.96
Mitchell, Savannah,261153052.800.000.002443.35609.45
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Jackson, Joseph, R,235925279.260.003578.270.001700.99
Rodriguez, Anthony, G,238294802.110.003578.270.001223.84
Harris, Isabella,17119214.900.000.000.00214.90
Wilson, Hunter, R,2723013.980.000.000.0013.98
Bryant, Connor,238424828.110.003578.270.001249.84
Young, Julia, J,274144.990.000.000.004.99
Washington, Vanessa,238194802.110.003578.270.001223.84
Rogers, Amanda, A,13920266.970.000.000.00266.97
Campbell, Kevin, S,121774811.500.000.000.004811.50
Ms., Coleman, Abigail, C,238684829.390.003578.270.001251.12
Thompson, Jose,237314828.110.003578.270.001249.84
Griffin, Julian, M,113284718.040.000.002319.992398.05
Sanders, Melissa, R,242844837.340.003578.270.001259.07
Fernandez, Darren,2899278.980.000.000.0078.98
Campbell, Evan, W,243424828.110.003578.270.001249.84
Thompson, Kaitlyn, L,12430223.930.000.000.00223.93
Navarro, Jerome, B,11519717.280.000.000.00717.28
Williams, Ethan,243094793.120.003578.270.001214.85
Hughes, Luke, I,270141274.080.00699.100.00574.98
Patterson, Maria, G,1333094.950.000.000.0094.95
Mitchell, Katelyn, A,244964349.610.003578.270.00771.34
Washington, Kayla, E,14655174.960.000.000.00174.96
Price, Isabelle,201825749.970.003374.990.002374.98
She, Kenneth,16096212.010.000.000.00212.01
Prasad, Molly,243924329.610.003578.270.00751.34
Fernandez, Cesar,200355694.980.003374.990.002319.99
Long, Morgan, H,213522625.390.000.002071.42553.97
Rivera, Caitlin, L,261132730.540.000.002181.56548.98
Parker, Morgan, S,1677236.960.000.000.0036.96
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Robinson, Abigail, R,183792362.270.000.000.002362.27
Murphy, Olivia, V,202063204.580.002049.100.001155.48
Hughes, Justin, M,181222439.990.000.000.002439.99
Perry, Ryan,132494795.340.000.000.004795.34
Griffin, Madison, A,250932181.560.002181.560.000.00
Cooper, Ariana,17348205.420.000.000.00205.42
Lewis, Brianna, H,14282166.240.000.000.00166.24
Gray, Brianna,249603008.820.002443.350.00565.47
Hughes, Julia,250612443.350.002443.350.000.00
Parker, Blake,15008170.530.000.000.00170.53
Zhao, Karen, L,254082735.530.002181.560.00553.97
Garcia, Patricia,11651226.430.000.000.00226.43
Price, Stephanie,258922443.350.000.002443.350.00
Thomas, Emily,2180339.980.000.000.0039.98
Carter, Luis, E,258832443.350.000.002443.350.00
Morgan, Timothy,14633242.500.000.000.00242.50
Murphy, Dalton, N,27043782.990.000.00782.990.00
Hernandez, Marcus,185952329.990.000.000.002329.99
Campbell, Isabella, C,203503226.900.000.002071.421155.48
Brown, Benjamin, D,151874725.320.000.000.004725.32
Howard, Isaiah,259813018.330.000.002443.35574.98
Madan, Carmen, V,155674720.270.000.000.004720.27
Sanders, Alexandra,259112181.560.000.002181.560.00
Blanco, Randall,263211554.410.000.001000.44553.97
Flores, Stephanie,259922721.550.000.002181.56539.99
Edwards, Connor,16950211.010.000.000.00211.01
Jai, Kevin,1983678.960.000.000.0078.96
Stewart, Julia, L,129022329.980.000.000.002329.98
Russell, Xavier,12964119.950.000.000.00119.95
Murphy, Shelby,244894.990.000.000.004.99
Hill, Fernando,247634.990.000.000.004.99
Deng, Damien, A,16873578.460.000.000.00578.46
Serrano, Albert, E,133284708.020.000.000.004708.02
Anderson, Emma, A,185801170.480.000.000.001170.48
Perez, Jordan, A,292674.990.000.000.004.99
Bradley, Melanie, G,133434720.270.000.000.004720.27
Smith, Andrew,1472387.570.000.000.0087.57
Russell, Megan,16220562.960.000.000.00562.96
Kelly, Haley,15511128.560.000.000.00128.56
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Griffin, Stephanie, L,2826127.920.000.000.0027.92
Washington, Elijah, L,250164.990.000.000.004.99
Martinez, Andrew, C,11530523.810.000.0078.48445.33
Yuan, Carly,19839194.960.000.000.00194.96
Stewart, Grace, H,247737.280.000.000.007.28
Wright, Kyle,2371626.970.000.000.0026.97
King, Aaron, L,117394758.030.000.002359.982398.05
Isla, Julian, A,13732108.960.000.004.99103.97
Cook, Seth,2301064.470.000.000.0064.47
Coleman, Isabel, S,12530337.900.000.000.00337.90
Simmons, Elizabeth, A,21461141.980.000.000.00141.98
Garcia, Jonathan,1888386.960.000.000.0086.96
Adams, Mackenzie, A,14640812.420.000.000.00812.42
Ward, Nicole, L,212724435.380.000.002071.422363.96
Henderson, Ashley,111851381.370.000.000.001381.37
Ramirez, Jennifer, E,213114472.580.000.002049.102423.48
Davis, Emily,27267782.990.000.00782.990.00
Roberts, Amber, W,215822638.060.000.002049.10588.96
Carter, Bailey,213322616.860.000.002616.860.00
Campbell, Gabriella,188411145.480.000.000.001145.48
Foster, Deb,215012661.400.000.002661.400.00
Campbell, Chloe,11212760.930.000.00167.25593.68
Perez, Angel, S,213362628.350.000.002071.42556.93
Peterson, Jessica, M,11868247.010.000.0061.97185.04
Roberts, Mason, D,111761106.680.000.00234.81871.87
Ross, Alexia, S,13231247.900.000.000.00247.90
Baker, Ian, V,262002756.540.000.002181.56574.98
Coleman, Vanessa,215892589.090.000.002049.10539.99
Coleman, Logan,1868691.950.000.000.0091.95
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Thomas, Logan, A,14091251.200.000.0053.99197.21
Hill, Haley, J,161033142.320.000.000.003142.32
Miller, Sydney, A,134404818.530.000.000.004818.53
Watson, Emma,17481126.940.000.000.00126.94
Perry, Marcus, L,206563245.900.000.002071.421174.48
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Campbell, Jordan,13290111.890.000.000.00111.89
Cox, Devin, C,134184768.050.000.000.004768.05
Hall, Noah, A,1525175.250.000.000.0075.25
Mehta, Carmen, C,2743694.480.000.000.0094.48
Lewis, Ryan, A,203124.990.000.000.004.99
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Diaz, Thomas, O,16020595.960.000.000.00595.96
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Barnes, Dalton, C,178581700.990.000.000.001700.99
Perry, Ana,112151155.520.000.000.001155.52
Walker, Thomas,1307193.980.000.000.0093.98
Green, Marcus, C,15974208.410.000.000.00208.41
Peterson, Xavier, R,2645639.980.000.000.0039.98
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Powell, Jasmine, A,11505846.770.000.000.00846.77
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
Winston, Ethan, R,216222612.060.000.002049.10562.96
Moore, Fernando,265821000.440.000.001000.440.00
Patterson, Grace, M,27560782.990.000.00782.990.00
Garcia, Lucas,27545782.990.000.00782.990.00
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Perry, Oscar,227856029.570.003578.272451.300.00
Jackson, Edward,290422420.340.000.002420.340.00
Griffin, Jack, L,1768632.280.000.000.0032.28
Lee, William,13185149.840.000.000.00149.84
Alexander, Nathan, A,187951198.970.000.000.001198.97
Adams, Miguel,11659213.520.000.000.00213.52
Jackson, Charles, P,112771305.660.000.0034.991270.67
Sanders, Hailey,19647282.040.000.000.00282.04
Gonzalez, James, M,188421155.480.000.000.001155.48
Jones, Samantha,1831721.980.000.000.0021.98
Thompson, Madison, L,187882351.960.000.000.002351.96
Hall, Jan, M,11740334.120.000.000.00334.12
Martinez, Kristina, S,2134529.930.000.000.0029.93
Reed, Mariah,263731565.910.000.001000.44565.47
Griffin, Jennifer, B,14244154.960.000.000.00154.96
Alexander, Sarah,1941129.990.000.000.0029.99
Griffin, Jason, L,112001267.110.000.00193.891073.22
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Collins, Amanda,2078339.980.000.000.0039.98
Lee, Ian,19646197.040.000.000.00197.04
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Hayes, Luis,12880200.730.000.000.00200.73
Wood, Brittany,2877753.990.000.000.0053.99
Russell, Samantha,11211723.560.000.0064.47659.09
Reed, Marcus,14582111.790.000.0014.9896.81
Martin, Gina, E,11078793.270.000.000.00793.27
Peterson, Christina,2897694.480.000.000.0094.48
Rodriguez, Richard,12969180.790.000.000.00180.79
Jai, Jose,12944164.210.000.000.00164.21
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Young, Savannah,259712749.320.000.002181.56567.76
Bailey, Jessica, L,12945218.440.000.000.00218.44
Jai, Luis, A,18320185.920.000.000.00185.92
Foster, Eric,229765971.330.003578.270.002393.06
Flores, Arianna,217274132.243578.270.000.00553.97
Jones, Dalton, T,189512334.970.000.000.002334.97
Bennett, Jennifer, G,13708123.940.000.000.00123.94
Turner, Morgan,11823178.470.000.000.00178.47
Gonzalez, Jordan,15157213.940.000.00123.9889.96
Phillips, Devin,18759112.060.000.000.00112.06
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Sanchez, Adrian, L,13179190.170.000.000.00190.17
Murphy, Chase, J,2472958.980.000.000.0058.98
Gonzales, Jordan,2368113.980.000.000.0013.98
Stewart, Alex, M,2008463.150.000.000.0063.15
Brooks, Lucas, S,16089342.030.000.000.00342.03
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Russell, Oscar, A,12140118.170.000.000.00118.17
Kelly, Trinity,2609515.230.000.000.0015.23
Phillips, Haley, B,2807939.980.000.000.0039.98
Clark, Miguel, D,169872414.990.000.000.002414.99
Gomez, Krista,12760273.180.000.000.00273.18
Powell, Spencer,14904468.120.000.000.00468.12
Turner, Eduardo,158764789.020.000.000.004789.02
Collins, Allison,28581119.980.000.000.00119.98
Price, Caroline,180511735.980.000.000.001735.98
Foster, Abigail,1982346.470.000.000.0046.47
Bradley, Jocelyn,230227.280.000.000.007.28
Flores, Devin, A,15559172.040.000.000.00172.04
Hu, Gilbert, L,2876769.990.000.000.0069.99
Prasad, Erick, E,28786127.950.000.000.00127.95
Moore, Matthew, W,13267109.950.000.000.00109.95
Lal, Kyle,17360122.180.000.000.00122.18
Williams, Austin,2035432.220.000.000.0032.22
Henderson, Jackson, A,221215997.330.003578.270.002419.06
Howard, Brianna, D,246304.990.000.000.004.99
Martin, Thomas, A,169521735.980.000.000.001735.98
Davis, James,11922275.500.000.000.00275.50
James, Richard, D,15760109.230.000.000.00109.23
Gonzales, Nathan, M,12107222.230.000.000.00222.23
Gonzales, Ashley, C,1860051.970.000.000.0051.97
Price, Jeremy,259892744.520.000.002181.56562.96
Thomas, Wyatt, R,12431154.540.000.000.00154.54
Stewart, Sara,17347119.720.000.000.00119.72
Gonzales, Trevor, K,16085143.530.000.0014.98128.55

Generated 2025-12-18 09:41:39.764 UTC