[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
Jai, Calvin, S,229184.990.000.000.004.99
Navarro, Melinda,114548089.040.003374.992294.992419.06
Gutierrez, Jaime, A,2522739.980.000.000.0039.98
Powell, Aaron,252414.990.000.000.004.99
Gao, Lisa, A,197534.990.000.000.004.99
Yuan, Warren, P,190912.290.000.000.002.29
Suri, Molly,1750398.960.000.000.0098.96
Jai, Alvin,195995279.260.003578.270.001700.99
Ferrier, Mathew,2342639.980.000.000.0039.98
Fernandez, George,199746021.620.003578.270.002443.35
Ma, Louis,2187935.000.000.000.0035.00
Rubio, Kristy,122433914.980.003374.990.00539.99
Prasad, Brandy, P,1400963.970.000.000.0063.97
Black, Priscilla,1576662.270.000.0034.9927.28
Gao, Eugene,29464756.330.000.000.00756.33
Cooper, Katherine, R,14314122.950.000.000.00122.95
Subram, Ross, L,230857.280.000.000.007.28
Hill, Jennifer,1829130.970.000.000.0030.97
Guo, Randy, L,2295664.470.000.000.0064.47
Blanco, Lori, A,15735116.250.000.000.00116.25
Rana, Evelyn, D,18262142.450.000.000.00142.45
Martin, Deanna,130916864.950.000.002071.424793.53
Lopez, Cesar,17500156.960.000.000.00156.96
Anderson, Blake,110768159.043399.990.002374.982384.07
Torres, Diane, M,2521179.470.000.000.0079.47
Chen, Randy,13004190.270.000.000.00190.27
Vazquez, Kristi,2834939.980.000.000.0039.98
Perez, Ivan, S,234084218.820.000.002443.351775.47
Sullivan, Dominic, M,2284037.290.000.000.0037.29
Zhang, Louis, K,202276054.220.003578.270.002475.95
Peterson, Allison, A,2642160.470.000.000.0060.47
Vazquez, Eddie, T,140125249.920.000.002049.103200.82
Moreno, Diana, J,29298548.980.000.000.00548.98
Hernandez, Jésus, M,2426722.930.000.000.0022.93
Sanchez, Carla,1827430.970.000.000.0030.97
Patel, Virginia, R,1136677.270.000.000.0077.27
Sharma, Kelli,26672123.980.000.000.00123.98
Arthur, Cassandra, M,224102983.340.002443.350.00539.99
Lopez, Chelsea,243694.990.000.000.004.99
Kapoor, Ruben, D,111098245.013374.990.002476.962393.06
Shen, Willie, S,1845025.480.000.000.0025.48
Ye, Christy,142195744.220.000.002071.423672.80
Vance, Marco,1312487.930.000.000.0087.93
Lin, Clarence,29069756.330.000.000.00756.33
Sanz, Theodore, M,1649238.980.000.000.0038.98
Hu, Alvin, E,114498130.320.003374.992362.272393.06
Liang, Brittney, R,261826.280.000.000.006.28
Lee, Austin,2615169.990.000.000.0069.99
Oliver, Lee,2911969.970.000.000.0069.97
Deng, Devon, H,199676029.570.003578.270.002451.30
Xu, Dennis,2199739.990.000.000.0039.99
Kumar, Chad,110958158.013374.990.002363.962419.06
Zhu, Jessie, D,1266634.560.000.000.0034.56
Chandra, Jermaine, A,142995108.760.000.002071.423037.34
Moore, Sarah,289389.990.000.000.009.99
Xu, Martha, C,163515873.263578.270.000.002294.99
Nara, Melvin, E,27147123.980.000.000.00123.98
Beck, Alejandro,110256576.803374.990.002405.47796.34
Luo, Nichole, A,2929649.970.000.000.0049.97
Arthur, Tabitha, E,164824783.743578.270.001205.470.00
Yuan, Calvin,1790525.480.000.000.0025.48
Gao, Tiffany, E,163525948.493578.270.000.002370.22
Zhu, Roger, J,280981249.840.000.000.001249.84
Rai, Clarence, D,110186533.283399.990.002341.97791.32
Srini, Candace,154372.290.000.000.002.29
Thompson, Fernando,163505903.193578.270.000.002324.92
Rivera, Jada,2197032.280.000.000.0032.28
Raman, Shane,166615908.253578.270.000.002329.98
Gill, Ricky, A,1560728.980.000.000.0028.98
Ramos, Theresa, G,110316478.603399.990.000.003078.61
She, Jenny,275861120.490.000.000.001120.49
Alonso, Kristine,166864157.733578.270.000.00579.46
Carlson, Billy, C,19667150.950.000.000.00150.95
Raje, Ashlee, E,166585873.263578.270.000.002294.99
Malhotra, Meredith,29314564.480.000.000.00564.48
Yuan, Christine,110466616.813374.990.000.003241.82
Madan, Denise, R,2524839.980.000.000.0039.98
Martin, Marc, J,110396636.583399.990.000.003236.59
Raji, Dale,1926542.280.000.000.0042.28
Shan, Mario,252711854.58699.100.000.001155.48
Jai, Gregory,1634246.470.000.000.0046.47
Ye, Dennis, M,166385974.233578.270.000.002395.96
Nara, Lindsay, M,252474.990.000.000.004.99
Raman, Patricia, T,167026021.623578.270.002443.350.00
Martin, Reginald,14054210.770.000.000.00210.77
Nara, Tony, L,167136090.593578.270.002512.320.00
Rodriguez, Toni, J,2525139.980.000.000.0039.98
Gomez, Tabitha, L,166886081.103578.270.002502.830.00
Liang, Randy, E,2895814.980.000.000.0014.98
Zhang, Ronnie,166565930.233578.270.000.002351.96
Navarro, Lori,2118232.280.000.000.0032.28
Cox, Michelle, E,173284387.743578.270.000.00809.47
Vance, Henry,27986553.970.000.000.00553.97
Zhu, Alan,173204391.743578.270.000.00813.47
Liu, Brittney, M,1580498.960.000.000.0098.96
Kumar, Deborah, K,173086021.623578.270.000.002443.35
Lu, Alan,1976167.930.000.000.0067.93
Wu, Micah,172464380.043578.270.000.00801.77
Martin, Pedro, B,281031214.850.000.000.001214.85
Ferrier, Jaclyn, D,172994382.753578.270.000.00804.48
Deng, Kenneth,2023534.980.000.000.0034.98
Kovar, Mayra, J,173124471.743578.270.000.00893.47
Rai, Shaun,2643123.780.000.000.0023.78
Nath, Carly, J,172554442.243578.270.000.00863.97
Gill, Lee, L,276941184.460.000.000.001184.46
Jimenez, Walter,172324347.763578.270.000.00769.49
Alvarez, Arthur,248927.280.000.000.007.28
Navarro, Tyrone, K,255571262.87699.100.000.00563.77
Hu, Edwin,242404.990.000.000.004.99
Allen, Alexandra, B,172934417.753578.270.000.00839.48
Sullivan, Ruth,277231155.480.000.000.001155.48
Perry, Maria, N,177284730.033578.270.000.001151.76
Arthur, Joel,277011155.480.000.000.001155.48
Li, Karen, K,179214698.763578.270.000.001120.49
Alonso, Joanna, M,27862548.980.000.000.00548.98
Ross, Adam,110998215.993399.990.002363.962452.04
Washington, Sydney,289244.990.000.000.004.99
Rodriguez, Allen, L,177324752.753578.270.000.001174.48
Madan, Brandy, A,276871183.470.000.000.001183.47
Sharma, Bonnie, R,255621239.09699.100.000.00539.99
Jiménez, Briana, T,28118588.960.000.000.00588.96
Vazquez, Kristine, M,177364742.743578.270.000.001164.47
Lopez, Dominic, B,275901189.460.000.000.001189.46
Lal, Shawna,179244733.753578.270.000.001155.48
Cook, Faith,278712384.070.000.000.002384.07
Tang, Bridget,177304752.233578.270.000.001173.96
Carlson, Joanna,1559434.990.000.000.0034.99
Nara, Dustin, M,179104698.763578.270.000.001120.49
Alvarez, Beth, M,2930514.980.000.000.0014.98
Vazquez, Daisy, L,255601288.06699.100.000.00588.96
Sun, Leah,177344698.763578.270.000.001120.49
Zeng, Micah, A,255611288.06699.100.000.00588.96
Huang, Brent,182206021.623578.270.002443.350.00
Lin, Autumn, E,182726056.613578.270.002478.340.00
Rana, Ivan, K,181964133.243578.270.000.00554.97
Powell, Thomas, R,182186021.623578.270.002443.350.00
Griffin, Rachel,182556067.200.003578.270.002488.93
Navarro, Kristine, B,255661253.070.00699.100.00553.97
Chander, Alison,182496044.590.003578.272466.320.00
Perez, Kevin, M,255651239.090.00699.100.00539.99
Sharma, Jodi, N,182606035.600.003578.272457.330.00
Smith, Arthur,182406098.580.003578.272520.310.00
Zhu, Alisha, G,182396030.610.003578.272452.340.00
Sun, Alvin,182526021.620.003578.272443.350.00
Gill, Erika, A,182024143.260.003578.270.00564.99
Sun, Brittney,113655024.790.003374.990.001649.80
Li, Jaclyn,182816081.100.003578.270.002502.83
Xu, Clayton,184886056.610.003578.272478.340.00
Andersen, Nina,183386124.580.003578.270.002546.31
Yang, Jamie, S,184654752.750.003578.270.001174.48
Romero, Wendy, H,113724965.810.003374.990.001590.82
Zhao, Ernest, C,187005328.230.003578.271749.960.00
Taylor, Jennifer,184706021.620.003578.272443.350.00
Li, Trisha, A,182966117.690.003578.272539.420.00
Serrano, Shannon, R,183036030.610.003578.272452.340.00
Lal, Tara, S,186975279.260.003578.271700.990.00
Mehta, Preston, G,186926035.600.003578.272457.330.00
Chande, Jaclyn, S,186985314.250.003578.271735.980.00
Miller, Edward,113685106.240.003374.990.001731.25
Gill, Byron, J,184836056.610.003578.272478.340.00
Serrano, Tyrone,113605025.800.003399.990.001625.81
Malhotra, Emmanuel,183324752.750.003578.270.001174.48
Murphy, Seth, A,257041239.090.00699.100.00539.99
Gutierrez, Adrienne,189064217.220.003578.27638.950.00
Gutierrez, Darren, A,257141308.060.00699.100.00608.96
Ortega, Janet, L,117548163.530.003399.992319.992443.55
Luo, Mario, L,257111274.080.00699.100.00574.98
Nara, Priscilla,189074167.230.003578.27588.960.00
Navarro, Kathleen, J,192694118.260.003578.27539.990.00
Shen, Shawn,192704127.250.003578.27548.980.00
Nara, Clayton,117688139.040.003399.992319.992419.06
Perez, Brenda,118998189.500.003374.992395.452419.06
Torres, Marc,117658143.030.003374.992294.992473.05
Romero, Erika,199586056.510.003578.270.002478.24
Xu, Mindy,202466035.600.003578.270.002457.33
Guo, Jamie,201514152.730.003578.27574.460.00
Ramos, Dana, D,259191248.080.00699.100.00548.98
Zhang, Brittney, W,199756056.610.003578.270.002478.34
Zhu, Ernest,201594167.230.003578.27588.960.00
Gonzalez, Virginia,119294965.780.003374.990.001590.79
Huang, Dawn, E,119434734.290.003374.99539.99819.31
Goel, Dale, M,204164118.260.003578.27539.990.00
Gutierrez, Larry,259261308.060.00699.100.00608.96
Kapoor, Kristina,119977029.780.003399.991249.842379.95
Shen, Katie, A,202835314.250.003578.270.001735.98
Tang, April, A,259351256.030.00699.100.00556.93
Gao, Curtis, D,204295377.750.003578.270.001799.48
Shan, Gregory,206146035.600.003578.270.002457.33
Anand, Kelli, A,204516054.220.003578.270.002475.95
Tang, Edwin,204506021.620.003578.270.002443.35
Ward, Katelyn,202586029.570.003578.270.002451.30
Bryant, Fernando, M,206096117.690.003578.270.002539.42
Gutierrez, Marvin,259381308.060.00699.100.00608.96
Raman, Summer, C,259491882.570.00699.100.001183.47
Collins, Andrea,122503964.980.003399.990.00564.99
Sara, Jarrod,206266038.560.003578.270.002460.29
Prasad, Preston, C,208124127.250.003578.27548.980.00
Gutierrez, Rodney, J,206286056.610.003578.270.002478.34
Shan, Deborah,206246021.620.003578.270.002443.35
Arun, Gerald,259401277.560.00699.100.00578.46
Ruiz, Shannon,208224134.530.003578.27556.260.00
Johnson, Chloe, L,206176058.210.003578.270.002479.94
Liu, Omar, L,122523938.950.003374.990.00563.96
Ms., Simon, Britta,259461873.580.00699.100.001174.48
Yuan, Chad, C,211734659.900.002181.560.002478.34
Moreno, Roberto, R,212063882.550.002181.560.001700.99
Kumar, Alison,212003932.540.002181.560.001750.98
Allen, Luis, C,260191957.470.00782.990.001174.48
Yang, Tiffany, K,212154624.910.002181.560.002443.35
Xu, Rafael, N,211954144.340.002443.350.001700.99
Shen, Jaclyn, A,125752668.080.002049.100.00618.98
Flores, Katherine,211803882.550.002181.560.001700.99
Rubio, Desiree, D,211894208.310.002443.350.001764.96
Gao, Jamie,260221938.470.00782.990.001155.48
Navarro, Albert, L,215614947.780.002443.350.002504.43
Arun, Candace, J,213934925.170.002443.350.002481.82
Hernandez, Kellie, A,125862636.410.002071.420.00564.99
Serrano, Alfredo,212583936.540.002181.560.001754.98
Vazquez, Danny, J,260331903.480.00782.990.001120.49
Suarez, Lawrence, C,261311952.450.00782.990.001169.46
Hall, Jesse,261331938.470.00782.990.001155.48
Henderson, Cassidy,212283936.540.002181.560.001754.98
Rodriguez, Wyatt, D,212184661.500.002181.560.002479.94
She, Cedric, R,125802589.090.002049.100.00539.99
Torres, Meghan, I,212563917.540.002181.560.001735.98
Malhotra, Pedro,215594900.680.002443.350.002457.33
Zhu, Candice, S,212194696.490.002181.560.002514.93
Sanz, Julio, H,214044684.390.002181.560.002502.83
Goel, Christine, A,212313936.540.002181.560.001754.98
Lal, Kate,215574886.700.002443.350.002443.35
Suri, Allen,215534666.500.002181.560.002484.94
Garcia, Brandy,260281938.470.00782.990.001155.48
Gill, Jaime, M,261521938.470.00782.990.001155.48
Edwards, Evan, L,218884925.580.002443.350.002482.23
Hernandez, Orlando, C,219514923.290.002443.350.002479.94
Deng, Michele,219464659.800.002181.560.002478.24
Hernandez, Armando,219504900.680.002443.350.002457.33
Jiménez, Daisy,219444713.890.002181.560.002532.33
Kovár, Barry, A,215704705.480.002181.560.002523.92
Dominguez, Jimmy,219594702.390.002181.560.002520.83
Madan, Cory,261541938.470.00782.990.001155.48
Mehta, Cindy, A,219434624.910.002181.560.002443.35
Rai, Brendan, A,215694960.160.002443.350.002516.81
Chavez, Clayton,219494659.900.002181.560.002478.34
Chander, Latoya, C,261381957.470.00782.990.001174.48
Liang, Glenn,219834144.340.002443.350.001700.99
Ms., Sanchez, Madalena, J.,130202589.090.002049.100.00539.99
Torres, Eddie, L,219853936.540.002181.560.001754.98
Malhotra, Toni,261621903.480.00782.990.001120.49
Serrano, Reginald, J,130252690.400.002071.420.00618.98

Generated 2024-09-20 01:10:15.942 UTC