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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Green, Chloe, J,1465892.820.000.000.0092.82
Mitchell, Savannah,261153052.800.000.002443.35609.45
James, Julia,2497567.930.000.000.0067.93
Patterson, Jeremy,130272319.260.000.000.002319.26
Chavez, Kara, P,13285214.350.000.0012.94201.41
Sánchez, Angela, C,176551750.980.000.000.001750.98
Kelly, Trinity,2609515.230.000.000.0015.23
Mitchell, Xavier, L,265331629.410.000.001000.44628.97
Hayes, Dalton, C,188822322.280.000.000.002322.28
Cooper, Andrea,2932378.980.000.000.0078.98
Foster, Deb,215012661.400.000.002661.400.00
Adams, Julia, N,2607359.980.000.000.0059.98
Bailey, Olivia,238924.990.000.000.004.99
Collins, Connor, J,27270782.990.000.00782.990.00
Johnson, Jacob, I,28069553.970.000.000.00553.97
Thomas, Ian,191181120.490.000.000.001120.49
Bradley, Melanie, G,133434720.270.000.000.004720.27
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Evans, Jesse,2191639.980.000.000.0039.98
Diaz, Alyssa,139084715.330.000.000.004715.33
Rivera, Sara,187852350.960.000.000.002350.96
Thomas, David,168363193.790.000.000.003193.79
Wilson, Daniel, K,142814746.300.000.000.004746.30
Butler, Cassidy, L,21792114.460.000.000.00114.46
Gray, Mariah,222787.280.000.007.280.00
Gonzalez, James, M,188421155.480.000.000.001155.48
Moore, Ian, L,2463939.980.000.000.0039.98
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Moreno, Marie,2773969.990.000.000.0069.99
Foster, Isabelle,2637739.980.000.000.0039.98
Morris, Mason, J,22349124.990.000.000.00124.99
Hernandez, Jonathan, J,1901465.950.000.000.0065.95
Price, Caroline,180511735.980.000.000.001735.98
Kelly, Julia,2379867.930.000.0067.930.00
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Foster, Abigail,1982346.470.000.000.0046.47
Baker, Robert, A,273007.280.000.007.280.00
Watson, Michelle, H,262352181.560.000.002181.560.00
Collins, Jonathan,16849119.980.000.000.00119.98
White, Emily, M,159174679.060.000.000.004679.06
Johnson, Andrew, F,262942443.350.000.002443.350.00
Mitchell, Evan, R,247314.990.000.000.004.99
Sanders, Angel,16219553.970.000.000.00553.97
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Li, Rafael, M,217527.280.000.000.007.28
Hughes, Luis,130841798.960.000.000.001798.96
Blue, Marcus, L,27550782.990.000.00782.990.00
Jones, Alexandra, B,2020245.950.000.000.0045.95
Brown, Dylan, J,124492351.960.000.000.002351.96
Campbell, Wyatt, C,27602782.990.000.00782.990.00
Zhang, Connor, R,138532329.980.000.000.002329.98
Gonzales, Jose,2201439.980.000.000.0039.98
Davis, Richard, R,15549574.980.000.00574.980.00
Perez, Jonathan, R,2345512.940.000.000.0012.94
Peterson, Melissa, S,249954.990.000.004.990.00
Murphy, Chase, J,2472958.980.000.000.0058.98
Ward, Eduardo, I,139162354.980.000.000.002354.98
Wilson, Grace,17539205.920.000.000.00205.92
Zhang, Robert,188551155.480.000.000.001155.48
Perry, James,192051249.840.000.000.001249.84
Gray, Isabella,168203217.790.000.000.003217.79
Brooks, Lucas, S,16089342.030.000.000.00342.03
Gray, Sebastian, B,138782366.960.000.000.002366.96
Long, Jordyn,1733847.250.000.000.0047.25
Flores, Madison,14416769.490.000.000.00769.49
Walker, Jacob, N,29027574.980.000.000.00574.98
Raman, Emmanuel, W,1955486.950.000.000.0086.95
Allen, Sean, L,12097159.220.000.000.00159.22
Moore, Jennifer, A,2175964.470.000.000.0064.47
Bryant, Dakota, L,176132401.950.000.000.002401.95
Allen, Luke,113162349.980.000.002349.980.00
Foster, Nicole, A,2349489.970.000.000.0089.97
Ortega, Sheila, M,2763239.980.000.000.0039.98
Alexander, Ryan, J,14078839.480.000.00839.480.00
Butler, Jackson, J,183241735.980.000.000.001735.98
Russell, Nicole, M,182372318.960.000.000.002318.96
Garcia, Chloe, M,110372374.230.000.002374.230.00
Alexander, Gavin, K,2932249.990.000.000.0049.99
Hayes, Jason,261764.990.000.000.004.99
Martinez, Dominique,287888.990.000.008.990.00
Jones, Alexander, I,2002180.960.000.000.0080.96
Malhotra, Brenda,133912405.470.000.000.002405.47
Campbell, Hailey,15507267.840.000.00228.9638.88
Li, Brandon,2933973.960.000.000.0073.96
Thompson, Xavier, R,15761192.410.000.000.00192.41
Stewart, Jessica,16097103.550.000.0046.5856.97
Ramirez, Emma,29072128.970.000.000.00128.97
Nath, Yolanda, A,2462513.980.000.000.0013.98
Patterson, Jocelyn, D,2355964.470.000.0064.470.00
Campbell, Timothy,2584513.980.000.000.0013.98
Nelson, Luis,234884.990.000.000.004.99
Nelson, Jordan, H,201304.990.000.004.990.00
Williams, Joshua,260514.990.000.000.004.99
Diaz, Gabrielle,14893839.480.000.000.00839.48
Wood, Gavin,16964108.540.000.0093.5614.98
Russell, Katherine,2877169.990.000.000.0069.99
White, Judith, R,148851155.480.000.000.001155.48
Barnes, Haley, J,2133939.980.000.0039.980.00
Martin, Alfredo, P,2148039.980.000.000.0039.98
Robinson, Zachary, L,137092332.280.000.000.002332.28
Wright, Jennifer,2650559.980.000.0059.980.00
Kelly, Erin, D,2351364.470.000.000.0064.47
Richardson, Brian,2860878.980.000.000.0078.98
Evans, Maria,22544127.280.000.00127.280.00
Miller, Andrew, C,271104.990.000.000.004.99
Russell, Rachel, C,2158124.270.000.0024.270.00
Lee, Alexander, S,18356149.910.000.000.00149.91
Torres, Taylor,16666205.440.000.00123.9881.46
Gray, Marcus, T,183892401.450.000.000.002401.45
Moore, Logan,2634889.970.000.0089.970.00
Thompson, Lucas, O,212774.990.000.000.004.99
Yuan, Leonard, F,167911729.970.000.000.001729.97
Anand, Brendan, L,1984721.980.000.000.0021.98
Gonzales, Ashley, C,1860051.970.000.000.0051.97
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Sanchez, Martin, E,216317.280.000.000.007.28
Moore, Wyatt, F,189712351.960.000.000.002351.96
Turner, Samuel,2742069.990.000.0069.990.00
Johnson, Ian, E,2173283.470.000.000.0083.47
Chen, Luis, G,2125294.450.000.0094.450.00
White, Emma, N,16090604.960.000.000.00604.96
Patterson, Nicole,1972937.270.000.000.0037.27
James, Adrian, C,253404.990.000.000.004.99
Young, Julia, J,274144.990.000.000.004.99
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Xu, Louis,2010466.530.000.0066.530.00
Rowe, Todd,14586233.940.000.000.00233.94
Sanchez, Mariah, R,1922066.650.000.0038.8827.77
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Rubio, Javier, E,1972664.240.000.0064.240.00
Barnes, Dalton, C,178581700.990.000.000.001700.99
Taylor, Lucas, V,115232376.960.000.002376.960.00
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Peterson, Alex, M,13423132.900.000.000.00132.90
Wood, Brittany,2877753.990.000.000.0053.99
Torres, Erin,1218287.250.000.0037.2949.96
Gonzales, Emily, P,21777180.980.000.000.00180.98
Robinson, Joseph,2814194.480.000.0094.480.00
Coleman, Samuel, N,17450123.980.000.000.00123.98
Johnson, Xavier, R,2325539.980.000.0039.980.00
Russell, Caleb,23552103.480.000.000.00103.48
Ward, Devin, J,15378170.910.000.0076.9593.96
Reed, Melanie, A,28160574.980.000.000.00574.98
Ortega, Javier, P,127852294.990.000.000.002294.99
Edwards, Hailey,242584.990.000.000.004.99
Gutierrez, Jerome,127832420.460.000.000.002420.46
Diaz, Trevor, B,2051954.960.000.000.0054.96
Phillips, Miguel,2049812.940.000.000.0012.94
Reed, Megan, A,181181750.980.000.000.001750.98
Sanchez, Jared, J,2585064.470.000.000.0064.47
Phillips, Haley, B,2807939.980.000.000.0039.98
Peterson, Morgan, J,168341750.980.000.000.001750.98
Collins, Allison,28581119.980.000.000.00119.98
Carter, Isaac,137191129.480.000.000.001129.48
Watson, Victoria,16125588.960.000.000.00588.96
Collins, Jose,2474839.980.000.0039.980.00
Stewart, Gabriella,2803469.990.000.000.0069.99
Alexander, Taylor,17482146.940.000.0076.9769.97
Martin, Kellie, R,28195574.980.000.000.00574.98
Hughes, Miranda,266784.990.000.000.004.99
Thomas, Dalton,230097.280.000.000.007.28
Smith, Justin, P,1982721.980.000.000.0021.98
Lal, Jack, R,185251735.980.000.000.001735.98
Jackson, Hannah, G,131432404.970.000.000.002404.97
Rodriguez, Natalie,2077330.970.000.000.0030.97
Perry, Benjamin,291652407.040.000.002407.040.00
Shan, Gabriel, T,2773169.990.000.000.0069.99
James, Maria,1624391.970.000.0069.9921.98
Thomas, Jeremiah,183721760.470.000.000.001760.47
Bryant, Rachel,220197.280.000.007.280.00
Reed, Michelle,2804669.990.000.000.0069.99
Hill, Haley, J,161033142.320.000.00792.342349.98
Johnson, Madison, L,15530846.460.000.000.00846.46
Adams, Kyle, E,1881269.990.000.0069.990.00
Allen, Madeline,2924068.970.000.000.0068.97
Anderson, Daniel,20694146.970.000.00146.970.00
Ward, Lucas, N,183631700.990.000.000.001700.99
Zhang, Heather,166543056.320.000.00751.342304.98
Gomez, Briana, A,2878443.980.000.000.0043.98
Morris, Haley, A,2354848.970.000.000.0048.97
Griffin, James,28189567.760.000.000.00567.76
Williams, Sydney, J,15334848.470.000.000.00848.47
Adams, Katherine, M,235184.990.000.000.004.99
Campbell, Natalie, L,115122319.990.000.000.002319.99
Smith, Andrew,1472387.570.000.0014.9872.59
Robinson, Lauren,2719668.490.000.0068.490.00
Torres, Dalton,235037.280.000.007.280.00
Sharma, Yolanda, K,250483046.840.002443.35603.490.00
Moore, Jessica, J,2008576.760.000.000.0076.76
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Russell, Samuel, V,11652310.930.000.000.00310.93
Diaz, Elijah,200004495.480.003374.990.001120.49
Green, Isabella,26620699.10699.100.000.000.00
Morris, Paige, W,220414167.233578.270.000.00588.96
Collins, Lucas, T,219214142.753578.270.000.00564.48
Bennett, Jordyn, L,222304223.230.003578.270.00644.96
Miller, Joseph, A,227134148.190.003578.270.00569.92
Perry, Oscar,227856029.570.003578.272451.300.00
Long, Julia, R,228895971.330.003578.270.002393.06
Stewart, Hailey,229036054.220.003578.270.002475.95
Thomas, Alexandra, C,231724809.390.003578.271231.120.00
Tang, Carl,2123832.270.000.000.0032.27
Rogers, Carlos,19645134.440.000.000.00134.44
Carter, Marcus, l,2147131.970.000.000.0031.97
Ross, Antonio,18322148.890.000.000.00148.89
Gray, Jesse,14626197.040.000.000.00197.04
Griffin, Maria,1840763.250.000.000.0063.25
Smith, Katherine, J,13197105.190.000.000.00105.19
Patterson, Maria, G,1333094.950.000.000.0094.95
Suarez, Juan, R,167631700.990.000.000.001700.99
Bryant, Kyle,231644807.100.003578.271228.830.00
Foster, Eric,229765971.330.003578.270.002393.06
Anderson, Megan, A,238594153.250.003578.27574.980.00
Martin, Brianna, M,235834829.390.003578.270.001251.12
Sanders, Melissa, R,242844837.340.003578.270.001259.07
Flores, Xavier,238664828.110.003578.270.001249.84
Henderson, Sarah, M,238674802.110.003578.270.001223.84
Hughes, Luke, I,270141274.080.00699.100.00574.98
Perry, Jonathan, T,27026699.100.00699.100.000.00
Price, Isabelle,201825749.970.003374.990.002374.98
Murphy, Shelby,244894.990.000.000.004.99
Hill, Fernando,247634.990.000.000.004.99
Wright, Jackson,11698225.950.000.000.00225.95
Walker, Isabella,243864143.740.003578.27565.470.00
Russell, Kaitlyn, M,244913578.270.003578.270.000.00
Perry, Christian,246714354.600.003578.270.00776.33
Fernandez, Cesar,200355694.980.003374.990.002319.99
Watson, Kimberly, A,201883226.900.002071.420.001155.48
Ross, Haley, T,253612443.350.002443.350.000.00
Hughes, Stephanie,263161000.440.001000.440.000.00
Cook, Steven, J,27053782.990.00782.990.000.00
Flores, Stephanie,259922721.550.000.002181.56539.99
Evans, Luke,2917615.230.000.000.0015.23
Thomas, Samantha,2169093.970.000.000.0093.97
Reed, Marcus,14582111.790.000.0014.9896.81
Robinson, Sarah, A,2702859.980.000.000.0059.98
Reed, Catherine, M,203807.280.000.000.007.28
Zeng, Jake,18054106.930.000.000.00106.93
Foster, Trevor, J,2896469.990.000.000.0069.99
Ramirez, Sydney,267007.280.000.000.007.28
Butler, Isabel,16241126.960.000.000.00126.96
Rivera, Makayla, A,2878334.990.000.000.0034.99
Williams, Edward, D,14274121.560.000.000.00121.56
Morgan, Isaiah,18978118.730.000.000.00118.73
Roberts, Amber, W,215822638.060.000.002049.10588.96
Hayes, Brittany,13941286.820.000.000.00286.82
Hayes, Carson, A,124472331.950.000.000.002331.95
Wilson, Christian,27085782.990.000.00782.990.00
Robinson, William,20103103.480.000.000.00103.48
Bell, Danielle,140414765.020.000.000.004765.02

Generated 2025-11-07 01:42:10.264 UTC