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

288 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Andersen, Latoya, J,290578.990.000.000.008.99
Martin, Tyler, L,2772469.990.000.000.0069.99
Adams, Carlos,1982236.960.000.000.0036.96
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Russell, Nicole, M,182372318.960.000.000.002318.96
Garcia, Alexandra, J,14107819.460.000.000.00819.46
Peterson, Xavier, R,2645639.980.000.000.0039.98
Stewart, Alexandria,174761700.990.000.000.001700.99
Harris, Noah,292562393.060.000.000.002393.06
Martinez, Carol, D,17656578.460.000.000.00578.46
Hayes, Jason,261764.990.000.000.004.99
Turner, Eduardo,158764789.020.000.000.004789.02
Blue, Paige,2170313.980.000.000.0013.98
White, Judith, R,148851155.480.000.000.001155.48
Collins, Allison,28581119.980.000.000.00119.98
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Robinson, Madison, W,183772394.970.000.000.002394.97
Baker, Eduardo,180921789.450.000.000.001789.45
Henderson, Olivia,188591155.480.000.000.001155.48
Morris, Haley, A,2354848.970.000.000.0048.97
Butler, Jonathan,261804.990.000.000.004.99
Alexander, Sarah,1941129.990.000.000.0029.99
Hall, Jason, A,29351119.980.000.000.00119.98
Sanders, Zoe, L,248254.990.000.000.004.99
Wood, Brittany,2877753.990.000.000.0053.99
Henderson, Austin,2764354.980.000.000.0054.98
Young, Courtney,176222374.980.000.000.002374.98
Sandberg, Chase,2190475.970.000.000.0075.97
Ross, Seth, M,184332329.980.000.000.002329.98
Washington, Emma,191231170.480.000.000.001170.48
Roberts, Rebecca,2800094.480.000.000.0094.48
Lewis, Rachel, J,14900839.480.000.000.00839.48
Martin, Christian, V,19709197.250.000.000.00197.25
Hernandez, Sierra,27393123.980.000.000.00123.98
Li, Thomas,181162376.960.000.000.002376.96
Sanders, Lucas, W,268024.990.000.000.004.99
Ross, Kelly,2607676.960.000.000.0076.96
Gonzales, Gavin,2448813.980.000.000.0013.98
Flores, Cassidy, L,233684.990.000.000.004.99
Hernandez, Eduardo, J,18919300.940.000.000.00300.94
White, Emma, N,16090604.960.000.000.00604.96
Alvarez, Melody,2507068.490.000.000.0068.49
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Davis, Justin,2807412.940.000.000.0012.94
Lee, Kayla, M,2078115.230.000.000.0015.23
Flores, Hannah,1952540.230.000.000.0040.23
Williams, Sydney, J,15334848.470.000.000.00848.47
Parker, Kaylee, M,2773878.980.000.000.0078.98
Lewis, Ethan,27998144.470.000.000.00144.47
Kelly, Erin, D,2351364.470.000.000.0064.47
Sanders, Mason, G,2345939.980.000.000.0039.98
Russell, Caleb,23552103.480.000.000.00103.48
Campbell, Natalie, L,115122319.990.000.000.002319.99
Edwards, Alexandra,133582386.940.000.000.002386.94
Kelly, Julia,2379867.930.000.000.0067.93
Long, Gavin,13762186.030.000.000.00186.03
Ramirez, Melanie, V,163632481.820.000.000.002481.82
Sanchez, Katherine, S,24399132.940.000.000.00132.94
Jackson, Victoria,270194.990.000.000.004.99
Martin, James, M,1987077.250.000.000.0077.25
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Taylor, Marcus, A,18944146.940.000.000.00146.94
Reed, Megan, A,181181750.980.000.000.001750.98
Gonzalez, Molly,1637021.980.000.000.0021.98
Perry, Lauren,248164.990.000.000.004.99
Hughes, Riley,2928449.990.000.000.0049.99
Bradley, Nathaniel,169551760.470.000.000.001760.47
Anderson, Madison, G,2835978.980.000.000.0078.98
Foster, Paige,2742894.480.000.000.0094.48
Cannata, Gabrielle, C,217254.990.000.000.004.99
Robinson, Lauren,2719668.490.000.000.0068.49
Zhang, Connor, R,138532329.980.000.000.002329.98
Torres, Dalton,235037.280.000.000.007.28
Perez, Jonathan, R,2345512.940.000.000.0012.94
Moore, Ian, L,2463939.980.000.000.0039.98
Bailey, Maria, C,1915034.980.000.000.0034.98
Price, Caroline,180511735.980.000.000.001735.98
Reed, Morgan, E,2877923.970.000.000.0023.97
Baker, Gabriella,174041709.980.000.000.001709.98
Stewart, Marcus, R,2063221.980.000.000.0021.98
Garcia, Xavier, M,2030071.970.000.000.0071.97
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Martin, Katherine, J,2027339.980.000.000.0039.98
Flores, Brandon, L,2562189.970.000.000.0089.97
Nath, Yolanda, A,2462513.980.000.000.0013.98
Davis, Jonathan,2925913.980.000.000.0013.98
Srini, Evelyn,16855150.950.000.000.00150.95
Foster, Nicole, A,2349489.970.000.000.0089.97
Perez, Barry, M,2728269.990.000.000.0069.99
Gray, Marcus, T,183892401.450.000.000.002401.45
Butler, Jackson, J,183241735.980.000.000.001735.98
Kelly, Bailey, R,28284563.770.000.000.00563.77
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
Jackson, Andrew,2047985.480.000.000.0085.48
Rogers, Olivia,12020804.470.000.000.00804.47
Li, Brandon,2933973.960.000.000.0073.96
Washington, Adam, G,2543713.980.000.000.0013.98
Campbell, Timothy,2584513.980.000.000.0013.98
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Johnson, Ian, E,2173283.470.000.000.0083.47
Williams, Joshua,260514.990.000.000.004.99
Chen, David,2720839.980.000.000.0039.98
Russell, Katherine,2877169.990.000.000.0069.99
Martin, Alfredo, P,2148039.980.000.000.0039.98
Zhao, Karen, L,254082735.530.002181.560.00553.97
White, Jennifer, S,27027782.990.00782.990.000.00
Fernandez, Darren,2899278.980.000.000.0078.98
Cox, Lucas, J,253932443.350.000.002443.350.00
Turner, Blake,12136131.740.000.000.00131.74
Cook, Steven, J,27053782.990.000.00782.990.00
Coleman, Lucas, A,27060782.990.000.00782.990.00
Rivera, Makayla, A,2878334.990.000.000.0034.99
Williams, Edward, D,14274121.560.000.000.00121.56
Carter, Jason,11724210.090.000.0071.58138.51
Cook, Bryce,2864069.990.000.000.0069.99
Coleman, Wyatt, M,2328439.980.000.000.0039.98
Martin, Brandon, S,2169139.980.000.000.0039.98
Hughes, Morgan, T,11642392.890.000.000.00392.89
Lopez, Jack, I,2904751.460.000.000.0051.46
Hayes, Oscar,2652729.260.000.000.0029.26
Hall, Luke, E,14745902.460.000.000.00902.46
Reed, Mariah,263731565.910.000.001000.44565.47
Kumar, Austin,204834400.060.000.002049.102350.96
Wilson, Christian,27085782.990.000.00782.990.00
Miller, Katherine, B,27102782.990.000.00782.990.00
Townsend, Jeremiah, I,265031000.440.000.001000.440.00
Diaz, Hunter, S,27242782.990.000.00782.990.00
Taylor, Victoria,260132443.350.000.002443.350.00
Washington, Taylor,212664525.070.000.002049.102475.97
Davis, Emily,27267782.990.000.00782.990.00
Garcia, Hunter, J,213053204.580.000.002049.101155.48
Carter, Bailey,213322616.860.000.002049.10567.76
Foster, Deb,215012661.400.000.002661.400.00
Patterson, Alexis,213484392.020.000.002049.102342.92
Campbell, Adam, A,214002688.890.000.002071.42617.47
Adams, Connor,214232888.560.000.002049.10839.46
Collins, Connor, J,27270782.990.000.00782.990.00
Baker, Ian, V,262002756.540.000.002181.56574.98
Hughes, Brittany,14387898.460.000.000.00898.46
Bryant, Nathan,2145059.980.000.000.0059.98
Rodriguez, Michael, E,168103064.630.000.000.003064.63
Morris, Alyssa,28072548.980.000.000.00548.98
Cook, Seth,2301064.470.000.000.0064.47
Harris, Destiny, M,137102341.460.000.000.002341.46
Chow, Candice,1923260.960.000.000.0060.96
Kumar, Zachary,254334.990.000.000.004.99
Simmons, Jose,2464739.980.000.000.0039.98
Hayes, Carson, A,124472331.950.000.000.002331.95
Rodriguez, Nicholas, D,14604137.950.000.0023.97113.98
Campbell, Alex,119844730.320.000.000.004730.32
Carter, Savannah, M,120902350.960.000.000.002350.96
Shan, Logan,1867760.960.000.0029.9930.97
Collins, Xavier, C,16646250.910.000.000.00250.91
Blue, Makayla,1900029.990.000.000.0029.99
Robinson, Julia,28121119.980.000.000.00119.98
Yang, Aaron, C,2519654.980.000.000.0054.98
Nelson, Luis,234884.990.000.000.004.99
Nelson, Sean,11841307.970.000.000.00307.97
Gonzalez, James, M,188421155.480.000.000.001155.48
Flores, Eduardo, S,2896962.980.000.000.0062.98
Thomas, Logan, A,14091251.200.000.0053.99197.21
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Powell, David, W,266151000.440.000.001000.440.00
Parker, Jordan,216212616.860.000.002049.10567.76
Moore, Fernando,265821000.440.000.001000.440.00
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Blue, Marcus, L,27550782.990.000.00782.990.00
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Jackson, Edward,290422420.340.000.002420.340.00
Peterson, Christina,2897694.480.000.000.0094.48
Clark, Emily, R,120862294.990.000.000.002294.99
Taylor, Christian,2076456.760.000.000.0056.76
Flores, Nathan, C,2463713.980.000.000.0013.98
Bradley, Alexandria,176911779.470.000.000.001779.47
Moore, Anthony, M,2473039.980.000.000.0039.98
Taylor, Natalie, M,14338828.740.000.000.00828.74
Phillips, Devin,18759112.060.000.000.00112.06
Evans, Gabriel,2348789.970.000.000.0089.97
Price, Lauren, J,14079184.740.000.0037.29147.45
Murphy, Chase, J,2472958.980.000.000.0058.98
Davis, Ethan,136604750.010.000.000.004750.01
Alexander, Ryan, J,14078839.480.000.00839.480.00
Martinez, Dominique,287888.990.000.008.990.00
Diaz, Hailey, W,116932294.990.000.002294.990.00
Scott, Gabrielle,270614.990.000.000.004.99
Washington, Thomas, C,2745137.430.000.000.0037.43
Garcia, Christian, J,164913106.330.000.00751.342354.99
Patterson, Jocelyn, D,2355964.470.000.0064.470.00
Shan, Chad, M,2462112.940.000.000.0012.94
She, Shawn, J,16902141.980.000.000.00141.98
Butler, Trevor,2741569.990.000.0069.990.00
Thomas, Matthew, K,13239185.700.000.000.00185.70
Green, Eric,2738069.990.000.000.0069.99
Flores, Devin, A,15559172.040.000.000.00172.04
Price, Devin, M,18758158.510.000.000.00158.51
Davis, Austin, E,133664749.040.000.000.004749.04
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Nelson, Jennifer,171471700.990.000.000.001700.99
Collins, Alex, S,287812.290.000.000.002.29
Bryant, Brittany,2254548.970.000.000.0048.97
Hughes, Jasmine,276284.990.000.000.004.99
Henderson, Logan, C,2236656.970.000.000.0056.97
Washington, Hannah, A,291307.280.000.000.007.28
Gonzales, Trevor, K,16085143.530.000.000.00143.53
Martinez, Kristina, S,2134529.930.000.000.0029.93
Foster, Isabel, M,2174571.950.000.000.0071.95
Turner, Samuel,2742069.990.000.000.0069.99
Bell, Timothy, J,2810178.980.000.000.0078.98
Ward, Kaylee, A,244154.990.000.000.004.99
Phillips, Luis, G,207347.280.000.000.007.28
Turner, James, E,16841126.960.000.000.00126.96
Roberts, Robert, R,1898656.970.000.000.0056.97
Cooper, Andrea,2932378.980.000.000.0078.98
Rodriguez, Destiny, J,227397.280.000.000.007.28
Parker, Caleb, A,2631813.980.000.000.0013.98
Diaz, Richard, A,2668264.470.000.000.0064.47
Wu, Randy, J,116472365.940.000.000.002365.94
Gray, Sara,292472447.050.000.000.002447.05
Anderson, David, A,2209761.960.000.000.0061.96
Phillips, Aaron, R,2494739.980.000.000.0039.98
Taylor, Tyler, A,12032614.960.000.000.00614.96
Washington, Aaron, L,246494.990.000.000.004.99
Barnes, Ian, M,16106133.540.000.000.00133.54
Stewart, Cindy,14496804.480.000.000.00804.48
Thomas, Edward, E,19147133.710.000.000.00133.71
McDonald, Aaron, J,27734119.980.000.000.00119.98
Flores, Julia, E,172631700.990.000.000.001700.99
Morgan, Marcus, W,289682.290.000.000.002.29
Gray, Mackenzie, L,1768056.970.000.000.0056.97
Lee, James, J,2881769.990.000.000.0069.99
Scott, Eric,282484.990.000.000.004.99
Rogers, Andrea, L,14328308.660.000.000.00308.66
Robinson, Joseph,2814194.480.000.000.0094.48
Foster, Emma,15468436.350.000.000.00436.35
Flores, Gabriel,271117.280.000.000.007.28
Howard, Alyssa, A,11513863.950.000.000.00863.95
Diaz, Brandon,236764.990.000.000.004.99
Chen, Jack, E,17579151.430.000.000.00151.43
Hall, Grace, A,201894.990.000.000.004.99
Anderson, Ryan, W,132712319.990.000.000.002319.99
Long, Elizabeth, F,127822400.950.000.000.002400.95
Watson, Erin, B,227724.990.000.000.004.99
Jenkins, Dakota, D,2067964.470.000.000.0064.47
Lewis, Christopher,1875586.960.000.000.0086.96
Foster, Alyssa, I,14875839.480.000.000.00839.48
Gonzales, Ryan, M,173731735.980.000.000.001735.98
Flores, Luke, L,247337.280.000.000.007.28
Perry, Jackson, J,213064.990.000.000.004.99
Srini, Ruben,18078200.940.000.000.00200.94
Hughes, Antonio, P,15913712.270.000.000.00712.27
Clark, Destiny, L,28600119.980.000.000.00119.98
Murphy, Brianna, K,2834269.990.000.000.0069.99
King, Sara,2235439.980.000.000.0039.98
Ross, David, M,171431763.970.000.000.001763.97
Foster, Aaron,155664912.470.000.000.004912.47
Jones, Alexandra, B,2020245.950.000.000.0045.95
Sara, Ivan, L,2509067.930.000.000.0067.93
Roberts, Noah, S,2704268.490.000.000.0068.49
Shan, Gabriel, T,2773169.990.000.000.0069.99
Chandra, Allen,2932753.990.000.000.0053.99
Bell, Brooke, H,2325339.980.000.000.0039.98
Russell, Richard,2763322.260.000.000.0022.26
Ward, Destiny,16128539.990.000.000.00539.99
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Allen, Mason,176252431.950.000.000.002431.95
Richardson, Devin, G,2131836.960.000.000.0036.96
Ortega, Sheila, M,2763239.980.000.000.0039.98
Rivera, Hailey, R,2079239.980.000.000.0039.98
Diaz, Gabrielle,14893839.480.000.000.00839.48
Blanco, Armando, F,139182397.950.000.000.002397.95
Sanchez, Rachel, C,267304.990.000.000.004.99
Rogers, Paige, H,17125539.990.000.000.00539.99
Yuan, Brendan, S,247444.990.000.000.004.99
Hughes, Austin, P,183681754.980.000.000.001754.98
Long, Rachel,2828339.980.000.000.0039.98
Griffin, James,28189567.760.000.000.00567.76
Coleman, Ian,2127639.980.000.000.0039.98
Thompson, Lucas, O,212774.990.000.000.004.99
Morgan, Isabella, L,28602144.470.000.000.00144.47
Collins, Charles, B,29041628.450.000.000.00628.45
Adams, Katherine, M,235184.990.000.000.004.99
_SUM1806517.5025543.71493581.21254851.631032540.95

Generated 2025-12-23 05:07:48.430 UTC