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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Tang, Carl,2123832.270.000.000.0032.27
Li, Eugene, A,15283865.950.000.000.00865.95
Carter, Marcus, l,2147131.970.000.000.0031.97
Turner, Andrea, A,202093268.550.002049.100.001219.45
Ross, Antonio,18322148.890.000.000.00148.89
Brown, Julia,18065155.470.000.000.00155.47
Gray, Jesse,14626197.040.000.000.00197.04
Coleman, Ian,2127639.980.000.000.0039.98
Griffin, Maria,1840763.250.000.000.0063.25
Jackson, Andrew,2047985.480.000.000.0085.48
Smith, Katherine, J,13197105.190.000.000.00105.19
Turner, Kaylee, M,16213154.540.000.000.00154.54
Patterson, Maria, G,1333094.950.000.000.0094.95
Rogers, Olivia,12020804.470.000.000.00804.47
Green, Isabella,26620699.10699.100.000.000.00
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
Morris, Paige, W,220414167.233578.270.000.00588.96
Lewis, Brianna, H,14282166.240.000.0074.9891.26
Collins, Lucas, T,219214142.753578.270.000.00564.48
Jai, Hunter, M,28272111.950.000.000.00111.95
Parker, Jennifer, D,221184158.240.003578.270.00579.97
Gonzales, Melissa, W,204704408.690.000.002071.422337.27
Bennett, Jordyn, L,222304223.230.003578.270.00644.96
Wright, Kaitlyn, G,134342354.990.000.000.002354.99
Miller, Joseph, A,227134148.190.003578.270.00569.92
Simmons, Sarah, V,11500651.980.000.00118.96533.02
Brooks, Makayla,222526047.320.003578.270.002469.05
Cooper, Amanda, P,146064716.020.000.000.004716.02
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
Moore, Matthew, W,13267109.950.000.000.00109.95
Suarez, Juan, R,167631700.990.000.000.001700.99
Murphy, Shelby,244894.990.000.000.004.99
Hill, Fernando,247634.990.000.000.004.99
Sanchez, Adrian, L,13179190.170.000.000.00190.17
Wright, Jackson,11698225.950.000.000.00225.95
Thompson, Ethan,199894495.480.003374.990.001120.49
Foster, Eric,229765971.330.003578.270.002393.06
Diaz, Elijah,200004495.480.003374.990.001120.49
Anderson, Megan, A,238594153.250.003578.27574.980.00
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
Evans, Luke,2917615.230.000.000.0015.23
Thomas, Samantha,2169093.970.000.000.0093.97
Reed, Marcus,14582111.790.000.0014.9896.81
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
Sharma, Yolanda, K,250483046.840.002443.35603.490.00
Watson, Kimberly, A,201883226.900.002071.420.001155.48
Ross, Haley, T,253612443.350.002443.350.000.00
Zhao, Karen, L,254082735.530.002181.560.00553.97
Hughes, Stephanie,263161000.440.001000.440.000.00
Cook, Steven, J,27053782.990.00782.990.000.00
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
Ross, Alexia, S,13231247.900.000.000.00247.90
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
Walker, Jasmine,134604693.040.000.000.004693.04
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
Reed, Mariah,263731565.910.000.001000.44565.47
Wilson, Christian,27085782.990.000.00782.990.00
Davis, Justin,2807412.940.000.000.0012.94
Rodriguez, Alexandra,216422620.400.000.002071.42548.98
Fernandez, Ruth,205463246.550.000.002049.101197.45
Alexander, Julia, J,15291889.470.000.000.00889.47
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Garcia, Benjamin, L,175951785.970.000.000.001785.97
Coleman, Dylan,27403132.970.000.000.00132.97
Peterson, Julia, P,16497132.710.000.000.00132.71
Long, Natalie,14363192.340.000.000.00192.34
Perry, Ana,112151155.520.000.00292.94862.58
Walker, Thomas,1307193.980.000.000.0093.98
Hayes, Logan, J,19026113.240.000.0037.2775.97
Barnes, Kaitlyn, Z,15162154.960.000.000.00154.96
Jones, Samantha,1831721.980.000.000.0021.98
Turner, Wyatt,200345769.960.003399.990.002369.97
Collins, Amanda,2078339.980.000.000.0039.98
Ross, Kaitlyn,16121614.470.000.000.00614.47
James, Bryce,13466133.450.000.000.00133.45
Jones, Dalton, T,189512334.970.000.000.002334.97
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Gonzales, Jordan,2368113.980.000.000.0013.98
Howard, Erin, L,183621725.210.000.000.001725.21
Torres, Mariah,16380195.950.000.000.00195.95
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Baker, Eduardo,180921789.450.000.000.001789.45
Barnes, Ian, M,16106133.540.000.000.00133.54
Hall, Wyatt,2382713.980.000.000.0013.98
Flores, Luke, L,247337.280.000.000.007.28
Perry, Jackson, J,213064.990.000.000.004.99
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Thompson, Abigail,243324816.090.003578.270.001237.82
Thomas, Seth,14567161.280.000.0096.0765.21
Coleman, Isabel, S,12530337.900.000.00123.98213.92
Gonzalez, Molly,1637021.980.000.000.0021.98
Reed, Kaylee, R,17371151.920.000.000.00151.92
Hughes, Riley,2928449.990.000.000.0049.99
Roberts, Noah, S,2704268.490.000.000.0068.49
Patterson, Alexis,213484392.020.000.002049.102342.92
Lewis, Zachary, L,14760167.260.000.000.00167.26
Brown, Christian,227554.990.000.000.004.99
Patterson, Austin, O,270247.280.000.000.007.28
Ward, Destiny,16128539.990.000.000.00539.99
Carter, Jason,11724210.090.000.00113.8696.23
Howard, Danielle,28357133.490.000.000.00133.49
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Kelly, Bailey, R,28284563.770.000.000.00563.77
Taylor, Edward, C,17442319.880.000.00230.9088.98
Foster, Edward, R,18355150.950.000.000.00150.95
Washington, Adam, G,2543713.980.000.000.0013.98
Collins, Eduardo,139872329.990.000.000.002329.99
Kumar, Austin,204834400.060.000.002049.102350.96
Chen, David,2720839.980.000.000.0039.98
Kumar, Elijah,15197156.920.000.000.00156.92
Ramirez, Jennifer, E,213114472.580.000.002049.102423.48
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Anderson, Ashley,206803219.580.000.002049.101170.48
Sanders, Xavier,1672173.750.000.000.0073.75
Torres, Abigail,253674.990.000.000.004.99
Torres, Pedro, E,16958168.020.000.00153.0414.98
Sanchez, Alex, K,131014736.030.000.000.004736.03
Johnson, James,234984.990.000.000.004.99
Russell, Jacqueline,18391100.960.000.0078.9821.98
Wilson, Tyler, L,15879196.930.000.000.00196.93
Scott, Adam,15863243.010.000.000.00243.01
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Howard, Alexandra,207363194.580.000.002049.101145.48
Thompson, Devin,207084406.400.000.002071.422334.98
Stewart, Cody, A,212843223.580.000.002049.101174.48
Ward, Nicole, L,212724435.380.000.002071.422363.96
Campbell, Adam, A,214002688.890.000.002071.42617.47
Adams, Connor,214232888.560.000.002049.10839.46
Ward, Juan, H,215952649.560.000.002049.10600.46
Hayes, Carson, A,124472331.950.000.000.002331.95
Robinson, William,20103103.480.000.000.00103.48
Lal, Robert, L,14084138.680.000.000.00138.68
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
Lewis, Brandon, A,2903769.990.000.000.0069.99
Carter, Savannah, M,120902350.960.000.000.002350.96
Alexander, Nathan, A,187951198.970.000.000.001198.97
Liu, Arturo,13222150.410.000.0013.98136.43
Shan, Logan,1867760.960.000.0029.9930.97
Sanders, Hailey,19647282.040.000.000.00282.04
Luo, Franklin, J,2202759.980.000.000.0059.98
Price, Mariah, C,2074549.480.000.000.0049.48
Hayes, Luis,12880200.730.000.000.00200.73
Wagner, Alexandra, E,2324439.980.000.000.0039.98
Clark, Emily, R,120862294.990.000.000.002294.99
Jai, Jose,12944164.210.000.000.00164.21
Watson, Marcus,2271585.480.000.000.0085.48
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Ward, Stephanie, A,27429782.990.000.00782.990.00
Patterson, Grace, M,27560782.990.000.00782.990.00
Bryant, Zachary,216552648.070.000.002648.070.00
Griffin, Haley, L,1892582.180.000.000.0082.18
Hall, Kaylee, E,1975137.270.000.000.0037.27
Price, Lauren, J,14079184.740.000.0037.29147.45
Foster, Kayla,1969371.950.000.000.0071.95
Hayes, Jeremiah, W,20086128.550.000.0056.9771.58
She, Shawn, J,16902141.980.000.000.00141.98
Coleman, Spencer,15993597.260.000.000.00597.26
Nelson, Sierra,161322459.620.000.002459.620.00
Allen, Jack, M,291372419.060.000.002419.060.00
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Diaz, Hailey, W,116932294.990.000.002294.990.00
Howard, Natalie,1349154.960.000.0014.9839.98
Thomas, Jessica,1684894.480.000.0094.480.00
Bradley, Jocelyn,230227.280.000.000.007.28
Williams, Austin,2035432.220.000.000.0032.22
Bennett, Isabelle, C,1867421.980.000.000.0021.98
Watson, Richard,15943365.410.000.00154.98210.43
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Thompson, Brianna, X,1864269.970.000.000.0069.97
Martin, Thomas, A,169521735.980.000.000.001735.98
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Alexander, Paige, W,1860459.250.000.0037.2721.98
Griffin, Jordan,13095328.890.000.0069.97258.92
Green, Kaylee, C,2618567.970.000.000.0067.97
Perez, Jordan, A,292674.990.000.000.004.99
Thomas, Victoria, A,15536249.530.000.000.00249.53
Bell, Alex, M,167543118.600.000.00756.332362.27
Gill, Robyn, J,127651750.980.000.001750.980.00
Ross, Aaron, N,118882376.960.000.002376.960.00
Smith, Hannah, J,2526554.980.000.0054.980.00
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Harris, Noah,292562393.060.000.002393.060.00
Rogers, Amanda, A,13920266.970.000.000.00266.97
Bailey, Richard, N,220504160.533578.270.000.00582.26
Martin, Lucas, L,221144183.233578.270.000.00604.96
Mitchell, Jonathan, L,221095971.333578.270.002393.060.00
Perry, Jennifer, J,221205962.340.003578.272384.070.00
Perry, Melissa,221284142.230.003578.270.00563.96
Miller, Benjamin, G,26643699.100.00699.100.000.00
She, Martha, E,222515971.330.003578.270.002393.06
Williams, Ryan, R,222475978.610.003578.270.002400.34
Collins, Luis, J,227655978.610.003578.270.002400.34
Turner, Courtney, A,229753578.270.003578.270.000.00
Long, Morgan, H,213522625.390.000.002071.42553.97
Lu, Alejandro,2562039.980.000.000.0039.98
Young, Kaitlyn, J,2506213.980.000.000.0013.98
Parker, Natalie, A,251043018.330.002443.350.00574.98
Kelly, Haley,15511128.560.000.000.00128.56
Perez, Angel, S,213362628.350.000.002071.42556.93
Bryant, Isabella, L,229956060.500.003578.270.002482.23
Washington, Lauren, R,229985329.250.003578.271750.980.00
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Harris, Megan,232814828.110.003578.271249.840.00
Rodriguez, Anthony, G,238294802.110.003578.270.001223.84
Thompson, Jose,237314828.110.003578.270.001249.84
Rodriguez, Joshua, A,235114843.110.003578.270.001264.84
Chander, Wayne, S,243444329.610.003578.27751.340.00
King, Aaron, L,117394758.030.000.002359.982398.05
Bailey, Mariah, L,2724354.980.000.000.0054.98
Kelly, Angel, E,15418232.230.000.000.00232.23
Baker, Sean, T,247782858.490.002181.56676.930.00
Long, Caleb, P,250462181.560.002181.560.000.00
Green, Sophia, E,249772181.560.002181.560.000.00
Thomas, Charles,250942443.350.002443.350.000.00
Wood, Alexandria, M,248242181.560.002181.560.000.00
Richardson, Victoria, C,248172181.560.002181.560.000.00
Martin, Morgan,248322181.560.002181.560.000.00
Huang, Kristen,251002443.350.002443.350.000.00
Turner, Amanda, L,203183241.900.002071.420.001170.48
Carter, Luis, E,258832443.350.002443.350.000.00
Flores, Jordyn,252882721.550.002181.560.00539.99
Coleman, Lucas, A,27060782.990.000.00782.990.00
Harris, Edward,27062782.990.000.00782.990.00
Blanco, Randall,263211554.410.000.001000.44553.97
Cooper, Paige,14119148.940.000.000.00148.94
Hernandez, Haley, L,11769478.950.000.000.00478.95
Harris, Emily, P,1986298.480.000.000.0098.48
Green, Gabriella, C,2803569.990.000.000.0069.99

Generated 2025-11-07 03:03:04.538 UTC