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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
James, Adrian, C,253404.990.000.000.004.99
Thompson, Madison, L,187882351.960.000.000.002351.96
Hernandez, José, M,11253696.610.000.0098.97597.64
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Ross, Anna, D,15494275.440.000.0029.99245.45
Turner, Wyatt,200345769.960.003399.990.002369.97
Blue, Melanie, L,178611749.960.000.000.001749.96
Collins, Isaac,260777.280.000.000.007.28
Rivera, Amanda,11131115.920.000.000.00115.92
Bradley, Rachel,158504813.040.000.000.004813.04
Patterson, Hailey, I,112231155.900.000.00267.62888.28
Coleman, Destiny, W,121224814.040.000.002429.972384.07
Simmons, Jennifer,112621010.560.000.00207.93802.63
Flores, Stephanie,259922721.550.000.002181.56539.99
Nelson, Henry,193941155.480.000.000.001155.48
Cooper, Brian, L,13760128.840.000.000.00128.84
Martin, Brianna, M,235834829.390.003578.270.001251.12
Davis, Daniel,11711999.220.000.0086.48912.74
Hall, Eduardo,16847189.940.000.000.00189.94
Brown, Jonathan,11875265.420.000.000.00265.42
Peterson, Jessica, M,11868247.010.000.0061.97185.04
Gray, Cody, C,144594775.010.000.000.004775.01
Yang, Jordan, K,14458133.950.000.000.00133.95
Chen, Jack, E,17579151.430.000.000.00151.43
Adams, Connor,214232888.560.000.002049.10839.46
Hall, Grace, A,201894.990.000.000.004.99
Jenkins, Samantha,113311290.330.000.00410.31880.02
Russell, Samuel, V,11652310.930.000.000.00310.93
Russell, Oscar, A,12140118.170.000.000.00118.17
Umeda, Masaki,16717233.810.000.000.00233.81
Howard, Isaiah,259813018.330.002443.350.00574.98
Malhotra, Kristi, S,151754850.330.000.000.004850.33
Bailey, Richard, N,220504160.533578.270.000.00582.26
Hayes, Gavin, A,194001179.470.000.000.001179.47
Powell, Ian,2608564.470.000.000.0064.47
Phillips, Kyle,12158202.200.000.000.00202.20
Henderson, Ashley,111851381.370.000.00232.801148.57
Campbell, Chloe,11212760.930.000.00231.72529.21
Reed, Michelle,2804669.990.000.000.0069.99
Sanchez, Adrian, L,13179190.170.000.000.00190.17
Rogers, Sean, G,18685124.460.000.000.00124.46
Collins, Lucas, T,219214142.753578.270.000.00564.48
Gray, Sebastian, B,138782366.960.000.000.002366.96
Rivera, Allison, M,13751224.910.000.000.00224.91
Ross, Elizabeth, E,141184741.340.000.000.004741.34
Stewart, Sara,17347119.720.000.000.00119.72
Scott, Mason,2355139.980.000.000.0039.98
Collins, Hailey,11709325.890.000.0021.49304.40
Green, Blake, P,11719287.200.000.000.00287.20
Parker, Kaylee, M,2773878.980.000.000.0078.98
Edwards, Alexandra,133582386.940.000.000.002386.94
Stewart, Melissa,2517336.960.000.000.0036.96
Rodriguez, Joshua, A,235114843.110.003578.270.001264.84
Thomas, William, A,216142589.090.000.002049.10539.99
Sanchez, Allison,1666741.720.000.000.0041.72
Cooper, Amanda, P,146064716.020.000.000.004716.02
Perez, Dalton,110911125.360.000.00213.86911.50
Smith, Andrew,1472387.570.000.0014.9872.59
Smith, Chloe,17619163.920.000.000.00163.92
Allen, Angel, G,15571101.850.000.0034.8966.96
Sanders, Hailey,19647282.040.000.000.00282.04
Moore, Jennifer, A,2175964.470.000.000.0064.47
Jackson, Elizabeth, K,16837155.470.000.000.00155.47
Brooks, Jacqueline, W,28254166.280.000.000.00166.28
Morgan, Jada, A,11520702.990.000.00137.45565.54
Morgan, Andrea, M,16870149.040.000.00116.4432.60
James, Morgan, E,2324539.980.000.000.0039.98
Evans, Connor, J,15402131.550.000.000.00131.55
Malhotra, Gerald, A,28773127.950.000.000.00127.95
Walker, Charles,11677298.210.000.000.00298.21
Long, Gavin,13762186.030.000.000.00186.03
Perry, Dalton, A,16149192.040.000.000.00192.04
Alexander, Angelica,2271471.950.000.000.0071.95
Carter, Sydney,12959203.920.000.000.00203.92
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
Long, Gabrielle,198305765.923374.990.000.002390.93
Martin, Lucas, L,221144183.233578.270.000.00604.96
Murphy, Emma,198445807.930.003374.990.002432.94
Brooks, Paige,222325985.310.003578.270.002407.04
Smith, John,198555709.960.003399.990.002309.97
Perry, Melissa,221284142.230.003578.270.00563.96
Parker, Madeline, H,221826006.320.003578.270.002428.05
Williams, Ryan, R,222475978.610.003578.270.002400.34
Miller, Joseph, A,227134148.190.003578.270.00569.92
Brooks, Makayla,222526047.320.003578.270.002469.05
Barnes, Alexandra, P,222686031.310.003578.270.002453.04
Howard, Morgan, T,229713578.270.003578.270.000.00
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Long, Julia, R,228895971.330.003578.270.002393.06
Thomas, Alexandra, C,231724809.390.003578.271231.120.00
Gonzales, Ashley, C,1860051.970.000.000.0051.97
Campbell, Hunter,17422174.920.000.000.00174.92
Sandberg, Isaac,1335053.970.000.000.0053.97
Tang, Carl,2123832.270.000.000.0032.27
Butler, Victoria,132844767.530.000.000.004767.53
Ross, Antonio,18322148.890.000.000.00148.89
Alexander, Ashley, J,200074495.480.003374.990.001120.49
Thompson, Jose,237314828.110.003578.270.001249.84
Sanz, Lori, L,238654891.610.003578.270.001313.34
Peterson, Gabrielle, D,243104829.390.003578.270.001251.12
Hughes, Edward,200234530.470.003374.990.001155.48
Bennett, Seth,244933578.270.003578.270.000.00
Allen, Aaron, A,200753399.990.003399.990.000.00
Price, Isabelle,201825749.970.003374.990.002374.98
Prasad, Molly,243924329.610.003578.270.00751.34
Murphy, Juan, T,246463578.270.003578.270.000.00
Garcia, Victoria, V,245013578.270.003578.270.000.00
Long, Caleb, P,250462181.560.002181.560.000.00
Green, Sophia, E,249772181.560.002181.560.000.00
Adams, Haley, M,247862443.350.002443.350.000.00
Sanders, Paige,252872983.340.002443.350.00539.99
Jai, Adam,250952443.350.002443.350.000.00
Huang, Kristen,251002443.350.002443.350.000.00
Carter, Luis, E,258832443.350.002443.350.000.00
Gomez, Renee, L,253712181.560.002181.560.000.00
Price, Jocelyn, D,258752443.350.002443.350.000.00
Clark, Anthony,27071782.990.00782.990.000.00
Cook, Steven, J,27053782.990.00782.990.000.00
Harris, Edward,27062782.990.000.00782.990.00
Perry, Olivia,203754438.380.000.002071.422366.96
Ramirez, Abigail, S,1585974.140.000.000.0074.14
Bailey, Morgan, E,213542646.400.000.002071.42574.98
Smith, Katherine, J,13197105.190.000.000.00105.19
Thomas, Dylan,198737.280.000.000.007.28
Hill, Sydney,264821000.440.000.001000.440.00
Griffin, Cassidy,264961000.440.000.001000.440.00
Cooper, Christina, C,265121000.440.000.001000.440.00
Evans, James, C,206654408.560.000.002049.102359.46
Stewart, Andrea, M,27252782.990.000.00782.990.00
Thompson, Devin,207084406.400.000.002071.422334.98
Phillips, Kaylee,211384371.380.000.002049.102322.28
James, Timothy,213312670.890.000.002670.890.00
Rivera, Caitlin, L,261132730.540.000.002181.56548.98
Patterson, Alexis,213484392.020.000.002049.102342.92
Coleman, Ashley,27297782.990.000.00782.990.00
Kelly, Bryan,213492989.380.000.002989.380.00
Richardson, Melissa, E,111322371.940.000.000.002371.94
Diaz, Ryan, J,16910141.960.000.0071.9769.99
Hill, Alexandra, K,15172215.450.000.0036.27179.18
Rubio, Javier, E,1972664.240.000.0064.240.00
Diaz, Faith, M,2236356.970.000.000.0056.97
Prasad, Summer, M,2214339.980.000.0039.980.00
Scott, Adam,15863243.010.000.000.00243.01
Taylor, Lucas, V,115232376.960.000.002376.960.00
Reed, Sean, L,145974803.310.000.000.004803.31
Hughes, Isabella,2304851.460.000.000.0051.46
Adams, Gabriel, S,195271219.450.000.000.001219.45
Price, Devin, M,18758158.510.000.0073.5584.96
Adams, Carlos,1982236.960.000.000.0036.96
Washington, Alexandra, E,15498256.520.000.0074.46182.06
Alexander, Gavin, K,2932249.990.000.000.0049.99
Perez, Savannah, J,17036176.950.000.0056.97119.98
Lal, Jonathan,2009671.460.000.000.0071.46
Foster, Edward, R,18355150.950.000.000.00150.95
Lee, Ian,19646197.040.000.000.00197.04
Ramirez, Gabrielle, H,160004813.950.000.000.004813.95
Rowe, Todd,14586233.940.000.000.00233.94
Robinson, Joseph,2814194.480.000.0094.480.00
Allen, Madeline,2924068.970.000.000.0068.97
Walker, Ian,16771104.550.000.0054.5849.97
Taylor, Edward, C,17442319.880.000.00230.9088.98
Hayes, Carson, A,124472331.950.000.000.002331.95
Thomas, Matthew, K,13239185.700.000.000.00185.70
Hall, Lauren, A,19648100.840.000.000.00100.84
Long, Rachel,2828339.980.000.000.0039.98
Bell, Danielle,140414765.020.000.000.004765.02
Bell, Garrett, J,14265161.230.000.000.00161.23
Price, Riley, R,139094764.020.000.000.004764.02
Baker, Gabriella,174041709.980.000.000.001709.98
Hall, Noah, A,1525175.250.000.000.0075.25
Jai, Samuel, L,1635887.950.000.0039.9947.96
Diaz, Thomas, O,16020595.960.000.000.00595.96
Stewart, Marcus, R,2063221.980.000.000.0021.98
Rubio, Jaime, R,15007209.830.000.0049.97159.86
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Jackson, Brianna,1537797.910.000.0074.9822.93
Garcia, Isabella,18382204.940.000.000.00204.94
Nelson, Jose,19217185.020.000.0091.9593.07
Bryant, Isabella, L,229956060.500.003578.270.002482.23
Turner, James, E,16841126.960.000.0069.9956.97
Edwards, Logan,250024.990.000.000.004.99
Diaz, Brandon,236764.990.000.004.990.00
Garcia, Rachel, L,129864823.010.000.002369.972453.04
Diaz, Kaitlyn, B,292304.990.000.004.990.00
Murphy, Catherine, L,1650692.050.000.000.0092.05
Young, Kaylee, S,13756298.490.000.0058.47240.02
Moore, Taylor, A,199874564.450.003374.990.001189.46
Ramirez, Richard, C,282397.280.000.007.280.00
Ramos, Derrick,18449100.940.000.0030.9769.97
Gonzales, Kayla,214947.280.000.000.007.28
Rivera, Kaitlyn, R,154904813.520.000.000.004813.52
Cooper, Andrea,2932378.980.000.000.0078.98
Baker, Ian, V,262002756.540.000.002181.56574.98
Lewis, Brandon, A,2903769.990.000.000.0069.99
Roberts, Seth, H,11510258.150.000.0039.47218.68
Wilson, Daniel, K,142814746.300.000.000.004746.30
Simmons, Dylan,16133107.850.000.0038.8868.97
White, Nicole,16731155.910.000.0084.9670.95
Collins, Xavier, C,16646250.910.000.000.00250.91
Perez, Charles,266937.280.000.007.280.00
Powell, Jasmine, A,11505846.770.000.0077.77769.00
Gonzales, Cameron, L,2900569.990.000.0069.990.00
Ramirez, Emma,29072128.970.000.000.00128.97
Lewis, Brianna, H,14282166.240.000.0074.9891.26
Campbell, Timothy,2584513.980.000.000.0013.98
Roberts, Wyatt,15900699.970.000.00699.970.00
Turner, Kaylee, M,16213154.540.000.000.00154.54
Alexander, Jason,2932849.990.000.000.0049.99
Brooks, Bryce,12061140.170.000.00112.2527.92
Rivera, Rachel, S,2899678.980.000.000.0078.98
Kumar, Elijah,15197156.920.000.000.00156.92
Parker, Caleb, A,2631813.980.000.000.0013.98
Flores, Brandon, L,2562189.970.000.000.0089.97
Hayes, Hannah, J,2165656.970.000.000.0056.97
Parker, Jordan,216212616.860.000.002049.10567.76
Reed, Bryan,18884133.930.000.000.00133.93
Russell, Nicole, M,182372318.960.000.000.002318.96
Thomas, David,168363193.790.000.000.003193.79
Hayes, Austin,202083219.580.002049.100.001170.48
Griffin, Seth, R,17585164.460.000.0078.9885.48
Cox, Arianna, D,1892789.250.000.000.0089.25
Garcia, Jonathan,1888386.960.000.0029.9956.97
Green, Samuel, D,14096174.730.000.000.00174.73
Mitchell, Bailey, B,267067.280.000.007.280.00
Foster, Aaron,155664912.470.000.000.004912.47
Flores, Eduardo, S,2896962.980.000.000.0062.98
Stewart, Alexandria,174761700.990.000.000.001700.99
Brooks, Ian, W,2829064.470.000.000.0064.47
Powell, Angela, R,12970471.110.000.000.00471.11
Hernandez, Eduardo, J,18919300.940.000.00300.940.00
Thomas, Edward, E,19147133.710.000.000.00133.71
Parker, Morgan, S,1677236.960.000.0014.9821.98
Martinez, Grace, M,17385208.690.000.0069.97138.72
Harris, Joshua, L,2028095.940.000.0030.9764.97
Martinez, Jill,242354829.390.003578.270.001251.12
Morgan, Evan, G,14725318.830.000.0069.97248.86
Hayes, Jason,261764.990.000.000.004.99
Kelly, Julia,2379867.930.000.0067.930.00
Malhotra, Brenda,133912405.470.000.000.002405.47
Smith, Hannah, J,2526554.980.000.0054.980.00
Bailey, Lauren,15864103.550.000.000.00103.55
White, Emily, M,159174679.060.000.000.004679.06
Turner, Eduardo,158764789.020.000.000.004789.02
Gray, Mackenzie, L,1768056.970.000.000.0056.97
Parker, Katherine,13268289.700.000.0068.97220.73
Carter, Katherine,11861286.300.000.000.00286.30
Lewis, Morgan,17410168.740.000.000.00168.74
Clark, Emily, R,120862294.990.000.000.002294.99
Russell, Richard,2763322.260.000.000.0022.26
Watson, Marcus,2271585.480.000.000.0085.48

Generated 2025-11-04 06:11:52.520 UTC