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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Cooper, Ariana,17348205.420.000.000.00205.42
White, Edward, J,15847205.460.000.000.00205.46
Washington, Victoria,235577.280.000.000.007.28
Perry, Ana,112151155.520.000.00292.94862.58
Thompson, Ryan, M,113301111.360.000.00198.94912.42
Garcia, Henry, B,112871009.240.000.00219.26789.98
Washington, Aaron, L,246494.990.000.000.004.99
Barnes, Ian, M,16106133.540.000.000.00133.54
Taylor, Brianna,17027230.900.000.00145.4285.48
Lewis, Zachary, L,14760167.260.000.000.00167.26
Gomez, Rebekah,13486225.440.000.000.00225.44
Roberts, Robert, R,1898656.970.000.0056.970.00
Zhao, Clarence, R,1982671.970.000.0071.970.00
Xu, Louis,2010466.530.000.0066.530.00
Hill, Carlos,12919257.880.000.00158.9398.95
Morgan, Andrea, M,16870149.040.000.00116.4432.60
Bryant, Kyle,231644807.100.003578.271228.830.00
Roberts, Mason, D,111761106.680.000.00494.64612.04
Peterson, Brian,12892419.470.000.00156.27263.20
Patterson, Eric, A,2738478.980.000.000.0078.98
White, James,253317.280.000.000.007.28
Wilson, Tyler, L,15879196.930.000.000.00196.93
Gonzalez, Morgan,130651700.990.000.000.001700.99
Carter, Katherine,11861286.300.000.000.00286.30
Davis, James,11922275.500.000.0034.98240.52
Campbell, Alex,119844730.320.000.002329.982400.34
Gray, Sara,292472447.050.000.002447.050.00
Price, Marissa,15826160.740.000.00120.4840.26
Sanders, Angel,16219553.970.000.000.00553.97
Gomez, Krista,12760273.180.000.0036.27236.91
Ware, Dennis, L,237254828.110.003578.270.001249.84
Alexander, Elijah,11738331.680.000.00141.73189.95
Martin, Noah, A,1765775.970.000.0075.970.00
Campbell, Chloe,11212760.930.000.00231.72529.21
Robinson, Emily,12183228.420.000.0054.96173.46
Martinez, Andrew, C,11530523.810.000.00142.94380.87
Baker, Sara, M,11827512.470.000.00148.47364.00
Richardson, Arianna, C,1205534.980.000.0034.980.00
Phillips, James, G,16846180.950.000.00123.9856.97
Scott, Eric,282484.990.000.004.990.00
Alexander, Aidan,17387148.190.000.0056.9791.22
Robinson, Joseph,2814194.480.000.0094.480.00
Jenkins, Alexandra, D,11632924.610.000.00160.51764.10
Price, Oscar, G,11833240.010.000.000.00240.01
Harris, Jeremiah, B,170231735.980.000.000.001735.98
Baker, Isaiah,12106169.540.000.000.00169.54
Barnes, Fernando,113001390.550.000.00248.381142.17
Ward, Ian,12056213.920.000.000.00213.92
Brown, Jonathan,11875265.420.000.000.00265.42
Morgan, Juan, C,1882191.970.000.000.0091.97
Harris, Isabella,17119214.900.000.0077.96136.94
Campbell, Angel, D,195461174.480.000.000.001174.48
Walker, Destiny, M,169961754.980.000.000.001754.98
Cooper, Paige,14119148.940.000.000.00148.94
Roberts, Jordan, M,1680039.250.000.000.0039.25
Powell, Ian,2608564.470.000.000.0064.47
Gonzales, Nathan, M,12107222.230.000.0032.27189.96
Wang, Austin, A,1463284.970.000.009.9974.98
Adams, Kyle, E,1881269.990.000.0069.990.00
Zhang, Heather,166543056.320.000.00751.342304.98
James, Emma,127812329.980.000.000.002329.98
Henderson, Olivia,188591155.480.000.000.001155.48
Powell, Jack, J,1841156.960.000.000.0056.96
Sanchez, Allison,1666741.720.000.000.0041.72
Cooper, Amanda, P,146064716.020.000.000.004716.02
Richardson, Nathaniel,120894710.030.000.002316.972393.06
Davis, Dylan,15556588.960.000.00588.960.00
White, Nicole,16731155.910.000.0084.9670.95
Scott, Adam,15863243.010.000.000.00243.01
Gonzales, Ashley, C,1860051.970.000.000.0051.97
Edwards, Eric,2462768.490.000.000.0068.49
Russell, Samantha,11211723.560.000.00118.46605.10
Brown, Anna,1624795.820.000.000.0095.82
Lee, John,19801193.010.000.000.00193.01
Powell, Spencer,14904468.120.000.000.00468.12
Rogers, Andrea, L,14328308.660.000.00112.95195.71
Johnson, Jonathan,220597.280.000.000.007.28
Parker, Eduardo, M,12939169.420.000.0077.9291.50
Hill, Katherine, L,2670139.980.000.000.0039.98
Yang, Justin, S,153634719.040.000.000.004719.04
Turner, Jose,11784272.690.000.000.00272.69
Jones, Nicole,14504112.270.000.000.00112.27
Reed, Bryan,18884133.930.000.000.00133.93
Young, Sierra, J,11619634.840.000.0034.99599.85
Ross, Natalie, J,12916261.220.000.000.00261.22
Thomas, Thomas,216292624.080.000.002049.10574.98
Hall, Elizabeth, L,13474339.480.000.000.00339.48
Ward, Angela, M,2775669.990.000.000.0069.99
Patterson, Nicole,1972937.270.000.000.0037.27
Young, Julia, J,274144.990.000.000.004.99
Sanchez, Alex, K,131014736.030.000.000.004736.03
Campbell, Kevin, S,121774811.500.000.002404.462407.04
Chapman, Nancy, E,11276840.150.000.0066.26773.89
Fernandez, Darren,2899278.980.000.000.0078.98
Perry, Dalton, A,16149192.040.000.000.00192.04
Allen, Amanda,2235339.980.000.000.0039.98
Rivera, Caitlin, L,261132730.540.000.002181.56548.98
Parker, James,11808610.190.000.00186.77423.42
Diaz, Luke,12054402.530.000.00139.97262.56
Perry, Ryan,132494795.340.000.000.004795.34
Cook, Bryce,2864069.990.000.000.0069.99
Reed, Sean, L,145974803.310.000.000.004803.31
Peterson, Jared,11502829.370.000.00171.95657.42
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Simmons, Jennifer,112621010.560.000.00207.93802.63
Rogers, Jared, J,12166162.220.000.000.00162.22
Simmons, James,198844588.450.003399.990.001188.46
Thomas, Victoria, A,15536249.530.000.000.00249.53
Bailey, Hailey, R,262704.990.000.000.004.99
Morris, Mackenzie, N,2647413.980.000.000.0013.98
Parker, Katherine,13268289.700.000.0068.97220.73
Turner, Adam, K,16109548.980.000.000.00548.98
Malhotra, Kristi, S,151754850.330.000.000.004850.33
Chavez, Kara, P,13285214.350.000.0012.94201.41
Jenkins, Megan, R,12074261.380.000.000.00261.38
Hernandez, Marcus,185952329.990.000.000.002329.99
Collins, Nathan, F,197041143.460.000.000.001143.46
Lopez, Jack, I,2904751.460.000.000.0051.46
Murphy, Olivia, V,202063204.580.002049.100.001155.48
Carter, Sydney,12959203.920.000.000.00203.92
Hall, Charles,234764.990.000.000.004.99
Sandberg, Nicole, M,12077144.690.000.0094.4650.23
Green, Blake, P,11719287.200.000.000.00287.20
Carter, Madeline, A,2752269.990.000.000.0069.99
Hughes, Eduardo,15564188.520.000.000.00188.52
Morris, Alyssa,28072548.980.000.000.00548.98
Hall, Kyle, J,1749169.970.000.000.0069.97
Harris, Destiny, M,137102341.460.000.000.002341.46
Chow, Candice,1923260.960.000.000.0060.96
Hill, Blake,11748131.540.000.000.00131.54
Simmons, Jose,2464739.980.000.000.0039.98
Long, Gabrielle,198305765.923374.990.000.002390.93
Ward, Jade, D,14661195.020.000.000.00195.02
Nelson, Jennifer,171471700.990.000.000.001700.99
Collins, Alex, S,287812.290.000.000.002.29
Griffin, Jennifer, B,14244154.960.000.000.00154.96
Foster, Edward, R,18355150.950.000.000.00150.95
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Davis, Jasmine, M,265291549.420.000.001000.44548.98
Ross, Alexia, S,13231247.900.000.000.00247.90
Sun, Arturo, C,11498557.540.000.0072.92484.62
Scott, Haley,13701154.540.000.000.00154.54
Griffin, Isabelle,249864.990.000.000.004.99
Collins, Xavier, C,16646250.910.000.000.00250.91
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
Davis, Ethan,136604750.010.000.000.004750.01
Mitchell, Caleb, K,268064.990.000.000.004.99
Diaz, Richard, A,2668264.470.000.000.0064.47
White, Tyler,14291258.440.000.0049.97208.47
Suri, Carolyn, S,12972175.710.000.000.00175.71
Henderson, Luke,19200109.240.000.000.00109.24
Nelson, Luis,234884.990.000.000.004.99
Liu, Arturo,13222150.410.000.0013.98136.43
Alexander, Lauren,189502351.960.000.000.002351.96
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Wilson, Grace,17539205.920.000.000.00205.92
Lopez, Eduardo, J,266401288.060.00699.100.00588.96
Hall, Noah, A,1525175.250.000.000.0075.25
Barnes, Elizabeth, J,249397.280.000.000.007.28
Chen, James, D,11641303.200.000.0021.49281.71
Long, Sydney,279217.280.000.000.007.28
Gray, Mackenzie, L,1768056.970.000.000.0056.97
Hughes, Destiny, P,28027119.980.000.000.00119.98
Roberts, Seth, H,11510258.150.000.0039.47218.68
Anderson, Isabella,137432349.980.000.000.002349.98
Moore, Matthew, W,13267109.950.000.000.00109.95
Phillips, Kyle,12158202.200.000.000.00202.20
Campbell, Isabella, C,203503226.900.002071.420.001155.48
Long, Jordyn,1733847.250.000.000.0047.25
Rodriguez, Taylor,1607166.960.000.000.0066.96
Rogers, Jade, I,14332102.250.000.000.00102.25
Russell, Samuel, V,11652310.930.000.000.00310.93
Diaz, Elijah,200004495.480.003374.990.001120.49
Russell, Melanie, B,15478182.830.000.00167.8514.98
Harris, Samantha, A,244874.990.000.000.004.99
Washington, Hailey, S,2588559.980.000.000.0059.98
Fernandez, Cesar,200355694.980.003374.990.002319.99
Adams, Kaitlyn, A,11869239.600.000.0037.27202.33
Smith, Noah,13175166.920.000.000.00166.92
Cox, Nathaniel, A,196612521.270.000.000.002521.27
Henderson, Abigail,2044139.980.000.000.0039.98
Nelson, Kevin,1476584.970.000.000.0084.97
Ramirez, Ian,166783162.310.000.00742.352419.96
Hall, Kaylee, E,1975137.270.000.000.0037.27
Murphy, Maria,160113657.260.000.000.003657.26
Allen, Allison, A,1975737.270.000.000.0037.27
Perez, Amber, D,13318214.260.000.00116.9197.35
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Robinson, Zachary, L,137092332.280.000.000.002332.28
Jai, Hunter, M,28272111.950.000.000.00111.95
Hill, Alexandra, K,15172215.450.000.0036.27179.18
Mitchell, Alexandra,14455218.930.000.0023.97194.96
Henderson, Eduardo, R,14359256.240.000.0078.98177.26
Allen, Sean, L,12097159.220.000.000.00159.22
Martinez, Jonathan,1330366.250.000.000.0066.25
Watson, Devin, A,18875114.950.000.000.00114.95
James, Jeremiah, S,11661287.700.000.000.00287.70
Rodriguez, Richard,12969180.790.000.000.00180.79
Perry, Jennifer, J,221205962.340.003578.272384.070.00
Price, Riley, R,139094764.020.000.000.004764.02
Roberts, Rebecca,2800094.480.000.000.0094.48
Young, Kaylee, S,13756298.490.000.0058.47240.02
Gonzales, Cameron, L,2900569.990.000.0069.990.00
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Thomas, Zachary, D,28045119.980.000.000.00119.98
Barnes, Emily, G,15996564.990.000.000.00564.99
Ross, Kelly,2607676.960.000.000.0076.96
Brown, Julia,18065155.470.000.000.00155.47
Perry, Marcus, L,206563245.900.000.002071.421174.48
Taylor, Christian,2076456.760.000.000.0056.76
Patterson, Taylor,12147271.450.000.000.00271.45
Patterson, Abigail, H,144784795.010.000.000.004795.01
Cooper, Jacqueline, S,27634567.760.000.000.00567.76
Phillips, Devin,18759112.060.000.000.00112.06
Hall, Jan, M,11740334.120.000.00235.1598.97
Coleman, Luke, A,11723152.550.000.0069.9882.57
Mehta, Carmen, C,2743694.480.000.000.0094.48
Bell, Julia,216522646.060.000.002646.060.00
Foster, Carson, L,16959135.350.000.0085.4849.87
Flores, Arianna,217274132.243578.270.000.00553.97
Anand, Brendan, L,1984721.980.000.000.0021.98
Winston, Ethan, R,216222612.060.000.002049.10562.96
Deng, Wayne,2145336.960.000.0036.960.00
Green, Isabella,26620699.10699.100.000.000.00
Mitchell, Thomas, J,137112380.470.000.000.002380.47
Wilson, Victoria, R,27536782.990.000.00782.990.00
Jai, Samuel, L,1635887.950.000.0039.9947.96
Price, Miranda,26629699.10699.100.000.000.00
Henderson, Jeremiah, D,189612369.960.000.000.002369.96
Blue, Marcus, L,27550782.990.000.00782.990.00
Williams, Destiny, S,15881564.990.000.00564.990.00
Ye, Alisha, J,220084141.233578.270.000.00562.96
Long, Natalie,14363192.340.000.000.00192.34
Washington, Alexia,27613782.990.000.00782.990.00
Rogers, Shelby,11712127.800.000.0042.5985.21
Bailey, Richard, N,220504160.533578.270.000.00582.26
Moreno, Lance, A,2922939.980.000.000.0039.98
Miller, Kayla, A,236734.990.000.000.004.99
Washington, Miranda,152014793.020.000.000.004793.02
Flores, Zachary, H,233765314.250.003578.270.001735.98
Sanders, Allison, B,18852268.250.000.000.00268.25
Wilson, Nathan, L,13936218.930.000.000.00218.93
Clark, Joseph, D,153954780.020.000.000.004780.02
Powell, Vanessa,26630699.100.00699.100.000.00
Smith, Austin,13707149.050.000.000.00149.05
She, Shawn, J,16902141.980.000.000.00141.98
Powell, Jordyn, K,153914828.010.000.000.004828.01
Bennett, Jordyn, L,222304223.230.003578.270.00644.96
Gutierrez, Neil, L,214897.280.000.000.007.28
Yuan, Leonard, F,167911729.970.000.000.001729.97

Generated 2025-11-03 08:01:25.185 UTC