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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Watson, Cole, A,217684118.263578.270.000.00539.99
Taylor, Madison, A,11802215.290.000.00127.9687.33
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
Morris, Paige, W,220414167.233578.270.000.00588.96
Roberts, Thomas, J,219394163.243578.270.000.00584.97
Turner, Jose,11784272.690.000.000.00272.69
Griffin, Jason, L,112001267.110.000.00391.08876.03
Zukowski, Jake,220584118.263578.270.000.00539.99
Flores, Zachary, H,233765314.250.003578.270.001735.98
Perry, Jennifer, J,221205962.340.003578.272384.070.00
Morris, Abigail, C,287762.290.000.000.002.29
Martin, Xavier,222335997.330.003578.270.002419.06
Powell, Miranda, J,153044843.000.000.000.004843.00
Sandberg, Isaac,1335053.970.000.000.0053.97
Brown, Nicholas, S,11506675.640.000.00121.93553.71
Miller, Benjamin, G,26643699.100.00699.100.000.00
Johnson, James,234984.990.000.000.004.99
Rogers, Carlos,19645134.440.000.000.00134.44
Carter, Marcus, l,2147131.970.000.000.0031.97
Lee, Emma,16948176.430.000.000.00176.43
Flores, Emily,13206163.190.000.0069.9793.22
Roberts, Mason, D,111761106.680.000.00494.64612.04
Lewis, Seth,26782699.100.00699.100.000.00
Walker, Charles,11677298.210.000.000.00298.21
Green, Marcus, C,15974208.410.000.0091.95116.46
Chandra, Brandy, P,11501603.530.000.0098.23505.30
Moore, Taylor, A,199874564.450.003374.990.001189.46
Simmons, Sarah, V,11500651.980.000.00118.96533.02
Taylor, Ryan,170251709.980.000.000.001709.98
Martin, Gina, E,11078793.270.000.00158.36634.91
Nelson, Adam, B,27402128.970.000.000.00128.97
Stewart, Katherine, Z,229015971.330.003578.270.002393.06
Hughes, Samantha,2721564.470.000.000.0064.47
Thomas, Alexandra, C,231724809.390.003578.271231.120.00
Washington, Caroline, D,231145996.320.003578.270.002418.05
Bryant, Isabella, L,229956060.500.003578.270.002482.23
Brooks, Isaac, M,233854829.390.003578.270.001251.12
Sanchez, Lucas, L,233514828.110.003578.270.001249.84
Wilson, Fernando,16643126.960.000.000.00126.96
Ware, Dennis, L,237254828.110.003578.270.001249.84
Murphy, Catherine, L,1650692.050.000.000.0092.05
Bryant, Isabelle,233974828.110.003578.270.001249.84
Davis, Daniel,11711999.220.000.0086.48912.74
Washington, Vanessa,238194802.110.003578.270.001223.84
Thomas, Dylan,198737.280.000.000.007.28
Rodriguez, Joshua, A,235114843.110.003578.270.001264.84
Griffin, Julian, M,113284718.040.000.002319.992398.05
Thompson, Abigail,243324816.090.003578.270.001237.82
Chander, Wayne, S,243444329.610.003578.27751.340.00
Turner, Wyatt,200345769.960.003399.990.002369.97
Mitchell, Katelyn, A,244964349.610.003578.270.00771.34
Price, Isabelle,201825749.970.003374.990.002374.98
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Miller, Alexis, A,12196124.930.000.000.00124.93
Perry, Ryan,132494795.340.000.000.004795.34
Umeda, Masaki,16717233.810.000.000.00233.81
Parker, James,11808610.190.000.00186.77423.42
Moore, Matthew, W,13267109.950.000.000.00109.95
Serrano, Albert, E,133284708.020.000.000.004708.02
Reed, Judith, D,2534759.980.000.000.0059.98
Russell, Isabella, A,11507645.780.000.0028.48617.30
Mitchell, Savannah,261153052.800.000.002443.35609.45
Wilson, Hunter, R,2723013.980.000.000.0013.98
Wright, Robert, C,158894848.030.000.000.004848.03
Wright, Kyle,2371626.970.000.000.0026.97
Evans, Luke,2917615.230.000.000.0015.23
Brooks, Bryce,12061140.170.000.00112.2527.92
Price, Nicole, N,15815141.830.000.000.00141.83
Barnes, Fernando,113001390.550.000.00248.381142.17
Torres, Erin,1218287.250.000.0037.2949.96
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Griffin, Jordan,13095328.890.000.0069.97258.92
Rogers, Jared, J,12166162.220.000.000.00162.22
Rogers, Faith,2468259.980.000.000.0059.98
Long, Brandon, M,16110650.470.000.000.00650.47
Garcia, Brandon, V,244184329.610.003578.270.00751.34
Fernandez, Cesar,200355694.980.003374.990.002319.99
Garcia, Victoria, V,245013578.270.003578.270.000.00
Cooper, Stephanie,249762181.560.002181.560.000.00
Griffin, Madison, A,250932181.560.002181.560.000.00
Wood, Alexandria, M,248242181.560.002181.560.000.00
Hughes, Julia,250612443.350.002443.350.000.00
Turner, Amanda, L,203183241.900.002071.420.001170.48
Zhao, Karen, L,254082735.530.002181.560.00553.97
Gomez, Renee, L,253712181.560.002181.560.000.00
Clark, Anthony,27071782.990.00782.990.000.00
Howard, Isaiah,259813018.330.002443.350.00574.98
Cook, Steven, J,27053782.990.00782.990.000.00
Chen, Jackson, S,270751371.950.00782.990.00588.96
Coleman, Lucas, A,27060782.990.00782.990.000.00
Gonzales, Melissa, W,204704408.690.000.002071.422337.27
Lewis, Isabella,2624267.930.000.000.0067.93
Lopez, Katelyn,11820232.710.000.0060.47172.24
Scott, Kaitlyn, A,12159218.910.000.00133.9684.95
Butler, Morgan, E,2050068.490.000.000.0068.49
Simmons, Dakota, T,14110819.460.000.000.00819.46
Sharma, Jackson,16876151.840.000.000.00151.84
Foster, Trevor, J,2896469.990.000.000.0069.99
Sanchez, Mariah, R,1922066.650.000.0038.8827.77
Cooper, Ariana,17348205.420.000.000.00205.42
Carter, Jason,11724210.090.000.00113.8696.23
Morris, Richard,2007039.980.000.000.0039.98
Sanders, Megan, A,15376136.240.000.000.00136.24
Martin, Brandon, S,2169139.980.000.000.0039.98
Coleman, Joan, W,2669964.470.000.000.0064.47
Moore, Andrew, A,13944150.130.000.0036.27113.86
Malhotra, Kristi, S,151754850.330.000.000.004850.33
Parker, Blake,15008170.530.000.0074.9895.55
Sharma, Thomas, A,18637121.940.000.0091.9529.99
White, Abigail, T,15866145.820.000.0038.88106.94
Chavez, Kara, P,13285214.350.000.0012.94201.41
Jenkins, Megan, R,12074261.380.000.000.00261.38
Walker, Jasmine,134604693.040.000.000.004693.04
Morgan, Isaiah,18978118.730.000.000.00118.73
Ward, Jade, D,14661195.020.000.000.00195.02
Campbell, Gabriella,188411145.480.000.000.001145.48
Lee, Ethan, J,223597.280.000.000.007.28
Martinez, Jonathan,1330366.250.000.000.0066.25
Hughes, Morgan, T,11642392.890.000.0049.48343.41
Russell, Megan,16220562.960.000.000.00562.96
Bailey, Hailey, R,262704.990.000.000.004.99
Parker, Katherine,13268289.700.000.0068.97220.73
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
Campbell, Alex,119844730.320.000.002329.982400.34
Lopez, Isaiah,18968151.430.000.000.00151.43
Jones, Joshua,184012294.990.000.000.002294.99
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Young, Sierra, J,11619634.840.000.0034.99599.85
Powell, Jasmine, A,11505846.770.000.00105.05741.72
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Taylor, Marcus, A,18944146.940.000.000.00146.94
Bradley, Rachel,158504813.040.000.000.004813.04
Patterson, Hailey, I,112231155.900.000.00267.62888.28
Murphy, Brianna, K,2834269.990.000.000.0069.99
Miller, Jill,129142329.980.000.000.002329.98
Blanco, Randall,263211554.410.000.001000.44553.97
Green, Samuel, D,14096174.730.000.000.00174.73
Simmons, Caleb, M,121934833.030.000.002394.972438.06
Dominguez, Erika, C,21251191.270.000.000.00191.27
Bennett, Jennifer, G,13708123.940.000.0068.9754.97
Hill, Blake,11748131.540.000.000.00131.54
Mr., Sandstone, John, J,129032332.280.000.000.002332.28
Butler, Ana,260403018.330.000.002443.35574.98
Torres, Christina, M,20746119.950.000.0064.9754.98
Coleman, Alexandria, C,1328942.280.000.000.0042.28
Carter, Elijah,216182611.070.000.002611.070.00
Morgan, Andrea, M,16870149.040.000.00116.4432.60
Isla, Julian, A,13732108.960.000.004.99103.97
Russell, Ian, T,2474613.980.000.0013.980.00
Evans, Maria,22544127.280.000.00127.280.00
Sanchez, Adrian, L,13179190.170.000.000.00190.17
Flores, Brittany,169062359.980.000.000.002359.98
Kelly, Trinity,2609515.230.000.000.0015.23
Sun, Arturo, C,11498557.540.000.00151.90405.64
Lal, Robert, L,14084138.680.000.000.00138.68
Scott, Haley,13701154.540.000.000.00154.54
Barnes, Dalton, C,178581700.990.000.000.001700.99
Perry, Ana,112151155.520.000.00432.39723.13
Hayes, Logan, J,19026113.240.000.0037.2775.97
Brown, Jonathan,11875265.420.000.000.00265.42
Rogers, Sara,198744544.450.003374.990.001169.46
Hernandez, José, M,11253696.610.000.00187.94508.67
Lewis, Kaitlyn,159064761.030.000.000.004761.03
Flores, Julian,158464943.320.000.000.004943.32
Brown, Anna,1624795.820.000.000.0095.82
Dominguez, Meghan,14370122.560.000.000.00122.56
White, Nicole,16731155.910.000.0084.9670.95
Moore, Logan,2634889.970.000.0089.970.00
Evans, Jesse,2191639.980.000.000.0039.98
Wilson, Tyler, L,15879196.930.000.000.00196.93
Mitchell, Caleb, K,268064.990.000.000.004.99
Gonzales, Miranda,11660324.720.000.000.00324.72
Stewart, Jessica,16097103.550.000.0046.5856.97
Hill, Jordan, J,16005198.730.000.00102.2796.46
Hall, Jose, J,17601225.420.000.00155.4569.97
Carter, Bailey,213322616.860.000.002616.860.00
Reed, Marcus,14582111.790.000.0014.9896.81
Ward, Kaylee, A,244154.990.000.004.990.00
Jones, Samantha,1831721.980.000.000.0021.98
Smith, John,198555709.960.003399.990.002309.97
Alexander, Sarah,1941129.990.000.000.0029.99
Blue, Melanie, L,178611749.960.000.000.001749.96
Lal, Luke, L,11019698.230.000.00139.93558.30
Miller, Chloe, V,228936056.510.003578.272478.240.00
Diaz, Luke,12054402.530.000.00139.97262.56
Davis, James,11922275.500.000.0034.98240.52
Taylor, Lucas, V,115232376.960.000.002376.960.00
Gray, Sara,292472447.050.000.002447.050.00
Anderson, Destiny,12895336.650.000.0037.27299.38
Morgan, Timothy,14633242.500.000.0071.58170.92
Lopez, Eduardo, J,266401288.060.00699.100.00588.96
Diaz, Alyssa,139084715.330.000.000.004715.33
Martin, Noah, A,1765775.970.000.0075.970.00
Hughes, Nathan, B,121134737.530.000.002294.992442.54
Perez, Savannah, J,17036176.950.000.0056.97119.98
Reed, Paige,221126047.323578.270.002469.050.00
Coleman, Samuel, N,17450123.980.000.000.00123.98
Jai, Luis, A,18320185.920.000.000.00185.92
Hayes, Dalton, C,188822322.280.000.000.002322.28
Reed, Melanie, A,28160574.980.000.000.00574.98
Carter, Katherine,11861286.300.000.000.00286.30
Edwards, Hailey,242584.990.000.000.004.99
James, Bryce,13466133.450.000.000.00133.45
Morgan, Jada, A,11520702.990.000.00137.45565.54
Washington, Kayla, E,14655174.960.000.0069.97104.99
Phillips, James, G,16846180.950.000.00123.9856.97
Miller, Victoria,15816188.020.000.00118.0569.97
Baker, Sean, T,247782858.490.002181.56676.930.00
Foster, Emma,15468436.350.000.00159.99276.36
Rubio, Jaime, R,15007209.830.000.0049.97159.86
Russell, Arianna,22728149.930.000.00149.930.00
Evans, Jordan,2920939.980.000.0039.980.00
Hill, Haley, J,161033142.320.000.00792.342349.98
Anderson, Daniel,20694146.970.000.00146.970.00
Harris, Samuel, M,2477159.980.000.0059.980.00
Moore, Jessica, J,2008576.760.000.000.0076.76
Wilson, Grace,17539205.920.000.000.00205.92
Hall, Lauren, A,19648100.840.000.000.00100.84
Long, Jordyn,1733847.250.000.000.0047.25
Perry, Justin, E,167583062.340.000.000.003062.34
Hayes, Luis,12880200.730.000.000.00200.73
Hill, Timothy,14871848.470.000.000.00848.47
She, Martha, E,222515971.330.003578.270.002393.06
Mohamed, Samantha, A,292772419.060.000.002419.060.00
Reed, Isaac, D,260747.280.000.000.007.28
Phillips, Mackenzie,12444228.430.000.00113.96114.47
Gonzales, Cameron, L,2900569.990.000.0069.990.00
Foster, Jessica,2606951.460.000.0051.460.00
Stewart, Destiny,13144281.470.000.00134.98146.49
Robinson, Ian, D,138522294.990.000.000.002294.99
Davis, Marcus, T,17337123.910.000.0086.9536.96
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Hall, Jan, M,11740334.120.000.00235.1598.97
Barnes, Blake, A,178651789.970.000.000.001789.97
Lewis, Brianna, H,14282166.240.000.0074.9891.26
Diaz, Trevor, B,2051954.960.000.000.0054.96
Gonzales, Melanie, C,180891735.980.000.000.001735.98
Deng, Wayne,2145336.960.000.0036.960.00
Smith, Austin,13707149.050.000.000.00149.05
Williams, Destiny, S,15881564.990.000.00564.990.00
Phillips, Haley, B,2807939.980.000.000.0039.98
Peterson, Mason, A,185701174.480.000.001174.480.00
Stewart, Brooke, R,247594369.590.003578.270.00791.32
Ma, Tiffany,2157739.980.000.000.0039.98
Powell, Elijah, E,231135997.330.003578.270.002419.06
Collins, Jonathan,16849119.980.000.000.00119.98
Hall, Wyatt,2382713.980.000.000.0013.98
Flores, Luke, L,247337.280.000.000.007.28

Generated 2025-10-31 12:12:45.627 UTC