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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Zheng, Alisha,222034624.910.000.002181.562443.35
Cai, Karen,225722997.320.000.002443.35553.97
Shen, Kelvin,224063018.330.000.002443.35574.98
Ruiz, Krista, C,130816772.150.000.002049.104723.05
Lu, Valerie,229134684.390.000.002181.562502.83
Guo, Jon,229273913.820.000.002181.561732.26
Mr., Sands, Patrick,140635676.250.000.003321.262354.99
Carlson, Jonathon, N,1707378.970.000.000.0078.97
Zheng, Edwin, J,142165653.920.000.002049.103604.82
Srini, Douglas, M,1673335.260.000.000.0035.26
Griffin, Olivia,2120839.980.000.000.0039.98
Nelson, Mary, L,131075650.900.000.002049.103601.80
Mehta, Levi, M,131105583.940.000.002049.103534.84
Vazquez, Casey, S,131326880.620.000.002049.104831.52
Becker, Gregory, M,131046894.440.000.002071.424823.02
Gao, Bianca, C,131125717.890.000.002049.103668.79
Shen, Kelsey, R,229214647.880.000.002181.562466.32
Wilson, Edward, L,265621925.410.000.00782.991142.42
Shen, Tamara, G,229353951.520.000.002181.561769.96
Kapoor, Bryant,229463911.530.000.003911.530.00
Nelson, Carol,135204551.360.000.004551.360.00
Kumar, Tonya, A,229344173.320.000.002443.351729.97
Ramos, Joy,131296823.150.000.002049.104774.05
Romero, Deanna, K,2357021.980.000.000.0021.98
Martinez, Emma,16734128.970.000.000.00128.97
Carlson, Francis,273401350.750.000.00782.99567.76
Pal, Donna, S,235723617.830.000.002443.351174.48
Yuan, Keith, N,229263936.540.000.002181.561754.98
Lu, Sandra, N,135214514.770.000.004514.770.00
Tang, Latoya, F,229103882.550.000.002181.561700.99
Prasad, Cesar,234113577.820.000.003577.820.00
Xu, Sharon, A,233443882.550.000.002181.561700.99
Lin, Damien, L,234143391.030.000.003391.030.00
Wu, Brittney,234183400.020.000.003400.020.00
Lewis, Jasmine,139646806.450.000.002071.424735.03
Pal, Derek,2459158.980.000.000.0058.98
Chen, Randy,13004190.270.000.000.00190.27
Raje, Grant, S,241623004.830.000.002443.35561.48
Perez, Allen, B,1422974.980.000.000.0074.98
Hayes, Alexis,13048190.230.000.000.00190.23
Patel, Marco, L,1957560.050.000.0023.7836.27
Gutierrez, Kari,157564441.390.000.002071.422369.97
Vazquez, Ross,11148126.240.000.0053.9972.25
Sharma, Julie, R,1819194.470.000.008.9985.48
Anderson, Richard, G,249242143.900.000.001000.441143.46
He, Curtis, D,249212180.410.000.001000.441179.97
Raman, Jay, M,136186763.150.000.002049.104714.05
She, Jessie, A,136506768.140.000.002049.104719.04
Chapman, Preston, O,182686102.190.003578.270.002523.92
Chander, Alison,182496044.590.003578.272466.320.00
Sharma, Jodi, N,182606035.600.003578.272457.330.00
Sanz, Ricky,182516035.600.003578.272457.330.00
Sanchez, Carla,1827430.970.000.000.0030.97
Pal, Christine, I,182426121.710.003578.272543.440.00
Sun, Brittney,113655024.790.003374.990.001649.80
Xu, Clayton,184886056.610.003578.272478.340.00
Collins, Jennifer,113644921.820.003374.990.001546.83
Xu, Julie,183016056.610.003578.272478.340.00
Ross, Julian,113635035.810.003399.990.001635.82
Huang, Vincent, A,187035314.250.003578.270.001735.98
Black, Mindy, W,186966149.570.003578.272571.300.00
Deng, Carl,182846029.570.003578.272451.300.00
Ashe, Barbara,1873424.270.000.000.0024.27
Gonzalez, Carla, J,183366145.070.003578.270.002566.80
Dominguez, Leslie,273461390.950.000.00782.99607.96
McDonald, Kaitlin,184936029.570.003578.272451.300.00
Goel, Karla, L,11146112.930.000.0053.9558.98
Raje, Louis, M,257071262.060.00699.100.00562.96
Xu, Calvin, E,27583553.970.000.000.00553.97
She, Gregory,184584733.750.003578.270.001155.48
Alvarez, Marc, B,1822145.950.000.000.0045.95
Prasad, Levi,257051274.080.00699.100.00574.98
Munoz, Jimmy, E,2157361.970.000.000.0061.97
Alvarez, Reginald, A,187466135.090.003578.272556.820.00
Alvarez, Marvin,236513917.540.000.002181.561735.98
Diaz, Jacquelyn, K,187476089.590.003578.272511.320.00
Lal, Nina, L,142635647.930.000.002049.103598.83
Zhao, Micah,187086056.510.003578.272478.240.00
Jimenez, Julio,240052756.540.000.002181.56574.98
Anand, Katrina, L,187265314.250.003578.271735.980.00
Ramirez, Mason, K,251072143.900.000.001000.441143.46
Nath, Dawn, L,117598054.050.003374.990.004679.06
Andersen, Colin,250532183.910.000.001000.441183.47
Arthur, Regina, A,190896093.200.003578.270.002514.93
Weber, Deanna, L,148553759.080.000.002049.101709.98
Alonso, Gary, C,187675314.250.003578.270.001735.98
Subram, Meredith, S,142615653.920.000.002049.103604.82
Luo, Louis,114658158.040.003399.990.004758.05
Munoz, Monique,240082730.540.000.002181.56548.98
She, Latoya, A,117508148.020.003399.990.004748.03
Henderson, Isabella, L,2198175.970.000.000.0075.97
Gomez, Andy,187215333.250.003578.270.001754.98
Stone, Mitchell,2501369.970.000.000.0069.97
Zheng, Darryl,187066060.500.003578.270.002482.23
Wood, Jacqueline,1670597.960.000.000.0097.96
Luo, Tamara,187386089.590.003578.270.002511.32
Guo, Autumn, A,1421386.260.000.000.0086.26
She, Rosa,189316060.500.003578.270.002482.23
Zhu, Roger, J,280981249.840.000.000.001249.84
Garcia, Donald,189296029.570.003578.270.002451.30
Blanco, Jimmy, V,14013138.450.000.000.00138.45
Pal, Christy, R,187395371.740.003578.271793.470.00
Allen, Devin,15806102.850.000.0038.8863.97
Huang, Alejandro,114648128.510.003374.992334.462419.06
Perez, Stefanie,27518123.980.000.000.00123.98
Sun, Krystal,189086090.590.003578.272512.320.00
Washington, Abigail,236613961.030.000.002181.561779.47
Prasad, Carmen, L,189286095.080.003578.270.002516.81
Harris, Thomas,240022744.520.000.002181.56562.96
Saunders, Patricia, J,195655308.240.003578.270.001729.97
Gill, Gina, F,241772721.550.000.002181.56539.99
Fernandez, Allen,195966056.610.003578.270.002478.34
Miller, Zachary, M,151692919.890.000.002071.42848.47
Raman, Raymond, R,195886056.610.003578.270.002478.34
Liu, Randy,150153804.080.000.002049.101754.98
Andersen, Shawna, C,195566035.600.003578.270.002457.33
Sara, Donald, M,251142155.920.000.001000.441155.48
Madan, Stanley,196026093.200.003578.270.002514.93
Zhu, Lacey,241672983.340.000.002443.35539.99
Rana, Carla, K,195935306.540.003578.270.001728.27
Luo, Colleen, E,152082951.560.000.002049.10902.46
Rana, Stefanie, K,196165279.260.003578.270.001700.99
Hernandez, Jaime,241703018.330.000.002443.35574.98
Navarro, Kellie, I,218734661.500.000.002181.562479.94
Raji, Warren, J,267961957.470.000.00782.991174.48
Gill, Theodore,1114941.260.000.000.0041.26
Alonso, Renee,241662789.520.000.002181.56607.96
Hernandez, Audrey,1829084.960.000.008.9975.97
Hernandez, Jessie, A,241722735.530.000.002181.56553.97
Sharma, Kelli,26672123.980.000.000.00123.98
She, Derek,150363785.080.000.002049.101735.98
Sun, Jaclyn,1821165.960.000.0056.978.99
Chander, Kelvin, E,278791313.340.000.000.001313.34
Ortega, Julio, M,118928119.030.003399.990.004719.04
Prasad, Ebony,243683946.520.000.002181.561764.96
Carlson, Jay,202645333.250.003578.270.001754.98
Vazquez, Rebekah, A,157844379.090.000.002049.102329.99
Carlson, Frank,118968117.970.003374.990.004742.98
Andersen, Jodi,2676678.980.000.000.0078.98
Lin, Edwin,197664167.230.003578.27588.960.00
Ruiz, Francis, D,2138169.990.000.000.0069.99
Nara, Karla, C,258271873.580.00699.100.001174.48
Anderson, Victoria,157994423.380.000.002071.422351.96
Mehta, Arthur, A,199576035.600.003578.270.002457.33
Carlson, Tanya,1618331.270.000.000.0031.27
Lu, Ronnie,199506098.540.003578.270.002520.27
Powell, Trevor, C,269221322.980.000.00782.99539.99
Romero, Erika,199586056.510.003578.270.002478.24
Raman, Ruben,155802910.900.000.002071.42839.48
Madan, Meagan,117678319.510.003399.992475.972443.55
Gonzalez, Edgar, A,156483807.400.000.002071.421735.98
Liang, Rosa, L,197704127.250.003578.27548.980.00
Srini, Carolyn, S,273711350.750.000.00782.99567.76
Raji, Kate, L,119038108.040.003374.992294.992438.06
Suarez, Nelson,273551383.450.000.00782.99600.46
She, Susan,199566060.500.003578.270.002482.23
Prasad, Henry, M,243643965.520.000.002181.561783.96
Ramirez, Olivia, D,197856076.610.003578.270.002498.34
Bell, Stephanie, A,273701322.980.000.00782.99539.99
Garcia, George,201604237.220.003578.27658.950.00
Sai, Evelyn,2041513.980.000.000.0013.98
Dominguez, Gina, L,202136029.570.003578.270.002451.30
Garcia, Virginia, C,2459926.970.000.000.0026.97
Navarro, Byron,1662236.590.000.000.0036.59
Vance, Kristopher, C,204074.990.000.000.004.99
Wood, Sydney,233103333.320.000.003333.320.00
Guo, Trisha,1825345.950.000.000.0045.95
White, Taylor, D,250111589.400.000.001000.44588.96
Subram, Candace,27585562.960.000.000.00562.96
Hall, Amanda,266561345.950.000.001345.950.00
Srini, Beth, A,259136.280.000.000.006.28
Moyer, Mario,234204144.340.000.002443.351700.99
Tang, Sharon, M,1582367.960.000.000.0067.96
Anand, Tamara,29088756.330.000.000.00756.33
Luo, Bethany,1958236.270.000.000.0036.27
Blanco, Ricky, F,1660667.170.000.000.0067.17
Sai, Tina, L,154253772.410.000.002071.421700.99
Yuan, Maurice,243804.990.000.000.004.99
Fernandez, Donald, C,244623617.830.000.002443.351174.48
Vazquez, Marc, H,243623600.770.000.002443.351157.42
Suri, Marie,242813302.050.000.002181.561120.49
Gutierrez, Jay, C,13155226.950.000.0084.47142.48
Jiménez, Brandi,243784173.320.000.002443.351729.97
Pal, Alvin, C,293192447.050.000.000.002447.05
Andersen, Tara, L,244653356.040.000.002181.561174.48
Tang, Julie,265891966.460.000.00782.991183.47
Perez, Edgar, B,293182384.070.000.000.002384.07
Sharma, Arturo,136486765.440.000.002049.104716.34
Rubio, Bruce, E,233433936.540.000.002181.561754.98
Martinez, Brett,235323337.040.000.003337.040.00
Kumar, Alejandro,140555177.400.000.002049.103128.30
Munoz, Tanya,234363950.520.000.002181.561768.96
Garcia, Rebekah, M,140073772.410.000.003772.410.00
Moore, Thomas,140103861.390.000.003861.390.00
Zhang, Lacey, L,141273809.570.000.003809.570.00
Harris, Ian, W,141283836.380.000.003836.380.00
Chande, Derek,267431371.950.000.001371.950.00
Wang, Nathan,140396808.130.000.002049.104759.03
Liu, Steve, V,235233337.040.000.003337.040.00
Torres, Melinda, J,140336809.960.000.002071.424738.54
Clark, Madison, A,140625647.920.000.003272.942374.98
Romero, Jessie,250302180.410.000.001000.441179.97
Jimenez, Melody, S,140663612.190.000.002853.57758.62
Gao, Jorge,235733337.040.000.002181.561155.48
Beck, Ashlee, L,266661336.960.000.001336.960.00
Lopez, Donald, A,267401938.470.000.00782.991155.48
Vazquez, Eddie, T,140125249.920.000.002049.103200.82
Ye, Jenny,250362120.930.000.001000.441120.49
Anand, Alison, J,240092746.040.000.002181.56564.48
Hernandez, Kristine,142865234.400.000.002049.103185.30
Foster, Luke,15137161.940.000.0097.9763.97
Shen, Cedric,2220974.980.000.000.0074.98
Serrano, Hector, K,28308588.960.000.000.00588.96
Dominguez, Robyn, P,233057.280.000.000.007.28
Sun, Lacey, L,1513181.260.000.000.0081.26
Raman, Arthur,240012983.340.000.002443.35539.99
Chen, Alisha, J,142255603.920.000.002049.103554.82
Mehta, Heidi,142265656.240.000.002071.423584.82
Chandra, Jermaine, A,142995108.760.000.002071.423037.34
Shen, Cristina,267681371.950.000.00782.99588.96
Carson, Bradley,239952983.340.000.002443.35539.99
Rai, Willie,146735117.750.000.002071.423046.33
Rai, Terrence, R,250372174.920.000.001000.441174.48
Dominguez, Neil, K,236633882.550.000.002181.561700.99
Fernandez, Lydia, M,145233807.400.000.002071.421735.98
Zimmerman, Candice, J,267541938.470.000.00782.991155.48
Shan, Elijah, L,267951992.460.000.00782.991209.47
Hu, Marshall, H,267971957.470.000.00782.991174.48
Gutierrez, Joy, A,1846653.990.000.000.0053.99
Gutierrez, Pedro, S,1522471.920.000.000.0071.92
Russell, Cassidy, N,2614427.770.000.000.0027.77
Gill, Sheila, B,1737524.490.000.000.0024.49
Prasad, Arthur,142755158.370.000.002800.442357.93
She, Jerry, C,142775196.740.000.002071.423125.32
Shan, Drew,236594179.330.000.002443.351735.98
Wang, Kelvin, S,151434366.410.000.002071.422294.99
Lopez, Virginia, J,273381339.920.000.00782.99556.93
Gutierrez, Latasha, C,150222999.910.000.002071.42928.49
Serrano, Deanna, W,151444344.090.000.002049.102294.99
Zhu, Suzanne, E,251122155.920.000.001000.441155.48
Luo, Kenneth, S,152112910.900.000.002071.42839.48
Gomez, Adrienne,119208156.320.003374.990.004781.33
Gonzalez, Deanna, S,152044444.070.000.002049.102394.97
Raji, Dawn, C,202446021.620.003578.270.002443.35
Huang, Rosa, P,151814448.380.000.002071.422376.96
Rai, Sharon,202256056.610.003578.270.002478.34
Wang, Martha, D,242722735.530.000.002181.56553.97
Jimenez, Tanya, D,199706099.100.003578.270.002520.83
Mehta, Jay, S,150353772.410.000.002071.421700.99
Rodriguez, Rachael, M,119444776.270.003374.99609.96791.32

Generated 2024-11-10 06:34:28.117 UTC