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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Flores, Jordyn,252882721.550.002181.560.00539.99
Sharma, Thomas, A,18637121.940.000.000.00121.94
Ross, Xavier, A,12202171.470.000.0049.97121.50
Robinson, Jennifer, L,265041000.440.000.001000.440.00
Lewis, Brandon, A,2903769.990.000.000.0069.99
Long, Elizabeth, F,127822400.950.000.000.002400.95
Nelson, Adam, B,27402128.970.000.000.00128.97
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Russell, Samuel, V,11652310.930.000.000.00310.93
Patterson, Aaron, W,191131184.460.000.000.001184.46
Green, Gabriella, C,2803569.990.000.000.0069.99
Kennedy, Bridget,2202639.980.000.000.0039.98
Ruiz, Carrie, D,18644135.440.000.00100.4634.98
Navarro, Jerome, B,11519717.280.000.0022.18695.10
Garcia, Xavier, M,2030071.970.000.000.0071.97
Jackson, Victoria,270194.990.000.000.004.99
Foster, Caleb,27112114.460.000.000.00114.46
Zhao, Karen, L,254082735.530.002181.560.00553.97
Roberts, Mason, D,111761106.680.000.00494.64612.04
Diaz, Alyssa,139084715.330.000.000.004715.33
Cooper, Brian, L,13760128.840.000.000.00128.84
Sara, Ivan, L,2509067.930.000.000.0067.93
Hall, Kyle, J,1749169.970.000.000.0069.97
Young, Kaylee, S,13756298.490.000.0058.47240.02
Fernandez, Cesar,200355694.980.003374.990.002319.99
Wright, Carol, C,12928247.410.000.0033.98213.43
Adams, Jennifer,153624745.020.000.000.004745.02
Kelly, Trinity,2609515.230.000.000.0015.23
Murphy, Dalton, N,27043782.990.00782.990.000.00
Lobao, Alexandre,1892691.950.000.0091.950.00
Garcia, Lucas,27545782.990.000.00782.990.00
Long, Rachel,2828339.980.000.000.0039.98
Alexander, Taylor,17482146.940.000.0076.9769.97
Adams, Katherine, M,235184.990.000.000.004.99
Jackson, Edward,290422420.340.000.002420.340.00
Henderson, Luke,19200109.240.000.000.00109.24
Barnes, Emily, G,15996564.990.000.000.00564.99
Jones, Natalie, A,11845197.200.000.0082.26114.94
Townsend, Jeremiah, I,265031000.440.000.001000.440.00
Ward, Jade, D,14661195.020.000.000.00195.02
Perry, Jennifer, J,221205962.340.003578.272384.070.00
Shan, Logan,1867760.960.000.0029.9930.97
Washington, Vanessa,238194802.110.003578.270.001223.84
Robinson, Ian, D,138522294.990.000.000.002294.99
Clark, Emily, R,120862294.990.000.000.002294.99
Morgan, Timothy,14633242.500.000.0071.58170.92
Smith, Megan, J,2671668.970.000.000.0068.97
Prasad, Donald,15413318.920.000.00123.98194.94
Alexander, Edward, E,18524195.950.000.000.00195.95
Tang, Carl,2123832.270.000.000.0032.27
Peterson, Brian,12892419.470.000.00156.27263.20
Bryant, Samantha,18345115.470.000.000.00115.47
Flores, Madison,14416769.490.000.000.00769.49
Griffin, Thomas, J,19015125.430.000.0094.4630.97
Cook, Megan, J,2029956.970.000.000.0056.97
Hernandez, Jonathan, J,1901465.950.000.000.0065.95
Wright, Kyle,2371626.970.000.000.0026.97
Gutierrez, Linda, D,2857569.990.000.000.0069.99
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Mitchell, Bailey, B,267067.280.000.007.280.00
Bailey, Morgan, E,213542646.400.000.002071.42574.98
Flores, Julia, E,172631700.990.000.000.001700.99
Griffin, Stephanie, L,2826127.920.000.000.0027.92
Diaz, Elijah,200004495.480.003374.990.001120.49
Turner, Andrea, A,202093268.550.002049.100.001219.45
Green, Mackenzie, C,280737.280.000.000.007.28
Ashe, Alexis, S,194141145.480.000.000.001145.48
Bailey, Mariah, L,2724354.980.000.000.0054.98
Lopez, Katelyn,11820232.710.000.0060.47172.24
Brooks, Lucas, S,16089342.030.000.000.00342.03
Moreno, Renee, C,12936265.220.000.000.00265.22
Smith, Austin,13707149.050.000.000.00149.05
Moore, Wyatt, F,189712351.960.000.000.002351.96
Cooper, Brianna,2592513.980.000.000.0013.98
Chapman, Nancy, E,11276840.150.000.0066.26773.89
Carter, Katherine,11861286.300.000.000.00286.30
Richardson, Victoria, C,248172181.560.002181.560.000.00
Diaz, Gabrielle,14893839.480.000.000.00839.48
Scott, Sean, F,2475539.980.000.000.0039.98
Perry, Oscar,227856029.570.003578.272451.300.00
Carter, Jason,11724210.090.000.00113.8696.23
Carter, Sydney,12959203.920.000.000.00203.92
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
Ortega, Javier, P,127852294.990.000.000.002294.99
Moore, Andrew, A,13944150.130.000.0036.27113.86
Long, Sydney,279217.280.000.000.007.28
Simmons, Dakota, T,14110819.460.000.000.00819.46
Roberts, Hunter,282607.280.000.000.007.28
Reed, Melanie, A,28160574.980.000.000.00574.98
Jackson, Andrew,2047985.480.000.000.0085.48
Williams, Edward, D,14274121.560.000.000.00121.56
Ward, Mariah, J,2158044.910.000.000.0044.91
Diaz, Luke,12054402.530.000.00139.97262.56
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Martin, Katherine, J,2027339.980.000.000.0039.98
Phillips, Miguel,2049812.940.000.000.0012.94
Sun, Arturo, C,11498557.540.000.0012.94544.60
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Martin, Noah, A,1765775.970.000.0075.970.00
Barnes, Brittany, R,15340156.040.000.0074.4681.58
Martinez, Wyatt, R,228815997.330.003578.270.002419.06
Bailey, Jessica, L,12945218.440.000.000.00218.44
Jai, Jose,12944164.210.000.000.00164.21
Moreno, Meredith, D,2228589.970.000.000.0089.97
Henderson, Abigail,2044139.980.000.000.0039.98
Henderson, Caroline,2008256.970.000.000.0056.97
Fernandez, Ruth,205463246.550.000.002049.101197.45
Carter, Isaac,137191129.480.000.000.001129.48
Butler, Isabel,16241126.960.000.000.00126.96
Wang, Zachary,2214489.970.000.000.0089.97
Smith, John,198555709.960.003399.990.002309.97
Diaz, Faith, M,2236356.970.000.000.0056.97
Mohamed, Samantha, A,292772419.060.000.002419.060.00
Lewis, Christopher,1875586.960.000.000.0086.96
Lewis, Lucas, A,232094802.110.003578.271223.840.00
Long, Jordan,199884555.470.003399.990.001155.48
Bennett, Brittany, J,2233239.980.000.000.0039.98
Clark, William,2902169.990.000.000.0069.99
Ward, Cole,214907.280.000.000.007.28
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Suarez, Juan, R,167631700.990.000.000.001700.99
Moore, Jennifer, A,2175964.470.000.000.0064.47
Morgan, Isabella, L,28602144.470.000.000.00144.47
Taylor, Edward, C,17442319.880.000.00230.9088.98
Green, Kaylee, C,2618567.970.000.000.0067.97
Hayes, Arianna,259912845.520.000.002181.56663.96
Turner, Wyatt,200345769.960.003399.990.002369.97
Carter, Elijah,216182611.070.000.002611.070.00
Sanders, Angel,16219553.970.000.000.00553.97
Walker, Isabella,243864143.740.003578.27565.470.00
Ward, Angela, M,2775669.990.000.000.0069.99
Alexander, Sarah,1941129.990.000.000.0029.99
Bradley, Melanie, G,133434720.270.000.000.004720.27
Garcia, Benjamin, L,175951785.970.000.000.001785.97
Howard, Alyssa, A,11513863.950.000.000.00863.95
Peterson, Jared,11502829.370.000.00171.95657.42
Hughes, Samantha,2721564.470.000.000.0064.47
Green, Sophia, E,249772181.560.002181.560.000.00
Thomas, David,168363193.790.000.000.003193.79
Wu, Randy, J,116472365.940.000.002365.940.00
Diaz, Hunter, S,27242782.990.000.00782.990.00
Bryant, Gabriel,2765669.990.000.000.0069.99
Martin, Jill, C,11824181.030.000.0069.97111.06
Reed, Bryan,18884133.930.000.000.00133.93
Ramirez, Brian, M,116182369.960.000.002369.960.00
Walker, Destiny, M,169961754.980.000.000.001754.98
Anderson, David, A,2209761.960.000.0061.960.00
Thomas, Megan,2907169.990.000.000.0069.99
Powell, Caleb, G,216132610.580.000.002049.10561.48
Green, Marcus, C,15974208.410.000.0091.95116.46
Nelson, Jordan, H,201304.990.000.004.990.00
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Hayes, Luis,12880200.730.000.000.00200.73
Jai, Connor, D,27253782.990.000.00782.990.00
Hayes, Carson, A,124472331.950.000.000.002331.95
Griffin, Isabelle,249864.990.000.000.004.99
Bailey, Maria, C,1915034.980.000.000.0034.98
Davis, Justin,2807412.940.000.000.0012.94
Hayes, Gavin, A,194001179.470.000.000.001179.47
Garcia, Victoria, V,245013578.270.003578.270.000.00
Lee, Samantha, B,2737878.980.000.000.0078.98
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Campbell, Timothy,2584513.980.000.000.0013.98
James, Morgan, E,2324539.980.000.000.0039.98
Butler, Jackson, J,183241735.980.000.000.001735.98
Martin, Gina, E,11078793.270.000.00158.36634.91
Turner, Blake,12136131.740.000.000.00131.74
Bryant, Kyle,231644807.100.003578.271228.830.00
Lopez, Bailey, R,185571179.470.000.001179.470.00
Simmons, Dylan,16133107.850.000.0038.8868.97
Li, Rafael, M,217527.280.000.000.007.28
Morris, Jessica,289678.990.000.008.990.00
Turner, Timothy, C,14641119.860.000.000.00119.86
Reed, Catherine, M,203807.280.000.000.007.28
Gray, Jared, A,264494.990.000.000.004.99
Perry, Justin, E,167583062.340.000.000.003062.34
Long, Chloe,167841735.980.000.000.001735.98
Adams, Hailey, M,121544798.530.000.002379.472419.06
Hill, Timothy,14871848.470.000.000.00848.47
Allen, Angel, G,15571101.850.000.0034.8966.96
Coleman, Stephanie,2226489.970.000.000.0089.97
White, Cameron,238304802.110.003578.270.001223.84
Walker, Jacob, N,29027574.980.000.000.00574.98
Flores, Luke, L,247337.280.000.000.007.28
Edwards, Madeline,2077146.470.000.000.0046.47
Reed, Morgan, E,2877923.970.000.000.0023.97
Foster, Deb,215012661.400.000.002661.400.00
Ramirez, Emma,29072128.970.000.000.00128.97
Harris, Emily, P,1986298.480.000.000.0098.48
Morris, Richard,2007039.980.000.000.0039.98
Moore, Jonathan,2047896.460.000.000.0096.46
Baker, Allison,2649558.980.000.000.0058.98
Diaz, Luis, D,11203801.770.000.00124.99676.78
Roberts, Wyatt,15900699.970.000.00699.970.00
Richardson, Charles, I,121144719.020.000.002325.962393.06
Miller, Victoria,15816188.020.000.0081.46106.56
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Griffin, Julian, M,113284718.040.000.002319.992398.05
Powell, Vanessa,26630699.100.00699.100.000.00
Ramos, Kristi,151764703.030.000.000.004703.03
Prasad, Molly,243924329.610.003578.270.00751.34
Bell, Chase,180911750.980.000.000.001750.98
Bryant, Nathan,2145059.980.000.000.0059.98
Hall, Wyatt,2382713.980.000.000.0013.98
Davis, Daniel,11711999.220.000.0081.49917.73
Lal, Robert, L,14084138.680.000.000.00138.68
Robinson, William,20103103.480.000.000.00103.48
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Morgan, Andrea, M,16870149.040.000.00116.4432.60
Suri, Carolyn, S,12972175.710.000.000.00175.71
Martin, Morgan,248322181.560.002181.560.000.00
Mitchell, Lucas, C,198294533.453374.990.000.001158.46
Garcia, Christian, J,164913106.330.000.00751.342354.99
Alexander, Luke,290432447.050.000.002447.050.00
Blanco, Randall,263211554.410.000.001000.44553.97
King, Gabrielle,263504.990.000.000.004.99
Russell, Richard,2763322.260.000.000.0022.26
King, Caleb, J,2898678.980.000.000.0078.98
Peterson, Alex, M,13423132.900.000.000.00132.90
Turner, Jose,11784272.690.000.000.00272.69
Campbell, Angel, D,195461174.480.000.000.001174.48
Reed, Isaac, D,260747.280.000.000.007.28
James, Bryce,13466133.450.000.000.00133.45
Phillips, Andrea,1857383.740.000.000.0083.74
Cook, Seth,2301064.470.000.000.0064.47
Gonzales, Ashley, C,1860051.970.000.000.0051.97
Watson, Devin, A,18875114.950.000.000.00114.95
Ward, Eduardo, I,139162354.980.000.000.002354.98
Hayes, Hannah, J,2165656.970.000.000.0056.97
Hill, Fernando,247634.990.000.000.004.99
Ross, Rachel, C,206693169.590.000.002049.101120.49
Coleman, Wyatt, M,2328439.980.000.000.0039.98
Bell, Garrett, J,14265161.230.000.000.00161.23
Sanchez, Grace,120802354.990.000.000.002354.99
Gonzales, Emily, P,21777180.980.000.000.00180.98
Powell, Angela, R,12970471.110.000.000.00471.11
Russell, Xavier,12964119.950.000.000.00119.95
Campbell, Natalie, L,115122319.990.000.000.002319.99
Perez, Kaitlyn, A,120812366.960.000.000.002366.96
Torres, Dalton,235037.280.000.007.280.00
Griffin, Miguel,2146476.970.000.000.0076.97
Alexander, Paige, W,1860459.250.000.0037.2721.98
Martinez, Carol, D,17656578.460.000.000.00578.46
Rivera, Amanda,11131115.920.000.000.00115.92
Sanders, Sean,14341175.150.000.000.00175.15
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Brooks, Ian, W,2829064.470.000.000.0064.47
Gonzales, Paige,2170291.940.000.0039.9851.96
Coleman, Dylan,27403132.970.000.000.00132.97
Simmons, Anna, K,124512367.920.000.000.002367.92

Generated 2025-11-06 05:27:09.510 UTC