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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Suarez, Albert, W,2095032.280.000.000.0032.28
Stewart, Natalie, F,17710113.940.000.000.00113.94
Fernandez, Heidi, L,2279824.990.000.000.0024.99
Henderson, Alexandria, R,1155534.990.000.000.0034.99
Morgan, Kimberly, A,287352420.340.000.000.002420.34
Gomez, Beth, C,132546801.130.000.002049.104752.03
Chen, Jessie,240691174.480.000.000.001174.48
Liu, Stacey, A,135574443.380.000.002071.422371.96
Suri, Michele,1800738.980.000.000.0038.98
Subram, Meagan, W,1157334.990.000.000.0034.99
Smith, Tabitha,14787163.450.000.000.00163.45
Martinez, Evelyn, J,17204114.960.000.000.00114.96
Perez, Holly, E,1237675.470.000.000.0075.47
Munoz, Roberto,17628106.240.000.007.2898.96
Suarez, Ross, C,2794038.980.000.000.0038.98
Harrison, Melody,2846860.470.000.000.0060.47
Johnsen, Rebekah, J,199194.990.000.000.004.99
Suarez, Kristine,1628264.250.000.000.0064.25
Gomez, Kristine, E,186273027.320.000.002443.35583.97
Coleman, Jessica,135535603.240.000.002071.423531.82
Subram, Gerald,215173172.970.000.00782.992389.98
Garcia, Kristopher, M,190704748.330.000.002443.352304.98
Ms., Song, Lolan,190734760.320.000.002443.352316.97
Rogers, Christina, F,216682518.970.000.00782.991735.98
Kelly, Carlos, C,2856123.780.000.000.0023.78
Gutierrez, Lori,240651170.480.000.000.001170.48
Lal, Alvin,240581164.470.000.000.001164.47
Muñoz, Kari,1952087.970.000.0087.970.00
Li, Susan,278392419.060.000.002419.060.00
Goel, Christy,2640967.490.000.0067.490.00
Russell, Christian, S,2282634.980.000.0034.980.00
Martinez, Carla,248522457.330.000.000.002457.33
Lu, Clayton, L,2361334.980.000.000.0034.98
Alonso, Tanya, K,26942588.960.000.000.00588.96
Phillips, Gabriel, R,2944388.980.000.000.0088.98
Munoz, Danny,1935524.990.000.000.0024.99
Anderson, Benjamin,2080932.280.000.000.0032.28
Ms., Slattengren, Dianne, K.,279281120.490.000.000.001120.49
Ortega, Robyn,241041155.480.000.000.001155.48
Huang, Martha, E,2640838.980.000.000.0038.98
Pal, Damien, M,225661700.990.000.000.001700.99
Zhang, Jake,226161735.980.000.000.001735.98
Kovar, Kristina, R,26910588.960.000.000.00588.96
Young, Evan,1273935.000.000.000.0035.00
Sanchez, Christina, S,1454628.990.000.0028.990.00
Alvarez, Lance, J,1619079.250.000.007.2871.97
Goel, Johnny, J,2256948.970.000.0048.970.00
Gutierrez, Shannon, L,17101163.940.000.0094.9768.97
Hernandez, Naomi,256866.280.000.000.006.28
Deng, Carly, E,224521735.980.000.000.001735.98
Rai, Arturo, T,225041735.980.000.000.001735.98
Moore, Anna, A,1274471.970.000.000.0071.97
Zhang, Randy,1260155.910.000.000.0055.91
Suri, Andre, D,241891174.480.000.000.001174.48
Black, Tamara, L,242021120.490.000.000.001120.49
Ruiz, Roy, L,287042419.060.000.000.002419.06
Reed, Jesse, E,224291777.950.000.000.001777.95
Subram, Mayra, C,284462398.050.000.000.002398.05
Sara, Manuel,1261167.460.000.000.0067.46
Ms., Smith, Mary, J.,28437567.760.000.000.00567.76
Deng, Corey,28921184.480.000.000.00184.48
Goel, Willie, T,226561169.460.000.000.001169.46
Gao, Ernest,2782827.770.000.000.0027.77
Nara, April, E,25721583.970.000.000.00583.97
Hernandez, Kaitlyn, S,25647563.770.000.000.00563.77
Hu, Steve, A,1629413.980.000.000.0013.98
Thomas, Ryan,225324.990.000.000.004.99
Xu, Michele, K,15353325.830.000.000.00325.83
Ramos, Janet, B,2059632.270.000.000.0032.27
Kapoor, Jillian, R,1570178.860.000.000.0078.86
Madan, Carolyn,26222561.480.000.000.00561.48
Pal, Corey,257742537.320.000.000.002537.32
Andersen, Dale, B,1499269.990.000.000.0069.99
Alonso, Roberto, M,1453368.970.000.000.0068.97
Srini, Molly, L,27790562.960.000.000.00562.96
Raman, Cynthia, P,27786574.980.000.000.00574.98
Andersen, April, C,20973193.980.000.000.00193.98
Shen, Carl, L,1919027.280.000.000.0027.28
Garcia, Meredith,1711047.260.000.000.0047.26
Suri, Clifford,1936963.970.000.000.0063.97
Suri, Tabitha,279576.280.000.000.006.28
Srini, Stanley,1804229.980.000.000.0029.98
Kapoor, Nancy, L,18024149.980.000.000.00149.98
Gill, Clinton,26210553.970.000.000.00553.97
Ruiz, Briana,2090632.280.000.000.0032.28
Luo, Leonard, A,255821164.470.000.000.001164.47
She, Kara,2361734.980.000.000.0034.98
Andersen, Kelli,226021754.980.000.000.001754.98
Jiménez, Javier, M,226871155.480.000.001155.480.00
Lopez, James, E,2080627.280.000.000.0027.28
Rodriguez, Gerald,122166955.410.000.002071.424883.99
Raman, Martin,1770978.950.000.000.0078.95
Subram, Cynthia, A,2096529.990.000.000.0029.99
Torres, Adrienne, C,114828143.030.003374.992354.982413.06
Schmidt, Theresa,2185424.990.000.000.0024.99
Suri, Veronica, D,239674.990.000.000.004.99
Butler, Eduardo, G,13533137.940.000.000.00137.94
Yang, Jackson,225701735.980.000.000.001735.98
Jackson, Lucas, A,254812478.340.000.000.002478.34
Wu, Kelli, T,156215977.740.003578.270.002399.47
Ruiz, Jaime, J,25609565.470.000.00565.470.00
Guo, Clayton, J,223021763.970.000.000.001763.97
Tang, Nichole, C,156305136.370.003578.27806.76751.34
Russell, Jason, A,27949553.970.000.00553.970.00
Campbell, Andrea,256896.280.000.000.006.28
Carlson, Gloria, P,156325245.060.003578.270.001666.79
Martin, Albert,26837548.980.000.000.00548.98
Chandra, Whitney,1571251.570.000.000.0051.57
Garcia, Ryan, J,156928392.300.003578.270.004814.03
Browning, Marie,26372548.980.000.000.00548.98
Yuan, Arturo,2096834.980.000.000.0034.98
Chandra, Mayra,1645314.560.000.000.0014.56
Wang, Cara,2102391.950.000.000.0091.95
Carlson, Kendra,1804432.270.000.000.0032.27
Romero, Sheila,205773080.270.00782.990.002297.28
Torres, Tanya, L,239861184.460.000.000.001184.46
Yuan, Drew, R,216791700.990.000.000.001700.99
Gill, Randall, A,1816582.260.000.000.0082.26
Chen, Wesley, J,2942721.490.000.000.0021.49
Garcia, Bruce, B,1803749.480.000.000.0049.48
Kapoor, Johnathan,205763147.960.00782.990.002364.97
Raje, Kenneth,236062543.440.000.002543.440.00
Alonso, Arthur, M,1905421.980.000.000.0021.98
Luo, Calvin, T,191721609.410.001000.440.00608.97
Reed, Taylor,239831195.470.000.000.001195.47
Lal, Misty, L,2238558.980.000.000.0058.98
Hu, Curtis, G,278802393.060.000.000.002393.06
Raman, George, M,26359600.460.000.000.00600.46
Patel, Chelsea, P,199384.990.000.000.004.99
Sandoval, Jill,1414390.580.000.000.0090.58
Lal, Gilbert,245772487.330.000.000.002487.33
Zhou, Curtis,2550538.980.000.000.0038.98
Sai, Kaitlin, J,14529254.060.000.000.00254.06
Suri, Ebony, A,228082478.340.000.002478.340.00
Madan, Douglas,269716.280.000.000.006.28
Subram, Allen,1789529.980.000.000.0029.98
Lin, Curtis, N,218582492.320.000.002492.320.00
Raji, Tommy,256361174.480.000.000.001174.48
Sharma, Nina,237601183.470.000.000.001183.47
Wu, Susan, L,16564132.270.000.000.00132.27
Sai, Marco,2484029.480.000.000.0029.48
Raje, Tamara, J,1994686.950.000.000.0086.95
Liang, Jeffery,15711126.560.000.000.00126.56
Suri, Dominique,255841169.460.000.000.001169.46
Hughes, Adam,2454637.270.000.000.0037.27
Harris, Jonathan,26220539.990.000.000.00539.99
Ye, Micah, A,2095237.270.000.000.0037.27
Deng, Tonya, O,1793664.970.000.000.0064.97
Zhu, Karen, R,1801225.480.000.000.0025.48
Martinez, Dalton, M,2841323.780.000.000.0023.78
Jai, Shawna, W,177502888.530.000.002181.56706.97
Tang, Carly, A,224701735.980.000.000.001735.98
Romero, Linda, K,2072563.970.000.000.0063.97
Black, Raul,253011170.480.000.000.001170.48
Zhou, Rosa, D,255731155.480.000.000.001155.48
Fernandez, Bruce, E,2688838.980.000.000.0038.98
Ye, Sandra,246891155.480.000.000.001155.48
Diaz, Kathleen, C,28375567.760.000.000.00567.76
Guo, Stacey,242074.990.000.000.004.99
Xu, Eugene, A,14208117.430.000.0058.4758.96
Fernandez, Ruben,199274.990.000.000.004.99
Guo, Dawn, R,256031169.460.000.000.001169.46
Xu, Jenny, K,122226909.100.002049.100.004860.00
Romero, Melinda,12260241.760.000.00182.7858.98
Chandra, Summer, D,2488039.980.000.000.0039.98
Jimenez, Janet, P,171126.280.000.000.006.28
Cook, Carlos, R,26955565.470.000.000.00565.47
Suarez, Sheila,2888411.940.000.000.0011.94
Tang, Tonya,209173234.290.000.00782.992451.30
Suarez, Max, A,14809115.250.000.0078.9836.27
Barnes, Vanessa,1381053.470.000.000.0053.47
Henderson, Dakota, M,164063110.050.002181.56928.490.00
Ruiz, Janet, M,2281856.960.000.0056.960.00
Ms., Shock, Misty,2486939.980.000.000.0039.98
Suarez, Reginald,181777043.560.000.002181.564862.00
James, Arianna, A,2579913.980.000.0013.980.00
Jai, Kelli,225304.990.000.000.004.99
Romero, Darren, A,191951637.380.001000.440.00636.94
Raji, Colin, A,258014.990.000.004.990.00
Evans, Lucas, J,1155621.490.000.000.0021.49
Ward, Alex, I,14542115.250.000.000.00115.25
Gonzales, Emma, P,15681105.560.000.0033.9871.58
Xu, Melvin, A,1147449.970.000.000.0049.97
Raman, Joel,163173001.040.002181.560.00819.48
Blanco, Francis, J,25750553.970.000.000.00553.97
Bell, Haley, A,2943725.480.000.000.0025.48
Raje, Julie, H,122146803.920.002049.100.004754.82
Lu, Brittney, A,1284873.960.000.000.0073.96
Jones, Lucas,271586.280.000.000.006.28
Romero, Kristine, W,1630629.260.000.000.0029.26
Hernandez, Gabriel, J,1380528.980.000.000.0028.98
Zhu, Stacey, E,226361700.990.000.000.001700.99
Gao, Margaret,16401102.250.000.000.00102.25
Xie, Tommy, J,2942523.780.000.0023.780.00
Zhao, Omar,279273.990.000.000.003.99
Taylor, Michael,27907578.460.000.000.00578.46
Schmidt, Mayra,1788429.980.000.000.0029.98
Goel, Kathryn,1274044.980.000.000.0044.98
Ruiz, Ricky,207183283.430.00782.990.002500.44
Deng, Shawn, C,16590168.950.000.000.00168.95
Deng, Lindsay, K,2944723.780.000.000.0023.78
Cooper, Kimberly, J,224574.990.000.000.004.99
Patel, Denise,2017924.990.000.000.0024.99
Wright, Elijah, I,255771155.480.000.000.001155.48
Romero, Juan, A,163243282.810.002443.35839.460.00
Sanz, Natasha,14839156.250.000.000.00156.25
Sun, Brent,255851188.460.000.000.001188.46
Foster, Jordan, M,208073249.310.00782.990.002466.32
Coleman, Gabriel, B,1770637.930.000.000.0037.93
Hu, Candice,27818607.960.000.000.00607.96
Luo, Christy,162773010.030.002181.560.00828.47
She, Kelvin, T,2700238.980.000.0038.980.00
Liang, Clayton, E,1495829.480.000.000.0029.48
Luo, Cassie,164523071.010.002181.560.00889.45
Nath, Katrina, R,1149734.990.000.000.0034.99
Washington, Faith,2084969.970.000.000.0069.97
Tang, Gregory,240481174.480.000.000.001174.48
He, Clarence,16591137.960.000.000.00137.96
Martin, Shannon, W,240454.990.000.000.004.99
Munoz, Kristine,164463093.030.002181.560.00911.47
Madan, Troy,254671151.760.000.000.001151.76
Moreno, Carrie, W,271516.280.000.000.006.28
Sutton, Marshall,208623240.320.000.00782.992457.33
Shan, Aaron,2073068.970.000.000.0068.97
Rai, Darrell, C,2690667.490.000.000.0067.49
Ross, Ryan,164283021.020.002181.560.00839.46
Ashe, Melvin,26817553.970.000.000.00553.97
Johnsen, Jerome,28367600.460.000.000.00600.46
Rai, Kristin, C,1256974.980.000.000.0074.98
Miller, Olivia, H,26860539.990.000.000.00539.99
Torres, Julio,224601750.980.000.000.001750.98
Goel, Kara,164653271.790.000.002443.35828.44
Sanchez, Kari, T,1926224.990.000.0024.990.00
Foster, Mary,241121155.480.000.000.001155.48
Rubio, Jimmy,208372547.950.000.002547.950.00
Martinez, Michele, L,1924724.990.000.0024.990.00
Rivera, Dalton, E,28366578.460.000.000.00578.46
Li, Darryl, T,245492514.930.000.000.002514.93
Navarro, Robin, J,286962428.050.000.000.002428.05
Srini, Ronald, E,164674.990.000.000.004.99
Gutierrez, Arthur, A,1250461.080.000.000.0061.08
Hu, Louis,1618734.920.000.000.0034.92
Sanchez, Gerald,2414439.980.000.000.0039.98
Kumar, Arturo, W,240441174.480.000.000.001174.48
Blanco, Jaime,2252839.980.000.000.0039.98
Torres, Rodney, L,225201775.470.000.000.001775.47
Gill, Craig, R,2937923.780.000.000.0023.78
Muñoz, Armando, E,1990613.980.000.000.0013.98
Luo, Arturo,224611754.980.000.000.001754.98
Madan, Frederick,165503001.040.000.002181.56819.48

Generated 2024-11-10 11:20:53.551 UTC