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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Nara, Omar, J,1353559.200.000.000.0059.20
Simmons, Wyatt, V,226041735.980.000.000.001735.98
Hernandez, Adrienne, Y,226681174.480.000.001174.480.00
Zhou, Cara,1135038.470.000.0038.470.00
Carlson, Lee, S,2107937.270.000.000.0037.27
Lopez, Samuel, L,26858553.970.000.000.00553.97
Fernandez, Kari,13788200.810.000.000.00200.81
Gill, Alfredo, M,236292466.320.000.002466.320.00
Andersen, Brad, S,26992583.970.000.000.00583.97
Perez, Dominic, A,239401120.490.000.000.001120.49
Madan, Donald, R,2716867.490.000.000.0067.49
Zeng, Aimee,1934231.270.000.000.0031.27
Taylor, Blake, S,178893043.330.000.002443.35599.98
Gill, Paula, W,285242398.050.000.000.002398.05
Mr., Shimshoni, Daniel,247051155.480.000.000.001155.48
Lal, Tasha, A,2840823.780.000.000.0023.78
Torres, Juan, M,12746105.240.000.000.00105.24
Allen, Jada,26866615.460.000.000.00615.46
Black, Willie,1817239.980.000.000.0039.98
Ramos, Darren,25470162.990.000.000.00162.99
Zhao, Stacey, J,283652433.040.000.000.002433.04
Rogers, Bryan,26890588.960.000.000.00588.96
Perez, Clifford, R,1569039.980.000.000.0039.98
Ma, Damien,1561279.970.000.000.0079.97
Harrison, Bianca, J,1788638.970.000.000.0038.97
Jai, Shawn, E,255011155.480.000.000.001155.48
Shan, Tommy, H,226141155.480.000.001155.480.00
Morgan, Kimberly, A,287352420.340.000.000.002420.34
Brooks, Savannah, R,245582487.330.000.000.002487.33
Williams, Jennifer, E,1945792.480.000.000.0092.48
Gomez, Jésus,294011223.840.000.001223.840.00
Raman, Martin,1770978.950.000.0048.9729.98
Wang, Tamara, L,1788159.980.000.000.0059.98
Munoz, Meghan, P,27810578.460.000.000.00578.46
Dominguez, Jay, A,218572487.330.000.002487.330.00
Carlson, Derrick, R,28436617.470.000.000.00617.47
Liang, Krystal, S,124045251.710.000.002071.423180.29
Lal, Lindsay, H,2055764.970.000.000.0064.97
Fernandez, Ruben,199274.990.000.000.004.99
Yang, Jackson,225701735.980.000.000.001735.98
Gutierrez, Audrey,178292983.330.000.002181.56801.77
Gutierrez, Eddie, R,28370638.950.000.000.00638.95
Patel, Troy,1496848.970.000.000.0048.97
Gill, Krista,1266477.960.000.000.0077.96
Sanchez, Brett,126085689.880.000.002049.103640.78
Carlson, Diane, W,2107443.970.000.000.0043.97
Beck, Clayton,1157943.980.000.000.0043.98
Carlson, Micheal, E,271643.990.000.000.003.99
Carlson, Linda, J,126095636.900.000.002049.103587.80
Ruiz, Ruben, A,2005582.970.000.000.0082.97
Garcia, Tabitha,27778539.990.000.000.00539.99
Johnsen, Rebekah, J,199194.990.000.000.004.99
Torres, Shannon,126125657.910.000.002049.103608.81
Scott, Kyle, D,11419231.750.000.00182.7848.97
Moreno, Raquel, D,256372510.940.000.000.002510.94
Suarez, Kristine,1628264.250.000.000.0064.25
Nara, Casey, E,178122983.330.000.002181.56801.77
Rai, Darrell, C,2690667.490.000.000.0067.49
Gutierrez, Kristy,241381194.970.000.000.001194.97
Gill, Kristi, A,27171588.960.000.000.00588.96
Hernandez, Renee, C,178032761.020.000.002181.56579.46
Zheng, Nuan,13604132.940.000.000.00132.94
Moreno, Kari, S,1505244.570.000.007.2837.29
Zeng, Alan, M,223211700.990.000.000.001700.99
Nicholls, Jay, K,178133020.300.000.002443.35576.95
Randall, Mayra,27909548.980.000.000.00548.98
Ye, Stacey,1256867.460.000.0067.460.00
Wang, Kyle,2059932.270.000.000.0032.27
Luo, Chad, R,210402566.950.000.002566.950.00
Johnsen, Jerome,28367600.460.000.000.00600.46
Li, Caleb,226401149.470.000.001149.470.00
Browning, Marie,26372548.980.000.000.00548.98
Jiménez, Arthur, K,209822546.960.000.002546.960.00
Liang, Mandy,28371539.990.000.000.00539.99
Williams, Emma, K,16325171.270.000.000.00171.27
Raje, Omar, R,12309102.260.000.000.00102.26
Ye, Omar,210202497.960.000.00782.991714.97
Coleman, Christian,257982452.340.000.000.002452.34
Kelly, Carlos, C,2856123.780.000.000.0023.78
Chen, Wesley, J,2942721.490.000.000.0021.49
Romero, Joe, J,179432781.540.000.002181.56599.98
Gomez, Neil,2942625.480.000.000.0025.48
Collins, Richard, S,1625681.960.000.000.0081.96
Suri, Terrance, C,2104634.980.000.000.0034.98
Zhou, Martha, M,14804138.960.000.000.00138.96
Wang, Christy,1949831.270.000.000.0031.27
Morgan, Lauren,242171209.470.000.000.001209.47
Liang, Jessie,1951324.990.000.000.0024.99
Alonso, Felicia, A,26842539.990.000.000.00539.99
Arun, Evelyn,2784223.780.000.000.0023.78
Tang, Johnny,1511968.870.000.000.0068.87
She, Raul,1949728.980.000.000.0028.98
Liu, Alan, V,1646444.970.000.000.0044.97
Henderson, Anna,248574.990.000.000.004.99
Sanz, Randall, D,2253998.960.000.000.0098.96
Thompson, Nathan, T,2552338.980.000.000.0038.98
Sanz, Jaime, C,199284.990.000.000.004.99
Lopez, Harold,26913607.960.000.000.00607.96
Diaz, Neil, C,18181185.920.000.000.00185.92
Mehta, Cynthia,14175108.960.000.000.00108.96
Martin, Billy, B,2684938.980.000.000.0038.98
Gao, Autumn, W,2408539.980.000.0039.980.00
Yuan, Gregory,21822564.990.000.000.00564.99
Suri, Summer,26219570.470.000.000.00570.47
Shan, Alicia,279646.280.000.000.006.28
Gomez, Meredith,27965565.470.000.00565.470.00
Rivera, Garrett,226421198.970.000.001198.970.00
Rogers, Melissa, J,284152428.050.000.000.002428.05
Zhou, Colin,179622777.520.000.002181.56595.96
Lin, Brent, L,277886.280.000.006.280.00
Lin, Cara,294111223.840.000.001223.840.00
Shen, Kara, C,2362869.970.000.000.0069.97
Vazquez, Cheryl, A,179483045.300.000.002443.35601.95
Anand, Wayne, H,226861243.440.000.001243.440.00
She, Cara, H,226461155.480.000.001155.480.00
Cook, Rachel, T,23614144.450.000.000.00144.45
Fernandez, Dominique,128394392.020.000.002049.102342.92
Gill, Adrienne,14953202.460.000.00202.460.00
Hall, Destiny, G,25615574.980.000.00574.980.00
Jimenez, Diana, M,1777672.250.000.000.0072.25
Ma, Alisha,179722791.530.000.002181.56609.97
Romero, Eddie,2888338.980.000.000.0038.98
Torres, Randall,25646539.990.000.00539.990.00
Rai, Colin, W,245732563.350.000.000.002563.35
Raje, Kate,179742791.460.000.002181.56609.90
Adams, Ian, C,2942262.980.000.000.0062.98
Sanz, Krista,278063.990.000.003.990.00
Nath, Katrina, R,1149734.990.000.000.0034.99
Yuan, Katie,194593478.780.000.003478.780.00
Vazquez, Lance,1137678.480.000.000.0078.48
Gomez, Melody,258052501.310.000.000.002501.31
He, Clarence,16591137.960.000.000.00137.96
Alvarez, Krista,194673485.380.000.003485.380.00
Vance, Francisco, A,2097269.970.000.000.0069.97
Rana, Geoffrey,2874527.770.000.000.0027.77
Madan, Troy,254671151.760.000.000.001151.76
Xie, Carly, R,132536774.450.000.002071.424703.03
Morgan, Arianna,1815548.970.000.000.0048.97
Malhotra, Allen, A,1510297.350.000.000.0097.35
Yuan, Shawn, P,27762574.980.000.000.00574.98
Diaz, Blake, E,181356921.580.000.002181.564740.02
Adams, Sean, J,162934.990.000.000.004.99
Shen, Derek, T,225861739.460.000.000.001739.46
Moreno, Gary, E,2154429.980.000.000.0029.98
Rogers, Cody, F,26892553.970.000.000.00553.97
Lin, Alejandro, L,12563118.960.000.000.00118.96
Zhang, Jake,226161735.980.000.000.001735.98
Dominguez, Albert,27125607.960.000.000.00607.96
Diaz, Jimmy, D,2547438.980.000.000.0038.98
Butler, Kayla, J,25748539.990.000.00539.990.00
Lu, Brittney, A,1284873.960.000.000.0073.96
Raman, Francisco, M,2402013.980.000.000.0013.98
Chen, Jessie,240691174.480.000.000.001174.48
Goel, Christy,2640967.490.000.0067.490.00
Henderson, Hunter, C,1481263.970.000.000.0063.97
Rai, Kara, D,2697038.980.000.000.0038.98
Liu, Stacey, A,135574443.380.000.002071.422371.96
Sanz, Erika, J,2267039.980.000.0039.980.00
Diaz, Erik, S,1156534.990.000.000.0034.99
Nelson, Haley,27185588.960.000.000.00588.96
Xie, Alejandro,2578139.980.000.000.0039.98
Romero, Linda, K,2072563.970.000.000.0063.97
Martin, Audrey,13791107.850.000.000.00107.85
Ramos, Erik, M,253121198.970.000.000.001198.97
Diaz, Larry, T,13664210.250.000.000.00210.25
Roberts, Mackenzie,2359942.930.000.000.0042.93
Gill, Cheryl, R,2841060.470.000.0060.470.00
Smith, Jasmine,2889138.980.000.000.0038.98
Suri, Michele,1800738.980.000.000.0038.98
Clark, Marcus, G,2795838.980.000.000.0038.98
Munoz, Lori, M,226391155.480.000.001155.480.00
Sai, Roy, J,1603884.250.000.000.0084.25
Malhotra, Ruth, D,1632189.970.000.000.0089.97
Munoz, Arthur, L,226081744.970.000.000.001744.97
Dominguez, Erik, L,2603738.980.000.0038.980.00
Travers, Jill, A,1660277.270.000.000.0077.27
Zheng, Jessie, W,180283001.040.000.002181.56819.48
Alvarez, Neil, C,224671732.260.000.000.001732.26
Zhu, Autumn,14840157.960.000.0033.98123.98
Luo, Sharon, D,1155321.490.000.000.0021.49
Lin, Candice, K,195063480.380.000.001000.442479.94
Zhou, Damien,257762514.610.000.000.002514.61
Garcia, Abigail,14531190.540.000.00118.9671.58
Morgan, Angel, G,248351170.480.000.000.001170.48
Castro, Jacquelyn,210932515.250.000.002515.250.00
Navarro, Micheal,2362578.960.000.000.0078.96
Alvarez, Julio,262052451.300.000.000.002451.30
Sharma, Nichole, M,1469236.270.000.000.0036.27
Ward, Marcus, L,195113524.360.000.001000.442523.92
Li, Jorge, V,2013328.980.000.000.0028.98
Ms., Smith, Mary, J.,28437567.760.000.000.00567.76
Deng, Yolanda,28427539.990.000.000.00539.99
Rai, Warren, F,215341622.450.000.001622.450.00
Zhu, Laura, M,2943923.780.000.000.0023.78
Lin, Vincent, A,28516563.770.000.000.00563.77
She, Deborah,255761170.480.000.000.001170.48
Coleman, Jessica,135535603.240.000.002071.423531.82
Pal, Kristin, E,26956607.960.000.000.00607.96
Williams, Blake,2942178.480.000.000.0078.48
Mr., Sneath, Timothy,1770829.480.000.000.0029.48
Xie, Katie, C,199163354.390.000.001000.442353.95
Rai, Donna,1223562.760.000.0034.9927.77
Patel, Denise,2017924.990.000.000.0024.99
Gonzales, Isabella, R,1481563.970.000.000.0063.97
Gomez, Beth, C,132546801.130.000.002049.104752.03
Allen, Miguel, C,1138513.980.000.000.0013.98
Sanz, Natasha,14839156.250.000.000.00156.25
Smith, Ethan,1453072.860.000.0036.5936.27
Moreno, Paula, W,135545641.250.000.002071.423569.83
Suri, Veronica, D,239674.990.000.000.004.99
Rubio, Jill,13838140.550.000.000.00140.55
Anderson, Benjamin,2080932.280.000.000.0032.28
Gutierrez, Craig,190494838.300.000.002443.352394.95
Subram, Lydia, F,285492418.050.000.000.002418.05
Sharma, Cassie, A,26978553.970.000.000.00553.97
Sanz, Neil, M,2262258.980.000.000.0058.98
Goel, Shawn, L,190584524.480.000.002181.562342.92
Campbell, Andrea,256896.280.000.000.006.28
Madan, Douglas,269716.280.000.000.006.28
Diaz, Billy,2183992.480.000.000.0092.48
She, Wayne,236072451.300.000.002451.300.00
Yuan, Arturo,2096834.980.000.000.0034.98
Shan, Aaron,2073068.970.000.000.0068.97
Lee, Emily,2058532.270.000.000.0032.27
Li, Steve,2113737.270.000.000.0037.27
Turner, Charles,2418812.940.000.000.0012.94
Morris, Jacqueline, H,294682428.050.000.000.002428.05
Jenkins, Spencer, S,1486232.280.000.000.0032.28
Sai, Gerald, L,27894548.980.000.000.00548.98
Goel, Johnny, J,2256948.970.000.0048.970.00
Shan, Carly,1863124.990.000.000.0024.99
Huang, Martha, E,2640838.980.000.000.0038.98
Guo, Alvin, R,288786.280.000.000.006.28
Arun, Virginia,25655571.720.000.00571.720.00
Sara, Manuel,1261167.460.000.000.0067.46
Lu, Colin, H,2106969.970.000.000.0069.97
Suri, Ebony, A,228082478.340.000.002478.340.00
Xie, Katrina, M,2689738.980.000.0038.980.00
Blue, Oscar, L,27008616.950.000.000.00616.95
Rivera, Katelyn,2394868.490.000.000.0068.49
Wu, Roger,226301164.470.000.001164.470.00
Evans, Lucas, J,1155621.490.000.000.0021.49
Travers, Linda,2942053.990.000.000.0053.99
Henderson, Tristan,1222484.980.000.000.0084.98
Rodriguez, Noah, J,2232513.980.000.000.0013.98
Wu, Trisha,264041775.470.000.000.001775.47
Black, Nichole,224221735.980.000.000.001735.98
Sai, Jillian,225181735.980.000.000.001735.98
Romero, Melinda,12260241.760.000.00182.7858.98
She, Kurt,262062478.340.000.000.002478.34

Generated 2025-11-03 21:13:42.244 UTC