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

248 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Coleman, Dylan,27403132.970.000.000.00132.97
Russell, Xavier,12964119.950.000.000.00119.95
Young, Jenna, W,163652490.180.000.000.002490.18
Long, Natalie,14363192.340.000.000.00192.34
Stewart, Allison, R,18826166.430.000.0069.9996.44
White, Edward, J,15847205.460.000.000.00205.46
Edwards, Angel, J,2912469.990.000.000.0069.99
Harris, Matthew,14330806.760.000.000.00806.76
Rodriguez, Richard,12969180.790.000.000.00180.79
Thompson, Ryan, M,113301111.360.000.00198.94912.42
Taylor, Christian,2076456.760.000.000.0056.76
Wilson, Chloe, A,11640409.120.000.0075.48333.64
Rowe, Todd,14586233.940.000.000.00233.94
Gonzales, Arianna, S,197102351.960.000.000.002351.96
Perry, Ana,112151155.520.000.00292.94862.58
Walker, Thomas,1307193.980.000.000.0093.98
Green, Marcus, C,15974208.410.000.0091.95116.46
Peterson, Xavier, R,2645639.980.000.000.0039.98
Hayes, Logan, J,19026113.240.000.0037.2775.97
Peterson, Jared,11502829.370.000.00171.95657.42
Brown, Jonathan,11875265.420.000.000.00265.42
Griffin, Miguel,2146476.970.000.000.0076.97
Griffin, Haley, L,1892582.180.000.000.0082.18
Martin, John, A,144364776.010.000.000.004776.01
Garcia, Henry, B,112871009.240.000.00219.26789.98
Russell, Elijah, M,118354772.300.000.002319.262453.04
Price, Lauren, J,14079184.740.000.0037.29147.45
Zhang, Robert,188551155.480.000.000.001155.48
Nelson, Sean,11841307.970.000.000.00307.97
Allen, Sean, L,12097159.220.000.000.00159.22
Clark, Lauren,170341750.980.000.000.001750.98
Washington, Thomas, C,2745137.430.000.000.0037.43
Townsend, Bryan,14077180.730.000.000.00180.73
Posti, Juha-Pekka,2221912.940.000.000.0012.94
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Turner, Wyatt,200345769.960.003399.990.002369.97
Alexander, Sarah,1941129.990.000.000.0029.99
Wood, Brittany,2877753.990.000.000.0053.99
Gonzales, Emily, P,21777180.980.000.000.00180.98
Morgan, Jada, A,11520702.990.000.00137.45565.54
Young, Adam,12984200.200.000.0037.29162.91
Wilson, Nathan, L,13936218.930.000.000.00218.93
Henderson, Stephanie, L,19224352.520.000.000.00352.52
Green, Mackenzie, C,280737.280.000.000.007.28
Prasad, Molly,243924329.610.003578.270.00751.34
Murphy, Juan, T,246463578.270.003578.270.000.00
Long, Caleb, P,250462181.560.002181.560.000.00
Sharma, Yolanda, K,250483046.840.002443.35603.490.00
Garcia, Carmen, J,247812181.560.002181.560.000.00
Green, Sophia, E,249772181.560.002181.560.000.00
Hughes, Julia,250612443.350.002443.350.000.00
Martin, Morgan,248322181.560.002181.560.000.00
Huang, Kristen,251002443.350.002443.350.000.00
Zhao, Karen, L,254082735.530.002181.560.00553.97
Gray, Alexandria, E,253632443.350.002443.350.000.00
Hughes, Stephanie,263161000.440.001000.440.000.00
Price, Jocelyn, D,258752443.350.002443.350.000.00
Clark, Anthony,27071782.990.00782.990.000.00
Harris, Edward,27062782.990.000.00782.990.00
Sanders, Alexandra,259112181.560.000.002181.560.00
Russell, Fernando,27084782.990.000.00782.990.00
Hayes, Arianna,259912845.520.000.002181.56663.96
Gonzales, Melissa, W,204704408.690.000.002071.422337.27
Blanco, Randall,263211554.410.000.001000.44553.97
Flores, Stephanie,259922721.550.000.002181.56539.99
Evans, Kaylee,19642133.540.000.000.00133.54
Russell, Caleb,23552103.480.000.000.00103.48
Jai, Luis, A,18320185.920.000.000.00185.92
Foster, Eric,229765971.330.003578.270.002393.06
Powell, Katherine, C,14574177.600.000.000.00177.60
Flores, Arianna,217274132.243578.270.000.00553.97
Jones, Dalton, T,189512334.970.000.000.002334.97
Johnson, Jacob, I,28069553.970.000.000.00553.97
Smith, Megan, J,2671668.970.000.000.0068.97
Jenkins, Alexandra, D,11632924.610.000.00160.51764.10
Sanchez, Jared, J,2585064.470.000.000.0064.47
Flores, Devin, A,15559172.040.000.0086.5685.48
She, Kenneth,16096212.010.000.0080.96131.05
Carter, Isaac,137191129.480.000.000.001129.48
King, Gabrielle,263504.990.000.000.004.99
Williams, Austin,2035432.220.000.000.0032.22
Dominguez, Erika, C,21251191.270.000.000.00191.27
Campbell, Hunter,17422174.920.000.000.00174.92
Thompson, Ethan,199894495.480.003374.990.001120.49
Clark, William,2902169.990.000.000.0069.99
Hughes, Miranda,266784.990.000.000.004.99
Sanchez, Caitlin, M,2208056.970.000.000.0056.97
Robinson, Ian, D,138522294.990.000.000.002294.99
Barnes, Blake, A,178651789.970.000.000.001789.97
Peterson, Brian,12892419.470.000.00156.27263.20
Reed, Megan, A,181181750.980.000.000.001750.98
Smith, Austin,13707149.050.000.000.00149.05
Phillips, Haley, B,2807939.980.000.000.0039.98
Walker, Charles,11677298.210.000.000.00298.21
Adams, Miguel,11659213.520.000.000.00213.52
Chow, Candice,1923260.960.000.000.0060.96
Martinez, Andrew, C,11530523.810.000.00142.94380.87
Henderson, Jackson, A,221215997.330.003578.270.002419.06
Sanders, Hailey,19647282.040.000.000.00282.04
Martin, Thomas, A,169521735.980.000.000.001735.98
Reed, Kaitlyn, H,27413103.480.000.000.00103.48
Perry, Dalton, A,16149192.040.000.000.00192.04
Powell, Spencer,14904468.120.000.000.00468.12
Moore, Ian, L,2463939.980.000.000.0039.98
Foster, Isabelle,2637739.980.000.000.0039.98
Zukowski, Jake,220584118.263578.270.000.00539.99
Alexander, Edward, E,18524195.950.000.000.00195.95
Barnes, Ian, M,16106133.540.000.000.00133.54
Foster, Abigail,1982346.470.000.000.0046.47
Mr., Smith, Jeff,2928353.990.000.000.0053.99
Hughes, Nathan, B,121134737.530.000.002294.992442.54
Green, Kaylee, C,2618567.970.000.000.0067.97
Smith, Samuel, D,2308349.900.000.000.0049.90
Hill, Jordan, J,16005198.730.000.00102.2796.46
Nelson, Jennifer,171471700.990.000.000.001700.99
Bryant, Gabriel,2765669.990.000.000.0069.99
Griffin, Seth, R,17585164.460.000.0078.9885.48
Sharma, Jackson,16876151.840.000.000.00151.84
Lopez, Katelyn,11820232.710.000.0060.47172.24
Thomas, Seth,14567161.280.000.0096.0765.21
Perry, Justin, E,167583062.340.000.000.003062.34
Davis, Marcus, T,17337123.910.000.0086.9536.96
Thomas, Edward, E,19147133.710.000.000.00133.71
Flores, Megan, N,230746021.820.003578.270.002443.55
Martin, James, M,1987077.250.000.000.0077.25
Rodriguez, Natalie,2077330.970.000.000.0030.97
Madan, Carmen, V,155674720.270.000.000.004720.27
Jones, Alexandra, B,2020245.950.000.000.0045.95
Simmons, Dylan,16133107.850.000.0038.8868.97
Brooks, Bryce,12061140.170.000.00112.2527.92
Rodriguez, Taylor,1607166.960.000.000.0066.96
Sharma, Kathryn,20740140.940.000.000.00140.94
Turner, Morgan,11823178.470.000.000.00178.47
Smith, Katherine, J,13197105.190.000.000.00105.19
Brooks, Evan,2340139.980.000.000.0039.98
Long, Sarah,173721729.970.000.000.001729.97
Walker, Richard, T,19640224.550.000.000.00224.55
Thomas, Alexandra, C,231724809.390.003578.271231.120.00
Reed, Marcus,14582111.790.000.0014.9896.81
Harris, Natalie,2368259.980.000.0059.980.00
Gray, Cody, C,144594775.010.000.000.004775.01
Luo, Jodi,2921368.490.000.000.0068.49
Hall, Grace, A,201894.990.000.000.004.99
Winston, Ethan, R,216222612.060.000.002049.10562.96
Russell, Oscar, A,12140118.170.000.000.00118.17
Ross, Alexia, S,13231247.900.000.000.00247.90
Perez, Amber, D,13318214.260.000.00116.9197.35
Bryant, Kyle,231644807.100.003578.271228.830.00
Parker, Katherine,13268289.700.000.0068.97220.73
Rodriguez, Destiny, J,227397.280.000.007.280.00
White, Miguel, S,13988195.520.000.000.00195.52
Cooper, Brian, L,13760128.840.000.000.00128.84
Bryant, Connor,238424828.110.003578.270.001249.84
Stewart, Sara,17347119.720.000.000.00119.72
Green, Blake, P,11719287.200.000.000.00287.20
Parker, Kaylee, M,2773878.980.000.000.0078.98
Diaz, Luke,12054402.530.000.00139.97262.56
Davis, James,11922275.500.000.0034.98240.52
Coleman, Isabel, S,12530337.900.000.00123.98213.92
Prasad, Summer, M,2214339.980.000.0039.980.00
Campbell, Alex,119844730.320.000.002329.982400.34
Gray, Sara,292472447.050.000.002447.050.00
Anderson, David, A,2209761.960.000.0061.960.00
Lee, John,19801193.010.000.000.00193.01
Walker, Ian,16771104.550.000.0054.5849.97
Baker, Sara, M,11827512.470.000.00148.47364.00
Russell, Samantha,11211723.560.000.00118.46605.10
Price, Oscar, G,11833240.010.000.000.00240.01
Martinez, Grace, M,17385208.690.000.0069.97138.72
Morris, Jessica,289678.990.000.008.990.00
Taylor, Tyler, A,12032614.960.000.00614.960.00
Collins, Sierra,185491169.460.000.001169.460.00
Scott, Eric,282484.990.000.004.990.00
Powell, Jasmine, A,11505846.770.000.0077.77769.00
Robinson, Joseph,2814194.480.000.0094.480.00
Baker, Gabriella,174041709.980.000.000.001709.98
Jai, Samuel, L,1635887.950.000.0039.9947.96
Wood, Gabrielle, S,2878713.980.000.000.0013.98
Chandra, Brandy, P,11501603.530.000.000.00603.53
Hill, Kaitlyn, M,2465915.230.000.000.0015.23
Collins, Jose,2474839.980.000.0039.980.00
Nelson, Jose,19217185.020.000.0091.9593.07
Ross, Anna, D,15494275.440.000.0029.99245.45
Ortega, Sheila, M,2763239.980.000.000.0039.98
Rivera, Hailey, R,2079239.980.000.000.0039.98
Flores, Brandon, L,2562189.970.000.000.0089.97
Wright, Katelyn, A,14502122.260.000.0014.98107.28
Russell, Nicole, M,182372318.960.000.000.002318.96
Perry, Benjamin,291652407.040.000.002407.040.00
Martin, Samuel,15874225.440.000.0069.99155.45
Sun, Arturo, C,11498557.540.000.0012.94544.60
Young, Kaylee, S,13756298.490.000.0058.47240.02
Taylor, Madison, A,11802215.290.000.00127.9687.33
Wilson, Andrew, R,182362414.990.000.000.002414.99
Tang, Carl,2123832.270.000.000.0032.27
Moreno, Meredith, D,2228589.970.000.000.0089.97
Yang, Justin, S,153634719.040.000.000.004719.04
Griffin, Jason, L,112001267.110.000.00391.08876.03
Sanchez, Martin, E,216317.280.000.000.007.28
Patterson, Hailey, I,112231155.900.000.00196.04959.86
Reed, Bryan,18884133.930.000.000.00133.93
Johnson, James,234984.990.000.000.004.99
Rogers, Carlos,19645134.440.000.000.00134.44
Lee, Emma,16948176.430.000.000.00176.43
Ross, Natalie, J,12916261.220.000.000.00261.22
Chapman, Nancy, E,11276840.150.000.0066.26773.89
Simmons, Sarah, V,11500651.980.000.00118.96533.02
Martin, Gina, E,11078793.270.000.00158.36634.91
Nelson, Adam, B,27402128.970.000.000.00128.97
Gray, Jesse,14626197.040.000.000.00197.04
Hernandez, José, M,11253696.610.000.0098.97597.64
Jackson, Charles, P,112771305.660.000.00237.821067.84
Bailey, Morgan, E,213542646.400.000.002071.42574.98
Bennett, Antonio, C,11631707.500.000.00216.34491.16
Torres, Erin,1218287.250.000.0037.2949.96
Ward, Angela, M,2775669.990.000.000.0069.99
Yang, Jordan, K,14458133.950.000.000.00133.95
Wilson, Tyler, L,15879196.930.000.000.00196.93
Murphy, Catherine, L,1650692.050.000.000.0092.05
Hernandez, Jonathan, J,1901465.950.000.000.0065.95
Rogers, Amanda, A,13920266.970.000.000.00266.97
Fernandez, Darren,2899278.980.000.000.0078.98
Ward, Devin, J,15378170.910.000.0076.9593.96
Sanders, Xavier,1672173.750.000.000.0073.75
Wright, Robert, C,158894848.030.000.000.004848.03
Russell, Isabella, A,11507645.780.000.0028.48617.30
Washington, Kayla, E,14655174.960.000.0069.97104.99
Richardson, Melissa, E,111322371.940.000.000.002371.94
Parker, James,11808610.190.000.000.00610.19
Turner, Adam, K,16109548.980.000.000.00548.98
Lu, Alejandro,2562039.980.000.000.0039.98
Perry, Ryan,132494795.340.000.000.004795.34
Malhotra, Kristi, S,151754850.330.000.000.004850.33
Umeda, Masaki,16717233.810.000.000.00233.81
White, Abigail, T,15866145.820.000.0038.88106.94
Garcia, Patricia,11651226.430.000.0099.97126.46
Brown, Benjamin, D,151874725.320.000.000.004725.32
Moore, Matthew, W,13267109.950.000.000.00109.95
Chen, James, D,11641303.200.000.0021.49281.71
Watson, Kimberly, A,201883226.900.002071.420.001155.48
Cook, Megan, J,2029956.970.000.000.0056.97
Serrano, Albert, E,133284708.020.000.000.004708.02
Turner, Amanda, L,203183241.900.002071.420.001170.48
Smith, Andrew,1472387.570.000.0014.9872.59
Anderson, Destiny,12895336.650.000.0037.27299.38
Watson, Cole, A,217684118.263578.270.000.00539.99
Henderson, Sarah, M,238674802.110.003578.270.001223.84
Yuan, Carly,19839194.960.000.000.00194.96

Generated 2025-11-05 06:00:22.798 UTC