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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Griffin, Miguel,2146476.970.000.000.0076.97
Evans, Dalton, E,127104774.040.000.002354.982419.06
Phillips, Isaiah,28631144.470.000.00144.470.00
Rodriguez, Anthony, G,238294802.110.003578.270.001223.84
Martin, Samuel,15874225.440.000.0069.99155.45
Barnes, Ian, M,16106133.540.000.000.00133.54
Harris, Natalie,2368259.980.000.0059.980.00
Miller, Victoria,15816188.020.000.00118.0569.97
Flores, Gabriel,271117.280.000.000.007.28
Hill, Carlos,12919257.880.000.00158.9398.95
Adams, Jennifer,153624745.020.000.000.004745.02
Stewart, Melissa,2517336.960.000.000.0036.96
Foster, Isabelle,2637739.980.000.000.0039.98
Thompson, Kayla, D,12363273.900.000.0049.97223.93
Rodriguez, Richard,12969180.790.000.000.00180.79
Griffin, James,28189567.760.000.000.00567.76
Walker, Emma, M,2520998.960.000.000.0098.96
Roberts, Noah, S,2704268.490.000.000.0068.49
Stewart, Alex, M,2008463.150.000.000.0063.15
Martin, John, A,144364776.010.000.000.004776.01
Washington, Alexis,1978146.260.000.007.2838.98
Diaz, Gabrielle,14893839.480.000.000.00839.48
Mitchell, Bailey, B,267067.280.000.007.280.00
Perry, Dalton, A,16149192.040.000.000.00192.04
Reed, Michelle,2804669.990.000.000.0069.99
Wright, Robert, C,158894848.030.000.000.004848.03
Perry, Jackson, J,213064.990.000.000.004.99
Reed, Morgan, E,2877923.970.000.000.0023.97
Parker, Madeline, H,221826006.320.003578.270.002428.05
Huang, Kristen,251002443.350.002443.350.000.00
Long, Jordan,199884555.470.003399.990.001155.48
Reed, Gabriella, A,2743778.980.000.000.0078.98
Nelson, Kevin,1476584.970.000.000.0084.97
Coleman, Dylan,27403132.970.000.000.00132.97
Jenkins, Dakota, D,2067964.470.000.0064.470.00
Yang, Thomas, A,14108839.480.000.000.00839.48
Lewis, Rachel, J,14900839.480.000.000.00839.48
Rodriguez, Taylor,1607166.960.000.000.0066.96
Jones, Michael, A,2210771.970.000.000.0071.97
Lu, Alejandro,2562039.980.000.000.0039.98
Gutierrez, Jerome,127832420.460.000.000.002420.46
Robinson, Madison, W,183772394.970.000.000.002394.97
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Nath, Carl, H,29001624.970.000.000.00624.97
Moore, Chloe, L,2626913.980.000.000.0013.98
Lee, Ian,19646197.040.000.000.00197.04
Griffin, Xavier,228775962.340.003578.270.002384.07
Luo, Jodi,2921368.490.000.000.0068.49
Roberts, Carlos,2319639.980.000.000.0039.98
Roberts, Amanda,171752334.980.000.000.002334.98
Scott, Kaitlyn, A,12159218.910.000.00133.9684.95
Moore, Hunter,14897196.270.000.0071.58124.69
Harris, Joshua, L,2028095.940.000.0030.9764.97
Hughes, Nathan, B,121134737.530.000.002294.992442.54
Brooks, Steven, C,14877889.470.000.000.00889.47
Simmons, David, E,120172339.970.000.002339.970.00
Gonzales, Brianna, L,211483223.580.000.002049.101174.48
Murphy, Shelby,244894.990.000.000.004.99
Russell, Fernando,27084782.990.000.00782.990.00
Gonzales, Cameron, L,2900569.990.000.0069.990.00
Bradley, Jocelyn,230227.280.000.000.007.28
Gonzalez, Logan, J,1748364.500.000.0032.2832.22
Parker, Morgan, S,1677236.960.000.0014.9821.98
Rivera, Rachel, S,2899678.980.000.000.0078.98
Martin, Brianna, M,235834829.390.003578.270.001251.12
Davis, Thomas,167641760.470.000.000.001760.47
Patterson, Eric, A,2738478.980.000.000.0078.98
Turner, Wyatt,200345769.960.003399.990.002369.97
Sanchez, Faith,270494.990.000.000.004.99
James, Adrian, C,253404.990.000.000.004.99
Anderson, Jasmine, A,235534.990.000.000.004.99
Rogers, Olivia,12020804.470.000.000.00804.47
Clark, William,2902169.990.000.000.0069.99
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Wang, Karen, P,1955331.970.000.000.0031.97
Stewart, Alexandria,174761700.990.000.000.001700.99
Peterson, Morgan, J,168341750.980.000.000.001750.98
Long, Natalie,14363192.340.000.000.00192.34
Murphy, Eduardo, S,16124614.450.000.000.00614.45
Bell, Julia,216522646.060.000.002646.060.00
Rodriguez, Lucas, P,15942191.870.000.000.00191.87
Collins, Isaac,260777.280.000.000.007.28
Stewart, Cody, A,212843223.580.000.002049.101174.48
Howard, Morgan, T,229713578.270.003578.270.000.00
Rogers, Amanda, A,13920266.970.000.000.00266.97
Lal, Kyle,17360122.180.000.000.00122.18
Sanchez, Lucas, L,233514828.110.003578.270.001249.84
Chen, Jack, E,17579151.430.000.000.00151.43
Butler, Jackson, J,183241735.980.000.000.001735.98
Gomez, Briana, A,2878443.980.000.000.0043.98
Flores, Morgan,19817118.940.000.0039.9878.96
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Green, Kaylee, C,2618567.970.000.000.0067.97
Long, Julia, R,228895971.330.003578.270.002393.06
Green, Gabrielle, M,2181564.470.000.000.0064.47
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Sanders, Lucas, W,268024.990.000.000.004.99
Perry, Justin, E,167583062.340.000.000.003062.34
Parker, Natalie, A,251043018.330.002443.350.00574.98
Morgan, Isabella, L,28602144.470.000.000.00144.47
Thomas, Jessica,1684894.480.000.0094.480.00
Lewis, Jeremiah,1437187.260.000.0049.9737.29
Russell, Jessica,265721000.440.000.001000.440.00
Foster, Nicole, A,2349489.970.000.000.0089.97
Nelson, Jose,19217185.020.000.0091.9593.07
Price, Jocelyn, D,258752443.350.002443.350.000.00
Martin, Gina, E,11078793.270.000.00158.36634.91
Williams, Ethan,243094793.120.003578.270.001214.85
Henderson, Gabrielle, B,186031205.470.000.000.001205.47
Morris, Alyssa,28072548.980.000.000.00548.98
Thomas, Thomas,216292624.080.000.002049.10574.98
Campbell, Hailey,15507267.840.000.00228.9638.88
Martinez, Andrew, C,11530523.810.000.00142.94380.87
Hernandez, Jamie,27283119.980.000.00119.980.00
Cooper, Amanda, P,146064716.020.000.000.004716.02
Srini, Ruben,18078200.940.000.0071.97128.97
Ward, Stephanie, A,27429782.990.000.00782.990.00
Stewart, Makayla,16649115.940.000.000.00115.94
Russell, Melanie, B,15478182.830.000.00167.8514.98
Hill, Timothy,14871848.470.000.000.00848.47
Carter, Madeline, A,2752269.990.000.000.0069.99
Collins, Connor, J,27270782.990.000.00782.990.00
Malhotra, Brenda,133912405.470.000.000.002405.47
Bell, Timothy, J,2810178.980.000.0078.980.00
Garcia, Chloe, M,110372374.230.000.002374.230.00
Washington, Adam, G,2543713.980.000.000.0013.98
Richardson, Victoria, C,248172181.560.002181.560.000.00
Edwards, Connor,16950211.010.000.000.00211.01
Simmons, Sarah, V,11500651.980.000.00118.96533.02
Stewart, Allison, R,18826166.430.000.0069.9996.44
Yang, Justin, S,153634719.040.000.000.004719.04
Thomas, David,168363193.790.000.000.003193.79
Lewis, Ryan, A,203124.990.000.000.004.99
Garcia, Lucas,27545782.990.000.00782.990.00
Mehta, Carmen, C,2743694.480.000.000.0094.48
Wright, Jackson,11698225.950.000.000.00225.95
Garcia, Xavier, M,2030071.970.000.000.0071.97
Johnson, Cameron, R,137201155.480.000.000.001155.48
Zhang, Nathan, L,2910478.980.000.000.0078.98
Alexander, Lauren,189502351.960.000.000.002351.96
Long, Sarah,173721729.970.000.000.001729.97
Rivera, Hailey, R,2079239.980.000.000.0039.98
Sara, Ivan, L,2509067.930.000.000.0067.93
Miller, Joseph, A,227134148.190.003578.270.00569.92
Ross, Seth, M,184332329.980.000.000.002329.98
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Martinez, Dominique,287888.990.000.008.990.00
Alexander, Logan, E,191161183.470.000.000.001183.47
Robinson, Lauren,2719668.490.000.0068.490.00
Evans, Kaylee,19642133.540.000.000.00133.54
Rogers, Shelby,11712127.800.000.0042.5985.21
Lewis, Morgan,17410168.740.000.000.00168.74
Lopez, Jack, I,2904751.460.000.000.0051.46
Young, Adam,12984200.200.000.00107.2692.94
Edwards, Hunter,2422067.930.000.000.0067.93
Adams, Kyle, E,1881269.990.000.0069.990.00
Martin, Joshua, A,276077.280.000.007.280.00
Jackson, Brianna,1537797.910.000.0074.9822.93
Coleman, Luke, A,11723152.550.000.0069.9882.57
Bryant, Isabella, L,229956060.500.003578.270.002482.23
Watson, Cole, A,217684118.263578.270.000.00539.99
Carter, Savannah, M,120902350.960.000.000.002350.96
Green, Marcus, C,15974208.410.000.0091.95116.46
Scott, Sean, F,2475539.980.000.000.0039.98
Patterson, Austin, O,270247.280.000.000.007.28
Diaz, Trevor, B,2051954.960.000.000.0054.96
Powell, Katherine, C,14574177.600.000.000.00177.60
Washington, Miranda,152014793.020.000.000.004793.02
Rivera, Ariana,261734.990.000.000.004.99
Flores, Miguel,1975077.250.000.000.0077.25
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Harris, Megan,232814828.110.003578.271249.840.00
Deng, Wayne,2145336.960.000.0036.960.00
Baker, Sara, M,11827512.470.000.00148.47364.00
Chandra, Brandy, P,11501603.530.000.0098.23505.30
Watson, Olivia, S,1386093.850.000.0014.9878.87
Garcia, Henry, B,112871009.240.000.00234.49774.75
Alexander, Edward, E,18524195.950.000.000.00195.95
Perez, Timothy, L,227304.990.000.000.004.99
Hughes, Julia,250612443.350.002443.350.000.00
Washington, Ryan,2833294.480.000.000.0094.48
Hughes, Antonio, P,15913712.270.000.00712.270.00
Jai, Luis, A,18320185.920.000.000.00185.92
Green, Gabriella, C,2803569.990.000.000.0069.99
Barnes, Blake, A,178651789.970.000.000.001789.97
Taylor, Ryan,170251709.980.000.000.001709.98
Brown, Christian,227554.990.000.000.004.99
Stewart, Grace, H,247737.280.000.000.007.28
Bryant, Rachel,220197.280.000.007.280.00
Thompson, Brianna, X,1864269.970.000.000.0069.97
Hall, Jose, J,17601225.420.000.00155.4569.97
Adams, Mackenzie, A,14640812.420.000.000.00812.42
Rogers, Paige, H,17125539.990.000.000.00539.99
Gonzalez, Amber, L,2387964.470.000.0064.470.00
Hall, Amber,20106131.950.000.000.00131.95
Miller, Destiny,251577.280.000.000.007.28
Russell, Caleb,23552103.480.000.000.00103.48
Gray, Mackenzie, L,1768056.970.000.000.0056.97
Allen, Aaron, A,200753399.990.003399.990.000.00
Bailey, Lauren,15864103.550.000.000.00103.55
Ross, Kaitlyn,16121614.470.000.000.00614.47
Brooks, Jennifer, L,17411155.470.000.000.00155.47
Wilson, Madison, H,1982821.980.000.000.0021.98
Russell, Megan,16220562.960.000.000.00562.96
Martin, Kellie, R,28195574.980.000.000.00574.98
Simmons, Brittany,2923139.980.000.000.0039.98
Gonzalez, Jordan,15157213.940.000.00123.9889.96
Peterson, Brian,12892419.470.000.00156.27263.20
Sanchez, Adrian, L,13179190.170.000.000.00190.17
Anderson, Tyler, E,131481137.430.000.001137.430.00
Jones, Kayla, C,1854194.260.000.000.0094.26
Moreno, Lance, A,2922939.980.000.000.0039.98
Martinez, Kristina, S,2134529.930.000.000.0029.93
Flores, Julian,158464943.320.000.000.004943.32
Sanchez, Shelby,16021539.990.000.000.00539.99
Brown, Nicholas, S,11506675.640.000.00121.93553.71
Harris, Samuel, M,2477159.980.000.0059.980.00
Henderson, Hailey, C,171481775.470.000.000.001775.47
Washington, Christian, R,2668639.980.000.000.0039.98
Hughes, Brittany,14387898.460.000.000.00898.46
Harris, Samantha, A,244874.990.000.000.004.99
Flores, Hannah,1952540.230.000.000.0040.23
Yuan, Brendan, S,247444.990.000.000.004.99
Zhao, Clarence, R,1982671.970.000.0071.970.00
Price, Isabelle,201825749.970.003374.990.002374.98
Rodriguez, Joshua, A,235114843.110.003578.270.001264.84
Ye, Alisha, J,220084141.233578.270.000.00562.96
Garcia, Victoria, V,245013578.270.003578.270.000.00
Morgan, Jada, A,11520702.990.000.00137.45565.54
Thompson, Jose,237314828.110.003578.270.001249.84
Price, Miranda,26629699.10699.100.000.000.00
Ramirez, Melanie, V,163632481.820.000.002481.820.00
King, Jordan, C,110202316.970.000.002316.970.00
Russell, Samantha,11211723.560.000.00118.46605.10
Hall, Noah, A,1525175.250.000.000.0075.25
Davis, Marcus, T,17337123.910.000.0086.9536.96
Wagner, Alexandra, E,2324439.980.000.000.0039.98
Sanchez, Allison,1666741.720.000.000.0041.72
Brown, Dalton, N,218134118.263578.270.000.00539.99
Martinez, Jill,242354829.390.003578.270.001251.12
Collins, Alex, S,287812.290.000.000.002.29
Miller, Chloe, V,228936056.510.003578.272478.240.00
White, Greg, C,174032322.280.000.000.002322.28
Cooper, Ariana,17348205.420.000.000.00205.42
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Martinez, Carol, D,17656578.460.000.000.00578.46
Jenkins, Samantha,113311290.330.000.00410.31880.02
Shan, Benjamin,235663578.270.003578.270.000.00
Green, Xavier,2356739.980.000.000.0039.98
Richardson, Lauren, C,14867839.480.000.000.00839.48

Generated 2025-11-01 01:48:58.753 UTC