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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Hughes, Brittany,14387898.460.000.000.00898.46
Hu, Gilbert, L,2876769.990.000.000.0069.99
James, Juan,232674862.090.003578.271283.820.00
Gonzalez, Morgan,130651700.990.000.000.001700.99
Ross, Elizabeth, E,141184741.340.000.000.004741.34
Sun, Arturo, C,11498557.540.000.007.95549.59
Rivera, Makayla, A,2878334.990.000.000.0034.99
Fernandez, Ruth,205463246.550.000.002049.101197.45
Simmons, Haley, T,262022749.320.000.002181.56567.76
Brooks, Victoria, H,16479158.510.000.000.00158.51
Jackson, Joseph, R,235925279.260.003578.270.001700.99
Walker, Jacob, N,29027574.980.000.000.00574.98
Smith, Hannah, J,2526554.980.000.0054.980.00
Peterson, Melissa, S,249954.990.000.000.004.99
Jones, Alexander, I,2002180.960.000.000.0080.96
Carter, Madeline, A,2752269.990.000.000.0069.99
Phillips, Miguel,2049812.940.000.000.0012.94
Luo, Jodi,2921368.490.000.000.0068.49
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Perry, Jennifer, J,221205962.340.003578.272384.070.00
Gonzales, Cameron, L,2900569.990.000.0069.990.00
Howard, Danielle,28357133.490.000.000.00133.49
Hughes, Edward,200234530.470.003374.990.001155.48
Price, Isabelle,201825749.970.003374.990.002374.98
Washington, Aaron, L,246494.990.000.000.004.99
Parker, Jennifer, D,221184158.240.003578.270.00579.97
Rivera, Rachel, S,2899678.980.000.000.0078.98
Russell, Nicole, M,182372318.960.000.000.002318.96
Lopez, Eduardo, J,266401288.060.00699.100.00588.96
Wright, Carol, C,12928247.410.000.0033.98213.43
Peterson, Alex, M,13423132.900.000.000.00132.90
Harris, Jeremiah, B,170231735.980.000.000.001735.98
Taylor, Ryan,170251709.980.000.000.001709.98
Russell, Jacqueline,18391100.960.000.0078.9821.98
Bell, Christina,2609939.980.000.000.0039.98
Gomez, Rebekah,13486225.440.000.000.00225.44
Peterson, Steven, L,234497.280.000.007.280.00
Brooks, Lucas, S,16089342.030.000.000.00342.03
Van, Bobby,27757132.970.000.000.00132.97
Powell, Jonathan,238584712.740.003578.271134.470.00
Watson, Janet, S,2320859.980.000.000.0059.98
Baker, Robert, A,273007.280.000.007.280.00
Stewart, Jessica,16097103.550.000.0046.5856.97
Gonzalez, Molly,1637021.980.000.000.0021.98
Jenkins, Melissa, R,159974746.340.000.000.004746.34
Li, Eugene, A,15283865.950.000.000.00865.95
Alexander, Angelica,2271471.950.000.000.0071.95
Barnes, Fernando,113001390.550.000.00248.381142.17
Alexander, Ryan, J,14078839.480.000.00839.480.00
Martinez, Dominique,287888.990.000.008.990.00
Sanchez, Rachel, C,267304.990.000.000.004.99
Hernandez, José, M,11253696.610.000.0098.97597.64
Garcia, Anna, B,15572104.550.000.000.00104.55
Flores, Jordyn,252882721.550.002181.560.00539.99
Long, Chloe,167841735.980.000.000.001735.98
Peterson, Mason, A,185701174.480.000.001174.480.00
Scott, Sean, F,2475539.980.000.000.0039.98
James, Zoe, R,14611304.550.000.000.00304.55
Henderson, Eduardo, R,14359256.240.000.0078.98177.26
Campbell, Timothy,2584513.980.000.000.0013.98
Griffin, Isabelle,249864.990.000.000.004.99
Green, Chloe, J,1465892.820.000.000.0092.82
Peterson, Julia, P,16497132.710.000.000.00132.71
Jai, Hunter, M,28272111.950.000.000.00111.95
Thompson, Ryan, M,113301111.360.000.00198.94912.42
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Flores, Devin, A,15559172.040.000.0086.5685.48
Torres, Taylor,16666205.440.000.00123.9881.46
Harris, Natalie,2368259.980.000.0059.980.00
Bell, Chase,180911750.980.000.000.001750.98
Collins, Allison,28581119.980.000.000.00119.98
Deng, Damien, A,16873578.460.000.000.00578.46
Allen, Madeline,2924068.970.000.000.0068.97
Cox, Lucas, J,253932443.350.002443.350.000.00
Clark, Destiny, L,28600119.980.000.000.00119.98
Clark, Anthony,27071782.990.00782.990.000.00
Thomas, Ian,191181120.490.000.000.001120.49
Zeng, Jake,18054106.930.000.000.00106.93
Campbell, Hunter,17422174.920.000.000.00174.92
Bryant, Brittany,2254548.970.000.000.0048.97
Sanchez, Richard, L,274061357.970.000.00782.99574.98
Lopez, Jack, I,2904751.460.000.000.0051.46
Price, Lauren, J,14079184.740.000.0037.29147.45
Evans, Jordan,2920939.980.000.0039.980.00
_SUM1806517.5061618.95486836.72314943.78943118.05
Flores, Julian,158464943.320.000.000.004943.32
Butler, Morgan, E,2050068.490.000.000.0068.49
Taylor, Zachary, M,27082782.990.000.00782.990.00
Bryant, Rachel,220197.280.000.007.280.00
Sanchez, Mariah, R,1922066.650.000.0038.8827.77
Rubio, Jaime, R,15007209.830.000.0049.97159.86
Flores, Emma, P,15543180.940.000.000.00180.94
Simmons, James,198844588.450.003399.990.001188.46
Russell, Elijah, M,118354772.300.000.002319.262453.04
Hall, Morgan,2172641.950.000.000.0041.95
Hughes, Eduardo,15564188.520.000.000.00188.52
Turner, Jeremiah, F,19207791.320.000.000.00791.32
Williams, Edward, D,14274121.560.000.000.00121.56
Bailey, Mariah, L,2724354.980.000.000.0054.98
Jai, Adam,250952443.350.002443.350.000.00
Cannata, Gabrielle, C,217254.990.000.000.004.99
Moore, Matthew, W,13267109.950.000.000.00109.95
Thomas, Isabella, M,27265782.990.000.00782.990.00
Russell, Gail, L,212634.990.000.000.004.99
Bell, Alexandria, A,13758284.130.000.0042.28241.85
Harris, Anthony,2144721.980.000.000.0021.98
Cox, Nathaniel, A,196612521.270.000.000.002521.27
Hughes, Destiny, P,28027119.980.000.000.00119.98
James, Sara,198023374.993374.990.000.000.00
Martinez, Matthew, L,16009170.450.000.000.00170.45
Kumar, Elijah,15197156.920.000.000.00156.92
Taylor, Brianna,17027230.900.000.0051.96178.94
Perry, Olivia,203754438.380.000.002071.422366.96
Williams, Morgan, C,203733226.900.000.002071.421155.48
Perez, Charles,266937.280.000.007.280.00
Martin, Brandon, S,2169139.980.000.000.0039.98
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Rubio, Javier, E,1972664.240.000.0064.240.00
Turner, Amanda, L,203183241.900.002071.420.001170.48
Turner, James, E,16841126.960.000.0069.9956.97
Jackson, Edward,290422420.340.000.002420.340.00
Cook, Steven, J,27053782.990.00782.990.000.00
Gonzales, Emily, P,21777180.980.000.000.00180.98
Coleman, Dylan,27403132.970.000.000.00132.97
Flores, Luke, L,247337.280.000.000.007.28
Garcia, Victoria, V,245013578.270.003578.270.000.00
Russell, Katherine,2877169.990.000.000.0069.99
Richardson, Melissa, E,111322371.940.000.000.002371.94
Bradley, Melanie, G,133434720.270.000.000.004720.27
Sanchez, Shelby,16021539.990.000.000.00539.99
Reed, Melanie, A,28160574.980.000.000.00574.98
Sanders, Hailey,19647282.040.000.000.00282.04
Campbell, Alex,119844730.320.000.002329.982400.34
Russell, Kaitlyn, M,244913578.270.003578.270.000.00
Simmons, Anna, K,124512367.920.000.000.002367.92
Taylor, Marcus, A,18944146.940.000.000.00146.94
Stewart, Grace, H,247737.280.000.000.007.28
Hill, Eric, G,2525667.930.000.0067.930.00
Brooks, Bryce,12061140.170.000.00112.2527.92
Henderson, Austin,2764354.980.000.000.0054.98
Long, Caleb, P,250462181.560.002181.560.000.00
Diaz, Thomas, O,16020595.960.000.000.00595.96
Simmons, Nicole, S,2617729.480.000.000.0029.48
Bell, Julia,216522646.060.000.002646.060.00
Martin, Kellie, R,28195574.980.000.000.00574.98
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Thompson, Tyler,2750269.990.000.0069.990.00
Long, Xavier,112512318.960.000.000.002318.96
Gonzalez, James, M,188421155.480.000.000.001155.48
Ward, Emma, W,2179659.980.000.000.0059.98
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Johnson, Edward, H,23279124.990.000.000.00124.99
Baker, Allison,2649558.980.000.000.0058.98
Perez, Timothy, L,227304.990.000.000.004.99
Hill, Blake,11748131.540.000.000.00131.54
Rubio, Kellie,27653128.970.000.000.00128.97
Smith, Katherine, J,13197105.190.000.000.00105.19
Jones, Alexandra, B,2020245.950.000.000.0045.95
Hall, Grace, A,201894.990.000.000.004.99
Scott, Gabrielle,270614.990.000.000.004.99
Lewis, Jeremiah,1437187.260.000.0049.9737.29
Luo, Franklin, J,2202759.980.000.000.0059.98
Scott, Adam,15863243.010.000.000.00243.01
Green, Blake, P,11719287.200.000.000.00287.20
Baker, Isaiah,12106169.540.000.000.00169.54
Alexander, Logan, E,191161183.470.000.000.001183.47
Lee, John,19801193.010.000.000.00193.01
Roberts, Mason, D,111761106.680.000.00494.64612.04
Martin, Christian, V,19709197.250.000.000.00197.25
Chen, Luis, G,2125294.450.000.0094.450.00
Thomas, Thomas,216292624.080.000.002049.10574.98
Gonzalez, Gabriella, Z,15872235.540.000.000.00235.54
Reed, Kaylee, R,17371151.920.000.000.00151.92
Rogers, Faith,2468259.980.000.000.0059.98
Taylor, Victoria,260132443.350.000.002443.350.00
Diaz, Trevor, B,2051954.960.000.000.0054.96
Brown, Isabella, L,266921266.860.00699.100.00567.76
White, Tyler,14291258.440.000.0049.97208.47
Roberts, Wyatt,15900699.970.000.00699.970.00
Phillips, Jackson, D,233785317.230.003578.270.001738.96
Rodriguez, Richard,12969180.790.000.000.00180.79
Rogers, Andrea, L,14328308.660.000.0049.97258.69
Ward, Ian,12056213.920.000.000.00213.92
Russell, Fernando,27084782.990.000.00782.990.00
Ramirez, Ian,166783162.310.000.00742.352419.96
Wilson, Grace,17539205.920.000.000.00205.92
Bryant, Gabriel,2765669.990.000.000.0069.99
Harris, Seth, M,161402528.330.000.000.002528.33
Howard, Morgan, T,229713578.270.003578.270.000.00
Bryant, Jackson, J,2533239.980.000.000.0039.98
Stewart, Makayla,16649115.940.000.000.00115.94
Reed, Paige,221126047.320.003578.272469.050.00
Thompson, Joshua, F,259992181.560.000.002181.560.00
Suarez, Juan, R,167631700.990.000.000.001700.99
Evans, Alexandra,2432268.490.000.000.0068.49
Gonzales, Jose,2201439.980.000.000.0039.98
Jai, Jose,12944164.210.000.000.00164.21
Davis, Austin, E,133664749.040.000.000.004749.04
Coleman, Isabel, S,12530337.900.000.00123.98213.92
Bryant, Connor,238424828.110.003578.270.001249.84
Butler, Trevor,2741569.990.000.0069.990.00
Blue, Melanie, L,178611749.960.000.000.001749.96
Kapoor, Preston,2143156.970.000.000.0056.97
Baker, Mason, A,132702394.950.000.000.002394.95
Anderson, Isabella,137432349.980.000.000.002349.98
Washington, Victoria,235577.280.000.000.007.28
Simmons, Jennifer,112621010.560.000.00207.93802.63
Rivera, Sara,187852350.960.000.000.002350.96
Carter, Savannah, M,120902350.960.000.000.002350.96
Lewis, Rachel, J,14900839.480.000.000.00839.48
Harris, Samantha, A,244874.990.000.000.004.99
Green, Isabella,26620699.10699.100.000.000.00
Lee, James, J,2881769.990.000.0069.990.00
Butler, Dalton, A,133454759.510.000.000.004759.51
Nath, Yolanda, A,2462513.980.000.000.0013.98
Rodriguez, Anthony, G,238294802.110.003578.270.001223.84
Green, Xavier,2356739.980.000.000.0039.98
Bryant, Kyle,231644807.100.003578.271228.830.00
Price, Devin, M,18758158.510.000.0073.5584.96
Jenkins, Alexandra, D,11632924.610.000.00160.51764.10
Rodriguez, Alexis, L,15244179.190.000.0042.28136.91
Watson, Erin, B,227724.990.000.000.004.99
Wilson, Chloe, A,11640409.120.000.0075.48333.64
Hughes, Anna,197052341.970.000.000.002341.97
Ross, David, M,171431763.970.000.000.001763.97
Alexander, Taylor,17482146.940.000.0076.9769.97
Torres, Haley, W,232834828.110.003578.270.001249.84
Washington, Emma,191231170.480.000.000.001170.48
Cox, Katelyn, B,2174230.970.000.000.0030.97
Lewis, Isabella,2624267.930.000.000.0067.93
Gonzalez, Katherine,222345976.320.003578.270.002398.05
Morris, Richard,2007039.980.000.000.0039.98
Bailey, Maria, C,1915034.980.000.000.0034.98
Simmons, Caleb, M,121934833.030.000.000.004833.03
Clark, Zachary, J,2389358.980.000.000.0058.98
Reed, Bryan,18884133.930.000.000.00133.93
Torres, Christina, M,20746119.950.000.000.00119.95
Ramos, Derrick,18449100.940.000.0030.9769.97
Lal, Robert, L,14084138.680.000.000.00138.68
Jai, Logan, H,12031769.490.000.000.00769.49
Nelson, James, L,245257.280.000.007.280.00
Sanders, Melissa, R,242844837.340.003578.270.001259.07
Reed, Judith, D,2534759.980.000.000.0059.98
Alexander, Nathan, A,187951198.970.000.000.001198.97
Turner, Blake,12136131.740.000.000.00131.74
Williams, Ian, M,175581750.470.000.000.001750.47
Walker, Thomas,1307193.980.000.000.0093.98
Rivera, Amanda,11131115.920.000.000.00115.92
Campbell, Chloe,11212760.930.000.00231.72529.21

Generated 2024-11-10 05:10:50.446 UTC