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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Moore, Fernando,265821000.440.000.001000.440.00
Martinez, Grace, M,17385208.690.000.0069.97138.72
Bryant, Gabriel,2765669.990.000.000.0069.99
Patterson, Grace, M,27560782.990.000.00782.990.00
Collins, Sierra,185491169.460.000.001169.460.00
Simmons, Caleb, M,121934833.030.000.000.004833.03
Garcia, Lucas,27545782.990.000.00782.990.00
Brown, Dylan, J,124492351.960.000.000.002351.96
Coleman, Alexandria, C,1328942.280.000.000.0042.28
King, Jordan, C,110202316.970.000.002316.970.00
Foster, Emma,15468436.350.000.00159.99276.36
Long, Gavin,13762186.030.000.0036.59149.44
Jackson, Edward,290422420.340.000.002420.340.00
Morris, Alyssa,28072548.980.000.000.00548.98
Srini, Ruben,18078200.940.000.0071.97128.97
Bailey, Jessica, L,12945218.440.000.000.00218.44
Hall, Kyle, J,1749169.970.000.000.0069.97
Henderson, Justin, P,235917.280.000.000.007.28
Moore, Anthony, M,2473039.980.000.000.0039.98
Harris, Destiny, M,137102341.460.000.000.002341.46
Nath, Alison, J,171161764.960.000.000.001764.96
Taylor, Natalie, M,14338828.740.000.000.00828.74
Simmons, Jose,2464739.980.000.000.0039.98
Russell, Richard,2763322.260.000.000.0022.26
Lal, Caleb, R,1586874.460.000.000.0074.46
Collins, Nathan, F,197041143.460.000.000.001143.46
Jones, Kayla, C,1854194.260.000.000.0094.26
Zhang, Robert,188551155.480.000.000.001155.48
Lopez, Jack, I,2904751.460.000.000.0051.46
Martinez, Kristina, S,2134529.930.000.000.0029.93
Moore, Hunter,14897196.270.000.0071.58124.69
Wang, Benjamin, R,274547.280.000.000.007.28
Scott, Sean, F,2475539.980.000.000.0039.98
Foster, Kayla,1969371.950.000.000.0071.95
Gray, Cody, C,144594775.010.000.000.004775.01
Brown, Morgan,2919778.980.000.000.0078.98
Flores, Madison,14416769.490.000.000.00769.49
Russell, Arianna,22728149.930.000.00149.930.00
Miller, Andrew, C,271104.990.000.000.004.99
Butler, Dalton, A,133454759.510.000.000.004759.51
Hill, Eric, G,2525667.930.000.0067.930.00
Lee, Alexander, S,18356149.910.000.000.00149.91
Coleman, Spencer,15993597.260.000.000.00597.26
Anderson, Daniel,20694146.970.000.00146.970.00
Garcia, Benjamin, L,175951785.970.000.000.001785.97
Green, Mackenzie, C,280737.280.000.000.007.28
Hayes, Gavin, A,194001179.470.000.000.001179.47
Coleman, Dylan,27403132.970.000.000.00132.97
Morris, Richard,2007039.980.000.000.0039.98
Clark, Zachary, J,2389358.980.000.000.0058.98
Young, Jenna, W,163652490.180.000.000.002490.18
Madan, Carmen, V,155674720.270.000.000.004720.27
Andersen, Latoya, J,290578.990.000.000.008.99
Alexander, Caroline,176541759.970.000.000.001759.97
Coleman, Wyatt, M,2328439.980.000.000.0039.98
Griffin, Isabelle,249864.990.000.000.004.99
Perry, Natalie,1712669.990.000.000.0069.99
Allen, Luke,113162349.980.000.002349.980.00
Collins, Xavier, C,16646250.910.000.000.00250.91
Hayes, Hannah, J,2165656.970.000.000.0056.97
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Raje, Mindy, A,16083561.970.000.000.00561.97
Wilson, Eduardo,15323804.470.000.000.00804.47
Martinez, Dominique,287888.990.000.008.990.00
Shan, Christian, L,2308439.980.000.000.0039.98
Morris, Mason, J,22349124.990.000.000.00124.99
Diaz, Jason,17374206.630.000.0089.46117.17
Rivera, Allison, M,13751224.910.000.000.00224.91
Thompson, Madison, L,187882351.960.000.000.002351.96
Garcia, Christian, J,164913106.330.000.00751.342354.99
Hall, Charles,234764.990.000.000.004.99
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Green, Eric,2738069.990.000.000.0069.99
Ramirez, Ian,166783162.310.000.00742.352419.96
Griffin, Marcus,2075634.560.000.000.0034.56
Sanchez, Jared, J,2585064.470.000.000.0064.47
Simmons, Adam,253274.990.000.000.004.99
Ross, Kaitlyn,16121614.470.000.000.00614.47
Phillips, Andrea,1857383.740.000.000.0083.74
Henderson, Luke,19200109.240.000.000.00109.24
Blue, Melanie, L,178611749.960.000.000.001749.96
Hu, Gilbert, L,2876769.990.000.000.0069.99
Nelson, Luis,234884.990.000.000.004.99
Hill, Timothy,14871848.470.000.000.00848.47
Carter, Isaac,137191129.480.000.000.001129.48
Adams, Julia, N,2607359.980.000.000.0059.98
Hayes, Dalton, C,188822322.280.000.000.002322.28
Prasad, Erick, E,28786127.950.000.000.00127.95
Reed, Melanie, A,28160574.980.000.000.00574.98
Griffin, Seth, R,17585164.460.000.0078.9885.48
James, Bryce,13466133.450.000.000.00133.45
Miller, Alexis, A,12196124.930.000.000.00124.93
Jones, Dalton, T,189512334.970.000.000.002334.97
Stewart, Allison, R,18826166.430.000.0069.9996.44
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Watson, Emma,17481126.940.000.000.00126.94
Johnson, Jacob, I,28069553.970.000.000.00553.97
Mitchell, Bailey, B,267067.280.000.007.280.00
Robinson, Ian, D,138522294.990.000.000.002294.99
Young, Kaitlyn, J,2506213.980.000.000.0013.98
Barnes, Blake, A,178651789.970.000.000.001789.97
Clark, Joseph, D,153954780.020.000.000.004780.02
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Lopez, Carlos,186171147.770.000.000.001147.77
Reed, Isaac, D,260747.280.000.000.007.28
Brooks, Allison,146054750.010.000.000.004750.01
Diaz, Trevor, B,2051954.960.000.000.0054.96
King, Aaron, L,117394758.030.000.002359.982398.05
Anderson, Jasmine, A,235534.990.000.000.004.99
Lewis, Jeremiah,1437187.260.000.0049.9737.29
Phillips, Haley, B,2807939.980.000.000.0039.98
Evans, Luke,2917615.230.000.000.0015.23
Moore, Ian, L,2463939.980.000.000.0039.98
Watson, Janet, S,2320859.980.000.000.0059.98
Henderson, Abigail,2044139.980.000.000.0039.98
Reed, Marcus,14582111.790.000.0014.9896.81
Collins, Allison,28581119.980.000.000.00119.98
Clark, William,2902169.990.000.000.0069.99
Nelson, Kevin,1476584.970.000.000.0084.97
Wilson, Andrew, R,182362414.990.000.000.002414.99
Price, Caroline,180511735.980.000.000.001735.98
Hughes, Miranda,266784.990.000.000.004.99
Ma, Tiffany,2157739.980.000.000.0039.98
Long, Natalie,14363192.340.000.000.00192.34
Foster, Abigail,1982346.470.000.000.0046.47
Smith, Justin, P,1982721.980.000.000.0021.98
Watson, Victoria,16125588.960.000.000.00588.96
Gonzales, Jasmine, C,183922342.930.000.000.002342.93
Mitchell, Evan, R,247314.990.000.000.004.99
Morgan, Evan, G,14725318.830.000.0069.97248.86
Murphy, Maria,160113657.260.000.000.003657.26
Watson, Shelby, J,14911867.970.000.000.00867.97
Perry, Jackson, J,213064.990.000.000.004.99
Gill, Robyn, J,127651750.980.000.001750.980.00
Bailey, Alexandria, V,132092319.990.000.000.002319.99
Powell, Miranda, J,153044843.000.000.000.004843.00
Martin, Kellie, R,28195574.980.000.000.00574.98
Washington, Emma,191231170.480.000.000.001170.48
Stewart, Gabriella,2803469.990.000.000.0069.99
Nelson, Adam, B,27402128.970.000.000.00128.97
Martin, Jeremiah, E,173451764.960.000.000.001764.96
Martin, Christian, V,19709197.250.000.000.00197.25
Nath, Carl, H,29001624.970.000.000.00624.97
Garcia, Brandon, V,244184329.610.003578.270.00751.34
Garcia, Kayla, L,2130881.460.000.000.0081.46
Price, Rachel, D,2532889.970.000.000.0089.97
Li, Rafael, M,217527.280.000.000.007.28
Long, Caleb, P,250462181.560.002181.560.000.00
Ward, Natalie, J,132412325.960.000.000.002325.96
Martin, Nicholas,233627.280.000.000.007.28
Bell, Chase,180911750.980.000.000.001750.98
Green, Sophia, E,249772181.560.002181.560.000.00
Sandberg, Chase,2190475.970.000.000.0075.97
Thomas, Benjamin, J,2129556.970.000.000.0056.97
Thomas, Dalton,230097.280.000.000.007.28
Adams, Haley, M,247862443.350.002443.350.000.00
Reed, Michelle,2804669.990.000.000.0069.99
Robinson, Alyssa, C,2313439.980.000.000.0039.98
Watson, Devin, A,18875114.950.000.000.00114.95
Sanders, Paige,252872983.340.002443.350.00539.99
Zhang, Connor, R,138532329.980.000.000.002329.98
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Lal, Jack, R,185251735.980.000.000.001735.98
Price, Stephanie,258922443.350.002443.350.000.00
Perez, Jonathan, R,2345512.940.000.000.0012.94
Garcia, Alexandra, J,14107819.460.000.00819.460.00
Chen, Jack, E,17579151.430.000.000.00151.43
Murphy, Dalton, N,27043782.990.00782.990.000.00
Perry, James,192051249.840.000.000.001249.84
Taylor, Marcus, A,18944146.940.000.000.00146.94
Hughes, Riley,2928449.990.000.000.0049.99
Price, Jocelyn, D,258752443.350.002443.350.000.00
Johnson, Madison, L,15530846.460.000.000.00846.46
Reed, Kaylee, R,17371151.920.000.000.00151.92
Roberts, Noah, S,2704268.490.000.000.0068.49
Cox, Lucas, J,253932443.350.002443.350.000.00
Srini, Evelyn,16855150.950.000.000.00150.95
Bradley, Rachel,158504813.040.000.000.004813.04
Shan, Gabriel, T,2773169.990.000.000.0069.99
Young, Savannah,259712749.320.002181.560.00567.76
Howard, Danielle,28357133.490.000.000.00133.49
Murphy, Brianna, K,2834269.990.000.000.0069.99
Brown, Julia,18065155.470.000.000.00155.47
Chen, Jackson, S,270751371.950.00782.990.00588.96
Sanchez, Nicole, L,14874804.480.000.000.00804.48
Miller, Jill,129142329.980.000.000.002329.98
Simmons, Nicole, S,2617729.480.000.000.0029.48
Blanco, Randall,263211554.410.000.001000.44553.97
Roberts, Amanda,171752334.980.000.000.002334.98
Stewart, Olivia, B,1874923.780.000.000.0023.78
Foster, Nicole, A,2349489.970.000.000.0089.97
Robinson, Sarah, A,2702859.980.000.000.0059.98
Lewis, Ethan,27998144.470.000.000.00144.47
Sanders, Stephanie, A,197462329.990.000.000.002329.99
Brooks, Steven, C,14877889.470.000.000.00889.47
Evans, Kaylee,19642133.540.000.000.00133.54
Edwards, Elijah, D,281577.280.000.000.007.28
Lee, Don,188392384.970.000.000.002384.97
Butler, Jackson, J,183241735.980.000.000.001735.98
Reed, Catherine, M,203807.280.000.000.007.28
Li, Brandon,2933973.960.000.000.0073.96
Evans, Gabriel,2348789.970.000.000.0089.97
Kelly, Bailey, R,28284563.770.000.000.00563.77
Foster, Trevor, J,2896469.990.000.000.0069.99
Ramirez, Emma,29072128.970.000.000.00128.97
Cox, Sara, P,2775869.990.000.0069.990.00
Allen, Madeline,2924068.970.000.000.0068.97
Green, Gabriella, C,2803569.990.000.000.0069.99
Sanchez, Stephanie,1786756.970.000.000.0056.97
Van, Bobby,27757132.970.000.00132.970.00
Morris, Haley, A,2354848.970.000.000.0048.97
Cooper, Brianna,2592513.980.000.000.0013.98
Jackson, Victoria,270194.990.000.000.004.99
Harris, Seth, M,161402528.330.000.002528.330.00
Carter, Jose, H,12532235.720.000.000.00235.72
Johnson, Anthony, D,270224.990.000.000.004.99
Williams, Joshua,260514.990.000.000.004.99
Coleman, Logan,1868691.950.000.000.0091.95
Long, Sarah,173721729.970.000.000.001729.97
Coleman, Joan, W,2669964.470.000.000.0064.47
Russell, Katherine,2877169.990.000.000.0069.99
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Chen, David,2720839.980.000.000.0039.98
Brown, Anthony, J,19399151.430.000.000.00151.43
Martin, Alfredo, P,2148039.980.000.000.0039.98
Garcia, Isabella,18382204.940.000.000.00204.94
Butler, Jonathan,261804.990.000.000.004.99
Long, Chloe,167841735.980.000.000.001735.98
Luo, Jodi,2921368.490.000.000.0068.49
Gray, Jared, A,264494.990.000.004.990.00
Parker, Kaylee, M,2773878.980.000.000.0078.98
Roberts, Amber, W,215822638.060.000.002049.10588.96
Hall, Grace, A,201894.990.000.000.004.99
Gonzalez, Amber, L,2387964.470.000.000.0064.47
Edwards, Alexandra,133582386.940.000.000.002386.94
Reed, Mariah,263731565.910.000.001000.44565.47
Alexander, Julian,132172351.960.000.000.002351.96
Lewis, Morgan,17410168.740.000.000.00168.74
Adams, Katherine, M,235184.990.000.000.004.99
Richardson, Olivia,204683169.590.000.002049.101120.49
Alvarez, Melody,2507068.490.000.000.0068.49
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Torres, Abigail,253674.990.000.000.004.99
Miller, Katherine, B,27102782.990.000.00782.990.00
Scott, Mason,2355139.980.000.000.0039.98
Wang, Zachary,2214489.970.000.000.0089.97
Baker, Gabriella,174041709.980.000.000.001709.98
Perry, Marcus, L,206563245.900.000.002071.421174.48
Sanders, Mason, G,2345939.980.000.000.0039.98
Reed, Gabriella, A,2743778.980.000.000.0078.98

Generated 2025-11-03 23:59:20.853 UTC