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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Johnson, Jeremiah, A,14446146.750.000.0014.98131.77
Robinson, Ian, D,138522294.990.000.000.002294.99
Taylor, Brianna,17027230.900.000.0051.96178.94
Peterson, Kaitlyn, S,137062337.270.000.000.002337.27
Barnes, Haley, J,2133939.980.000.0039.980.00
Gonzalez, Madeline, B,189222326.960.000.000.002326.96
Yuan, Yolanda, C,2215436.960.000.0036.960.00
Bell, Garrett, J,14265161.230.000.000.00161.23
Carter, Jason,11724210.090.000.0071.58138.51
Stewart, Timothy, F,13199105.190.000.0022.9382.26
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Stewart, Lucas, J,2934198.970.000.000.0098.97
Moore, Andrew, A,13944150.130.000.0036.27113.86
Price, Jeremy,259892744.520.000.002181.56562.96
Washington, Hannah, A,291307.280.000.007.280.00
Ashe, Alexis, S,194141145.480.000.000.001145.48
Hill, Jordan, J,16005198.730.000.000.00198.73
Russell, Oscar, A,12140118.170.000.000.00118.17
Hernandez, Jamie,27283119.980.000.000.00119.98
Green, Kaylee, C,2618567.970.000.000.0067.97
Ramirez, Brian, M,116182369.960.000.000.002369.96
Baker, Sara, M,11827512.470.000.000.00512.47
Phillips, Isaiah,28631144.470.000.000.00144.47
Powell, Miranda, J,153044843.000.000.000.004843.00
Torres, Pedro, E,16958168.020.000.000.00168.02
Foster, Isabelle,2637739.980.000.000.0039.98
Xu, Louis,2010466.530.000.000.0066.53
Watson, Victoria,16125588.960.000.000.00588.96
Morgan, Timothy,14633242.500.000.000.00242.50
Patterson, Eduardo,11142866.810.000.000.00866.81
Flores, Emily,13206163.190.000.000.00163.19
Mitchell, Evan, R,247314.990.000.000.004.99
Morris, Jessica,289678.990.000.000.008.99
Ross, Rachel, C,206693169.590.000.002049.101120.49
Perez, Savannah, J,17036176.950.000.000.00176.95
Li, Rafael, M,217527.280.000.000.007.28
Washington, Kayla, E,14655174.960.000.000.00174.96
Sharma, Jackson,16876151.840.000.000.00151.84
Lee, James, J,2881769.990.000.000.0069.99
Thomas, Seth,14567161.280.000.0096.0765.21
Phillips, James, G,16846180.950.000.000.00180.95
Davis, Nicholas,1320173.160.000.000.0073.16
Miller, Victoria,15816188.020.000.000.00188.02
Brooks, Steven, C,14877889.470.000.000.00889.47
Perry, Samuel,18811100.960.000.000.00100.96
Gutierrez, Neil, L,214897.280.000.000.007.28
Collins, Jose,2474839.980.000.000.0039.98
Sanders, Sean,14341175.150.000.000.00175.15
Harris, Isabella,17119214.900.000.000.00214.90
Cooper, Angela,195261179.470.000.000.001179.47
Russell, Arianna,22728149.930.000.000.00149.93
Thomas, Edward, E,19147133.710.000.000.00133.71
Ross, Anna, D,15494275.440.000.000.00275.44
Lewis, Zachary, L,14760167.260.000.000.00167.26
Perry, Benjamin,291652407.040.000.000.002407.04
McDonald, Aaron, J,27734119.980.000.000.00119.98
Martin, Samuel,15874225.440.000.000.00225.44
Lal, Jack, R,185251735.980.000.000.001735.98
James, Maria,1624391.970.000.000.0091.97
Martin, James, M,1987077.250.000.000.0077.25
Hill, Eric, G,2525667.930.000.000.0067.93
Jones, Alexandra, B,2020245.950.000.000.0045.95
Gonzales, Nathan, M,12107222.230.000.000.00222.23
Coleman, Isabel, S,12530337.900.000.000.00337.90
Li, Jordan,17026261.390.000.000.00261.39
Gonzalez, Chelsea, E,181031735.980.000.000.001735.98
Peterson, Isabella,2808039.980.000.000.0039.98
Perry, Christian,246714354.600.003578.270.00776.33
Ramirez, Richard, C,282397.280.000.000.007.28
Bradley, Rachel,158504813.040.000.000.004813.04
Anderson, Daniel,20694146.970.000.000.00146.97
Long, Sarah,173721729.970.000.000.001729.97
Foster, Jessica,2606951.460.000.000.0051.46
Stewart, Amanda, M,1531094.440.000.000.0094.44
Davis, Marcus, T,17337123.910.000.000.00123.91
Mehta, Rebekah, B,2741969.990.000.000.0069.99
Deng, Wayne,2145336.960.000.000.0036.96
Ward, Ian,12056213.920.000.000.00213.92
Williams, Destiny, S,15881564.990.000.000.00564.99
Perez, Jonathan, R,2345512.940.000.000.0012.94
Nelson, James, L,245257.280.000.000.007.28
Gray, Sebastian, B,138782366.960.000.000.002366.96
Reed, Erin, I,14353128.840.000.000.00128.84
Jenkins, Gabrielle, B,216594143.743578.270.000.00565.47
Ross, Isabelle, D,18554155.450.000.000.00155.45
Mitchell, Jonathan, L,221095971.330.003578.272393.060.00
Foster, Samuel, M,18523160.940.000.000.00160.94
Parker, Jennifer, D,221184158.240.003578.270.00579.97
Evans, Dalton, E,127104774.040.000.000.004774.04
Perry, Melissa,221284142.230.003578.270.00563.96
Griffin, Thomas, J,19015125.430.000.000.00125.43
Miller, Benjamin, G,26643699.100.00699.100.000.00
Kelly, Julia,2379867.930.000.000.0067.93
Williams, Ryan, R,222475978.610.003578.270.002400.34
Smith, Hannah, J,2526554.980.000.000.0054.98
Lewis, Seth,26782699.100.00699.100.000.00
Ramirez, Melanie, V,163632481.820.000.000.002481.82
Perry, Oscar,227856029.570.003578.272451.300.00
Gonzalez, Jeremiah,17468128.910.000.000.00128.91
Perez, Eduardo, M,228956029.570.003578.272451.300.00
Parker, Jeremy,2866878.980.000.000.0078.98
Long, Jordan,199884555.470.003399.990.001155.48
Smith, Eduardo,2069139.980.000.000.0039.98
Lewis, Lucas, A,232094802.110.003578.270.001223.84
Jenkins, Dakota, D,2067964.470.000.000.0064.47
Gill, Beth,199975814.980.003374.990.002439.99
Parker, James,11808610.190.000.000.00610.19
Bryant, Kyle,231644807.100.003578.270.001228.83
Hughes, Antonio, P,15913712.270.000.000.00712.27
Rodriguez, Anthony, G,238294802.110.003578.270.001223.84
Sanchez, Katherine, S,24399132.940.000.000.00132.94
Bryant, Isabelle,233974828.110.003578.270.001249.84
Sanchez, Grace,120802354.990.000.000.002354.99
Bryant, Connor,238424828.110.003578.270.001249.84
Patterson, Maria, G,1333094.950.000.000.0094.95
Rodriguez, Morgan,237304828.110.003578.270.001249.84
Hayes, Luis,12880200.730.000.000.00200.73
Martin, Brianna, M,235834829.390.003578.270.001251.12
Wilson, Andrew, R,182362414.990.000.000.002414.99
Foster, Olivia,238063578.270.003578.270.000.00
Long, Xavier,112512318.960.000.000.002318.96
Rodriguez, Joshua, A,235114843.110.003578.270.001264.84
Hall, Morgan,2172641.950.000.000.0041.95
Martinez, Jill,242354829.390.003578.270.001251.12
Reed, Bryan,18884133.930.000.000.00133.93
Hughes, Luke, I,270141274.080.00699.100.00574.98
Henderson, Gabrielle, B,186031205.470.000.000.001205.47
Morgan, Abigail, C,244314334.600.003578.270.00756.33
Washington, Christian, R,2668639.980.000.000.0039.98
Prasad, Molly,243924329.610.003578.270.00751.34
Ross, Natalie, J,12916261.220.000.000.00261.22
Murphy, Juan, T,246463578.270.003578.270.000.00
King, Morgan,196811179.970.000.000.001179.97
Cooper, Stephanie,249762181.560.002181.560.000.00
Hughes, Samantha,2721564.470.000.000.0064.47
Turner, Andrea, A,202093268.550.002049.100.001219.45
Flores, Logan, K,14631848.470.000.000.00848.47
Huang, Kristen,251002443.350.002443.350.000.00
Wilson, Fernando,16643126.960.000.000.00126.96
Gray, Alexandria, E,253632443.350.002443.350.000.00
Wright, Robert, C,158894848.030.000.000.004848.03
Lazecky, Petr,258642443.350.000.002443.350.00
Henderson, Caroline,2008256.970.000.000.0056.97
Price, Stephanie,258922443.350.000.002443.350.00
Walker, John, M,2858969.990.000.000.0069.99
Parker, Natalie, A,251043018.330.000.002443.35574.98
Bennett, Maria, G,229837.280.000.000.007.28
Sanders, Alexandra,259112181.560.000.002181.560.00
Watson, Emma,17481126.940.000.000.00126.94
Russell, Fernando,27084782.990.000.00782.990.00
Suarez, Juan, R,167631700.990.000.000.001700.99
Kumar, Austin,204834400.060.000.002049.102350.96
Cook, Bryce,2864069.990.000.000.0069.99
Wilson, Christian,27085782.990.000.00782.990.00
Stewart, Julia, L,129022329.980.000.000.002329.98
Bell, Eduardo,27101782.990.000.00782.990.00
Russell, Megan,16220562.960.000.000.00562.96
Miller, Katherine, B,27102782.990.000.00782.990.00
Bailey, Hailey, R,262704.990.000.000.004.99
Robinson, Jennifer, L,265041000.440.000.001000.440.00
Morris, Mackenzie, N,2647413.980.000.000.0013.98
Diaz, Hunter, S,27242782.990.000.00782.990.00
Wright, Kyle,2371626.970.000.000.0026.97
White, Christopher, R,260492181.560.000.002181.560.00
Evans, Luke,2917615.230.000.000.0015.23
Davis, Jasmine, M,265291549.420.000.001000.44548.98
Lewis, Isabella,2624267.930.000.000.0067.93
James, Timothy,213312670.890.000.002670.890.00
Taylor, Jeremiah, M,2901278.980.000.000.0078.98
Rivera, Caitlin, L,261132730.540.000.002181.56548.98
Adams, Mackenzie, A,14640812.420.000.000.00812.42
Davis, Emily,27267782.990.000.00782.990.00
Rogers, Faith,2468259.980.000.000.0059.98
Foster, Deb,215012661.400.000.002661.400.00
Hayes, Oscar,2652729.260.000.000.0029.26
Perez, Angel, S,213362628.350.000.002071.42556.93
Long, Brandon, M,16110650.470.000.000.00650.47
Collins, Connor, J,27270782.990.000.00782.990.00
Smith, Tyler, J,2034156.970.000.000.0056.97
Kelly, Bryan,213492989.380.000.002989.380.00
Williams, Ian, M,175581750.470.000.000.001750.47
Ward, Juan, H,215952649.560.000.002049.10600.46
Ortega, Javier, P,127852294.990.000.000.002294.99
Watson, Michelle, H,262352181.560.000.002181.560.00
Clark, Lauren,170341750.980.000.000.001750.98
Powell, Caleb, G,216132610.580.000.002049.10561.48
Hall, Charles,234764.990.000.000.004.99
Garcia, Kaitlyn, J,263102181.560.000.002181.560.00
Phillips, Miguel,2049812.940.000.000.0012.94
Johnson, Andrew, F,262942443.350.000.002443.350.00
Smith, Alexandra,2829261.960.000.000.0061.96
Powell, David, W,266151000.440.000.001000.440.00
Thomas, Emily,2180339.980.000.000.0039.98
Parker, Jordan,216212616.860.000.002049.10567.76
Morgan, Angela,24665109.970.000.000.00109.97
Patterson, Grace, M,27560782.990.000.00782.990.00
Watson, Janet, S,2320859.980.000.000.0059.98
Thomas, Thomas,216292624.080.000.002049.10574.98
Li, Kevin, S,2518813.980.000.000.0013.98
Sanchez, Trinity, J,262792181.560.000.002181.560.00
Smith, Justin, P,1982721.980.000.000.0021.98
Blue, Marcus, L,27550782.990.000.00782.990.00
Jackson, Hannah, G,131432404.970.000.000.002404.97
Powell, Jocelyn, A,216582641.890.000.002071.42570.47
Long, Chloe,167841735.980.000.000.001735.98
Washington, Alexia,27613782.990.000.00782.990.00
Hughes, Eduardo,15564188.520.000.000.00188.52
Morgan, Brianna, D,111362380.470.000.002380.470.00
Lee, Ethan, J,223597.280.000.000.007.28
Davis, Richard, R,15549574.980.000.00574.980.00
Martinez, Jonathan,1330366.250.000.000.0066.25
King, Aaron, L,117394758.030.000.002359.982398.05
Hayes, Carson, A,124472331.950.000.000.002331.95
Alexander, Luke,290432447.050.000.002447.050.00
Bell, Danielle,140414765.020.000.000.004765.02
Alexander, Ryan, J,14078839.480.000.00839.480.00
Nelson, Jennifer,171471700.990.000.000.001700.99
Diaz, Jasmine, A,160983101.290.000.00756.332344.96
Henderson, Logan, C,2236656.970.000.000.0056.97
Martinez, Dominique,287888.990.000.008.990.00
Diaz, Thomas, O,16020595.960.000.000.00595.96
Campbell, Hailey,15507267.840.000.00228.9638.88
White, Edward, J,15847205.460.000.000.00205.46
Diaz, Jason,17374206.630.000.0089.46117.17
Murphy, Caitlin, L,14910839.480.000.000.00839.48
Chen, James, D,11641303.200.000.0021.49281.71
Johnson, Edward, H,23279124.990.000.000.00124.99
Thompson, Tyler,2750269.990.000.0069.990.00
Edwards, Mackenzie, K,2345841.950.000.000.0041.95
Patterson, Jocelyn, D,2355964.470.000.0064.470.00
Patterson, Jeremy,130272319.260.000.000.002319.26
Wedge, Andrew, T,120604811.540.000.002418.482393.06
Parker, Caleb, A,2631813.980.000.000.0013.98
Butler, Trevor,2741569.990.000.0069.990.00
Diaz, Richard, A,2668264.470.000.000.0064.47
Shan, Logan,1867760.960.000.0029.9930.97
Hayes, Hannah, J,2165656.970.000.000.0056.97
Evans, Maria,22544127.280.000.00127.280.00
Peterson, Christina,2897694.480.000.000.0094.48
Ross, Jose,2744178.980.000.0078.980.00
Harris, Matthew,14330806.760.000.000.00806.76
Russell, Rachel, C,2158124.270.000.0024.270.00
Morris, Alyssa,28072548.980.000.000.00548.98
Simmons, Dylan,16133107.850.000.0038.8868.97
Turner, Morgan,11823178.470.000.000.00178.47
Moore, Logan,2634889.970.000.0089.970.00
Kumar, Zachary,254334.990.000.000.004.99
Hughes, Morgan, T,11642392.890.000.000.00392.89
Hall, Kaylee, E,1975137.270.000.000.0037.27
Griffin, Jordan,13095328.890.000.000.00328.89

Generated 2025-12-21 00:16:22.071 UTC