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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Rubio, Lance, E,194773533.770.000.003533.770.00
Martin, Jerome, D,201703177.440.00699.100.002478.34
Gonzalez, Preston, L,14156229.570.000.000.00229.57
Lu, Colin, H,2106969.970.000.000.0069.97
Russell, Natalie, M,2090078.960.000.000.0078.96
Travers, Micheal,2639739.980.000.000.0039.98
Sun, Alisha,1804864.970.000.000.0064.97
Madan, Frederick,165503001.040.000.002181.56819.48
Jackson, Lucas, A,254812478.340.000.000.002478.34
Gray, Allison, D,2057124.990.000.000.0024.99
Sanchez, Brian, F,209313273.170.000.00782.992490.18
Zhu, Autumn,14840157.960.000.000.00157.96
Rana, Brett, L,2094337.270.000.000.0037.27
Alvarez, Deanna, K,2472015.230.000.000.0015.23
Yang, Luke,2852660.470.000.000.0060.47
Cai, Stacey,205753095.040.00699.100.002395.94
Raman, Meredith,113818161.020.003399.992341.972419.06
Gutierrez, Kellie, K,179663262.830.000.002443.35819.48
Rivera, Katelyn,2394868.490.000.000.0068.49
Williams, Jennifer, E,1945792.480.000.000.0092.48
Smith, Terrance, I,194243511.760.000.003511.760.00
Hu, Tiffany, A,208562483.980.000.00782.991700.99
Martinez, Francisco,1137513.980.000.000.0013.98
Zhao, Kelli,263861775.470.000.000.001775.47
Madan, Douglas,269716.280.000.000.006.28
Chapman, Pedro,1778567.260.000.000.0067.26
Luo, Chad, R,210402566.950.000.002566.950.00
She, Warren,2182427.280.000.000.0027.28
Deng, Shawn, C,16590168.950.000.000.00168.95
Black, Willie,1817239.980.000.000.0039.98
Walker, Sydney, A,1904771.950.000.000.0071.95
Ashe, Bethany,1935023.780.000.000.0023.78
Henderson, Faith,1454578.980.000.000.0078.98
Rai, Sheena,2939323.780.000.0023.780.00
Xu, Katie, R,14799162.950.000.000.00162.95
Ye, Stacey,1256867.460.000.000.0067.46
Gonzalez, Stefanie, J,287092419.060.000.000.002419.06
Gao, Claudia,136907162.080.003578.270.003583.81
Lopez, Andre,1143470.460.000.000.0070.46
Torres, Rodney, L,225201775.470.000.000.001775.47
Nara, Terry,273051714.970.000.000.001714.97
Wu, Trisha,264041775.470.000.000.001775.47
Anderson, Benjamin,2080932.280.000.000.0032.28
Kapoor, Pamela,208253226.340.000.00782.992443.35
Yuan, Arturo,2096834.980.000.000.0034.98
Chandra, Bruce, H,14970158.960.000.000.00158.96
Townsend, Michelle, P,1286486.240.000.000.0086.24
Anand, Tonya, A,27141574.980.000.000.00574.98
Chandra, Sergio, A,2283769.970.000.000.0069.97
Ruiz, Theodore,200523214.030.00699.100.002514.93
Patel, Bruce,271653.990.000.000.003.99
Pal, Rafael, J,177152831.530.000.002831.530.00
Lin, Brent, L,277886.280.000.000.006.28
Tang, Kenneth,28477548.980.000.000.00548.98
Navarro, Robin, J,286962428.050.000.000.002428.05
Ortega, Larry, C,181266945.580.000.002181.564764.02
Zhou, Martha, M,14804138.960.000.000.00138.96
Carlson, Lee, S,2107937.270.000.000.0037.27
Pal, Mohamed,2055024.990.000.000.0024.99
Ye, Ernest, A,225584.990.000.000.004.99
Liang, Clayton, E,1495829.480.000.000.0029.48
Pal, Cedric,2323539.980.000.0039.980.00
Gonzalez, Troy, A,28517578.460.000.000.00578.46
Martin, Albert,26837548.980.000.000.00548.98
Dominguez, Ruben,165733001.040.000.002181.56819.48
Gutierrez, Jimmy, M,114946973.810.003399.992329.981243.84
He, Cedric, W,252984.990.000.000.004.99
Tang, Tonya,209173234.290.000.00782.992451.30
Rana, Geoffrey,2874527.770.000.000.0027.77
Li, Jorge, V,2013328.980.000.000.0028.98
Lopez, Martin, E,2186428.980.000.000.0028.98
Ramirez, Megan, C,113876958.800.003374.992354.981228.83
Jai, April,156605169.070.003578.270.001590.80
Andersen, Nichole,126536860.090.000.002049.104810.99
Deng, Sharon, A,2689359.980.000.000.0059.98
Martin, Alexander, K,164024.990.000.000.004.99
Lopez, Courtney,208392511.260.000.00782.991728.27
Andersen, Kelli,226021754.980.000.000.001754.98
Rai, Casey, M,193081549.420.000.001000.44548.98
Suri, Tammy,240311170.480.000.000.001170.48
Thompson, Benjamin,194353457.770.000.003457.770.00
Rubio, Jimmy,208372547.950.000.002547.950.00
Alvarez, Krista,194673485.380.000.001000.442484.94
Ramos, Julio,1255125.480.000.000.0025.48
King, Adam, M,1693214.560.000.000.0014.56
Rivera, Garrett,226421198.970.000.000.001198.97
Ma, Stacey,2184031.270.000.0031.270.00
Zhang, Jake,226161735.980.000.000.001735.98
Sanders, Richard, D,2151132.270.000.000.0032.27
Chander, Kelli,26934553.970.000.000.00553.97
Li, Laura, O,209332518.970.000.00782.991735.98
Lin, Candice, K,195063480.380.000.001000.442479.94
Alonso, Kendra, C,164272975.020.000.002975.020.00
Sanz, Jay,28503578.460.000.000.00578.46
Gutierrez, Wendy,12610101.950.000.000.00101.95
Sanchez, Gerald,2414439.980.000.000.0039.98
Ramos, Orlando,2415429.480.000.000.0029.48
Diaz, Krista,2891323.780.000.000.0023.78
Gray, Natalie, L,141655910.550.003578.270.002332.28
Shan, Willie,170982768.530.000.002768.530.00
Vazquez, Lance,1137678.480.000.000.0078.48
Rana, Kristopher, W,2255029.480.000.000.0029.48
Xu, Brendan, L,149376652.890.003578.270.003074.62
Howard, Grace, J,208643234.290.000.00782.992451.30
Sanz, Ebony, I,207113240.320.000.00782.992457.33
Rubio, Clinton, A,25612574.980.000.00574.980.00
Alvarez, Julio,262052451.300.000.000.002451.30
Jai, Lindsey, W,2397198.960.000.000.0098.96
Stone, Stephanie, S,1906029.930.000.000.0029.93
Raman, Bryant, S,190484765.630.000.002443.352322.28
Bhat, Drew,1482037.270.000.000.0037.27
Zhang, Candice, J,237771179.470.000.000.001179.47
Chen, Tamara,123825606.260.000.002071.423534.84
Gutierrez, Walter,251414.990.000.000.004.99
Jenkins, Blake,2890723.780.000.000.0023.78
Raji, Barbara,240191120.490.000.000.001120.49
Navarro, Joy,164103242.770.000.002443.35799.42
Watson, Ian, G,263981758.950.000.000.001758.95
Moreno, Reginald, H,1605076.940.000.000.0076.94
Prasad, Regina, A,241921155.480.000.000.001155.48
Hayes, Marcus, A,156575251.340.003578.270.001673.07
Lal, Cassie,1262677.960.000.000.0077.96
Zeng, Martha, J,17844196.260.000.000.00196.26
Xie, Tara,199123427.390.000.001000.442426.95
Sun, Heather,287292452.040.000.000.002452.04
Sun, Vincent, F,165857192.390.000.002443.354749.04
Huang, Alvin,1249186.580.000.000.0086.58
Andersen, Bethany,2532439.980.000.000.0039.98
Lal, Lindsay, H,2055764.970.000.000.0064.97
Martin, Ross,162013058.010.002181.560.00876.45
Scott, Mackenzie, L,2567666.970.000.000.0066.97
Russell, Christian, S,2282634.980.000.000.0034.98
Carlson, Kristine, C,2875323.780.000.000.0023.78
Martinez, Richard, J,1498668.970.000.000.0068.97
Morgan, Makayla, C,271566.280.000.000.006.28
Martinez, Tabitha,26865123.990.000.000.00123.99
Schmidt, Gina,162603001.020.002181.560.00819.46
Sun, Claudia, J,145256665.580.003578.270.003087.31
Madan, Donald, R,2716867.490.000.000.0067.49
Rai, Donna,1223562.760.000.000.0062.76
Ortega, Robin,177983058.310.000.002443.35614.96
Harrison, Melody,2846860.470.000.000.0060.47
She, Ramon,180003080.290.000.002443.35636.94
Wu, Rosa,164613287.320.000.002443.35843.97
Diaz, Larry, T,13664210.250.000.000.00210.25
Sharma, Ricardo,165123262.830.000.002443.35819.48
Black, Roger, J,284162442.030.000.000.002442.03
Gill, Randall, A,1816582.260.000.000.0082.26
Sai, Tabitha,25741567.760.000.000.00567.76
Phillips, Gabriel, R,2944388.980.000.000.0088.98
Xu, Shawn,1932827.280.000.000.0027.28
Yang, Bianca, E,287322419.060.000.000.002419.06
Liu, Jorge, J,205923113.220.00782.990.002330.23
Nara, Jaime, D,1326286.950.000.000.0086.95
Reed, Jesse, E,224291777.950.000.000.001777.95
Nath, Nichole, K,1239275.470.000.0025.4849.99
Cox, Zoe, A,177552768.530.000.002181.56586.97
Schmidt, Michele, M,215451631.460.000.00782.99848.47
Ms., Sheperdigian, Janet,2454137.270.000.000.0037.27
Kelly, Olivia, L,123915121.430.000.002049.103072.33
Carlson, Desiree, V,1486469.970.000.000.0069.97
Chander, Casey, C,165542990.520.000.002181.56808.96
Carlson, Jerome, J,21817791.470.000.000.00791.47
Martin, Janet, L,2454069.970.000.000.0069.97
Rubio, Gary, M,201503264.020.00699.100.002564.92
Liu, Damien, M,172147211.390.000.002443.354768.04
Gutierrez, Marie, F,294311249.840.000.000.001249.84
Anderson, Samuel, D,14199118.940.000.000.00118.94
Washington, Julia, R,208752518.970.000.00782.991735.98
Rai, Kelvin, M,268336.280.000.000.006.28
Wang, Barbara, M,156525160.080.003578.270.001581.81
Ruiz, Juan,2874623.780.000.000.0023.78
Kumar, Carl,1274369.990.000.000.0069.99
Shan, Carly,1863124.990.000.000.0024.99
Garcia, Tammy, A,1229386.760.000.000.0086.76
Mr., Thompson, Austin,12513241.760.000.000.00241.76
Martin, Darren,226951174.480.000.000.001174.48
Powell, Gavin, M,28530588.960.000.000.00588.96
Xie, Colleen, C,121335830.680.000.002071.423759.26
Patel, Patricia,205693114.060.00699.100.002414.96
Gonzalez, Tammy, J,25657609.450.000.000.00609.45
Cox, Andrea,1383088.970.000.000.0088.97
Torres, Teresa, M,1618839.980.000.000.0039.98
Kapoor, Marco,1951286.260.000.000.0086.26
Wang, Aimee,210112527.960.000.00782.991744.97
Carlson, Tyrone, S,226624.990.000.000.004.99
Mr., Sneath, Timothy,1770829.480.000.000.0029.48
Zhang, Alvin,1908239.980.000.000.0039.98
Rubio, Rebekah,2469929.480.000.000.0029.48
Zheng, Leah, R,12627110.940.000.000.00110.94
Navarro, Lee,25659567.760.000.000.00567.76
Andersen, Dale, B,1499269.990.000.000.0069.99
Lal, Misty, L,2238558.980.000.000.0058.98
Hernandez, Larry,17840228.960.000.000.00228.96
Sai, Phillip, M,135635948.233578.270.000.002369.96
Martinez, Donald, D,25482162.990.000.000.00162.99
Martin, Dalton, J,1250536.590.000.000.0036.59
Carlson, Micheal, E,271643.990.000.000.003.99
Shan, Karla,194933515.370.000.003515.370.00
Cox, Isaiah, E,135848361.293578.270.000.004783.02
Sun, Stacey, S,193613478.780.000.003478.780.00
Howard, Angel, A,232231155.480.000.000.001155.48
Tang, Casey,150465943.250.003578.270.002364.98
Gonzales, Jessica, A,15610114.960.000.000.00114.96
Hayes, Emily,1918424.990.000.000.0024.99
Gao, Mandy, M,125605636.900.000.002049.103587.80
Dominguez, Jésus,1708775.210.000.000.0075.21
Munoz, Lori, M,226391155.480.000.000.001155.48
Lopez, Harold,26913607.960.000.000.00607.96
Raje, Jerry, E,21848564.990.000.000.00564.99
Raje, Tamara, J,1994686.950.000.000.0086.95
Jenkins, Kayla, A,147775923.230.003578.270.002344.96
Munoz, Danny,1935524.990.000.000.0024.99
Rodriguez, Janelle,268876.280.000.000.006.28
Ma, Alisha,179722791.530.000.002181.56609.97
Gonzalez, Bob, S,245692479.940.000.000.002479.94
Chander, Lindsey,26949565.470.000.000.00565.47
Fernandez, Harold, C,293592453.040.000.000.002453.04
Srini, Martin, L,1862924.990.000.000.0024.99
Ruiz, Stacy,168237242.350.000.002443.354799.00
Srini, Stanley,1804229.980.000.000.0029.98
Kumar, Maurice, L,226001735.980.000.000.001735.98
Romero, Tabitha, M,224161764.960.000.000.001764.96
Sanz, Erika, J,2267039.980.000.000.0039.98
Luo, Gregory,1764232.950.000.000.0032.95
Jimenez, Nelson,146976684.580.003578.270.003106.31
Romero, Robyn, C,27802561.480.000.000.00561.48
Sara, Erick, M,254481174.480.000.000.001174.48
Raje, Julie, H,122146803.920.000.002049.104754.82
Davis, Lucas, S,1937824.990.000.000.0024.99
Kelly, Alexa,1507574.980.000.000.0074.98
Diaz, Blake, E,181356921.580.000.002181.564740.02
Blanco, Rebekah,1814950.230.000.000.0050.23
White, Jonathan, A,247034.990.000.000.004.99
Suri, Cynthia,225894.990.000.000.004.99
James, Arianna, A,2579913.980.000.0013.980.00
Zhao, Arturo,1942531.270.000.000.0031.27
Johnsen, Rebekah, J,199194.990.000.000.004.99
Garcia, Kristina,254461151.760.000.000.001151.76
Munoz, Rodney,1283668.460.000.000.0068.46
Rai, Darrell, C,2690667.490.000.000.0067.49
Anand, Wayne, H,226861243.440.000.000.001243.44
Shan, Alicia,279646.280.000.000.006.28
Kelly, Marcus, A,2569947.970.000.000.0047.97
Rana, Martin,242131214.460.000.000.001214.46
Vazquez, Cheryl, A,179483045.300.000.002443.35601.95
Rodriguez, Gerald,122166955.410.000.002071.424883.99
Lopez, Cindy, L,27137617.470.000.000.00617.47
Henderson, Alexandria, R,1155534.990.000.000.0034.99
She, Cara, H,226461155.480.000.000.001155.48

Generated 2025-12-21 21:58:50.756 UTC