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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Sanz, Larry,14067114.960.000.000.00114.96
Huang, Jake,1958995.260.000.000.0095.26
Anderson, Blake,110768159.040.003399.992374.982384.07
Chander, Edwin, T,173704742.740.003578.270.001164.47
Raman, Mayra, P,209904196.220.003578.270.00617.95
Martin, Renee, L,174784758.240.003578.270.001179.97
Suri, Phillip,179144698.760.003578.270.001120.49
Zeng, Micah, A,255611288.060.00699.100.00588.96
Lu, Tiffany,2284348.980.000.000.0048.98
Alvarez, Roy, A,16709143.940.000.000.00143.94
Sun, Leah,177344698.760.003578.270.001120.49
Shen, Leonard, J,242712745.330.000.002181.56563.77
Zhang, Willie, T,16023166.890.000.000.00166.89
Yang, Curtis,111108093.030.003399.992294.992398.05
Lal, Katie, E,182106044.590.003578.272466.320.00
Ramos, Randall,215724659.900.002181.560.002478.34
Hall, Jeremiah, M,182506058.210.003578.272479.940.00
Suarez, Brandi,218744638.890.000.002181.562457.33
Cai, Tiffany,182044133.240.003578.270.00554.97
Wang, Alan,136226841.430.000.002071.424770.01
Chandra, Ann,182096056.610.003578.272478.340.00
Rana, Ivan, K,181964133.240.003578.270.00554.97
Kumar, Louis, A,182034172.250.003578.270.00593.98
Navarro, Daisy,27514539.990.000.000.00539.99
Ruiz, Danny,2445621.490.000.000.0021.49
Alonso, Sheila,25054103.480.000.000.00103.48
Ruiz, Melody,13621167.400.000.000.00167.40
Zhu, Jamie, J,1314069.990.000.000.0069.99
Martin, Craig, M,2501274.460.000.000.0074.46
Smith, Allen,1407274.980.000.000.0074.98
Raman, Levi,291142384.070.000.000.002384.07
Liu, Jessie,111068079.050.003399.992294.992384.07
Torres, Wendy, A,182696113.200.003578.270.002534.93
Martin, Alyssa,1958721.490.000.000.0021.49
Jiménez, Orlando, M,21283124.940.000.000.00124.94
Zhang, Claudia,131146807.450.000.002071.424736.03
Moreno, Pedro, A,182486037.890.003578.272459.620.00
Carson, Shaun,111264972.370.003399.990.001572.38
Li, Jaclyn,182816081.100.003578.270.002502.83
Mehta, Tina, C,114448136.020.003374.992376.962384.07
Serrano, Audrey,183376021.620.003578.270.002443.35
Jai, Katrina,1304459.980.000.000.0059.98
Yang, Jamie, S,184654752.750.003578.270.001174.48
James, Mariah, M,1910430.970.000.000.0030.97
Ye, Edwin,183344698.760.003578.270.001120.49
Lal, Mario, T,233454.990.000.000.004.99
Collins, Jennifer,113644921.820.003374.990.001546.83
Romero, Wendy, H,113724965.810.003374.990.001590.82
Griffin, Grace,114438235.000.003374.990.004860.01
Xu, Julie,183016056.610.003578.272478.340.00
Martin, Randall, B,195606117.690.003578.270.002539.42
Taylor, Jennifer,184706021.620.003578.272443.350.00
Li, Trisha, A,182966117.690.003578.272539.420.00
Deng, Carl,182846029.570.003578.272451.300.00
Prasad, Jarrod,113594960.070.003374.990.001585.08
Kumar, Kenneth,114728165.820.003399.990.004765.83
Liu, Bianca, K,1145831.920.000.000.0031.92
Gonzalez, Michele, D,184916056.610.003578.270.002478.34
Lopez, Kristina, L,202476056.610.003578.270.002478.34
Gonzalez, Carla, J,183366145.070.003578.270.002566.80
Madan, Francisco, S,257061239.090.00699.100.00539.99
Raman, Frederick, F,289429.990.000.000.009.99
Sai, Ronald, B,136436799.450.000.002071.424728.03
Rai, Brad, S,184906029.570.003578.270.002451.30
Weber, Chelsea,291912393.060.000.000.002393.06
Lal, Tara, S,186975279.260.003578.271700.990.00
Raje, Louis, M,257071262.060.00699.100.00562.96
Gill, Diana,257101239.090.00699.100.00539.99
Chander, Bethany, K,114468237.010.003399.992354.982482.04
She, Rosa,189316060.500.003578.270.002482.23
Lin, Laura, L,114628116.330.003374.992322.282419.06
Hu, Alvin, E,114498130.320.003374.992362.272393.06
She, Gregory,184584733.750.003578.270.001155.48
Nara, Sharon,184826030.610.003578.272452.340.00
Huang, Alan, A,126716802.130.002049.100.004753.03
Mehta, Preston, G,186926035.600.003578.272457.330.00
Suarez, Tabitha,2511039.980.000.000.0039.98
She, Ricardo, A,1423378.970.000.000.0078.97
Ashe, Maurice,204306056.610.003578.270.002478.34
Alvarez, Gloria, B,182976119.590.003578.272541.320.00
Blanco, Marc,249082155.920.000.001000.441155.48
Goel, Jodi,204476035.600.003578.270.002457.33
Kapoor, Veronica, G,202536035.600.003578.270.002457.33
Perry, Gavin, M,125782668.080.002049.100.00618.98
Malhotra, Emmanuel,183324752.750.003578.270.001174.48
Sharma, Lindsay, E,244783337.040.000.002181.561155.48
Smith, Adriana,187025333.250.003578.271754.980.00
Xu, Willie, C,131606839.460.000.002071.424768.04
Alvarez, Philip, A,1112345.880.000.000.0045.88
Sharma, Cedric, A,1406099.470.000.0049.9949.48
Yuan, Kathryn, L,231063956.010.000.002181.561774.45
Zheng, Dawn, F,1957983.980.000.000.0083.98
Bhat, Yolanda,152254401.410.000.002071.422329.99
Kapoor, Denise, M,187256044.590.003578.270.002466.32
Anand, Katrina, L,187265314.250.003578.271735.980.00
Nath, Dawn, L,117598054.050.003374.990.004679.06
Guo, Sandra,236643941.530.000.002181.561759.97
Rubio, Erika, A,114528183.040.003374.992414.992393.06
Ashe, Tara, J,190936035.600.003578.270.002457.33
Chandra, Harold, K,1723686.270.000.000.0086.27
Arthur, Regina, A,190896093.200.003578.270.002514.93
Martinez, Heidi, L,2292268.970.000.000.0068.97
Goel, Gilbert,155964460.040.000.002049.102410.94
Yuan, Willie,234214208.310.000.002443.351764.96
Butler, Gavin, D,2294971.970.000.000.0071.97
Ramos, Alfredo,204566029.570.003578.270.002451.30
Zeng, Louis,189034143.740.003578.27565.470.00
Hu, Cara,206086035.600.003578.270.002457.33
Nara, Priscilla,189074167.230.003578.27588.960.00
Fernandez, Denise, A,187246056.510.003578.272478.240.00
Powell, Amanda,28113901.350.000.000.00901.35
Alvarez, Kristy,155884486.070.000.002049.102436.97
Xie, Kurt, A,14344126.950.000.000.00126.95
Gomez, Naomi, E,243004144.340.000.002443.351700.99
Patterson, Ashley, R,187366035.600.003578.270.002457.33
Chen, Clarence, R,1514797.450.000.000.0097.45
Raji, Omar,156433807.400.000.002071.421735.98
Sara, Tabitha, W,257151274.080.00699.100.00574.98
Suarez, Meredith,150323800.080.000.002049.101750.98
Prasad, Gerald, B,1203581.240.000.0064.9716.27
Ma, Darryl, R,1559981.240.000.000.0081.24
Carlson, Alfredo,16178108.850.000.000.00108.85
Navarro, Kathleen, J,192694118.260.003578.27539.990.00
Jones, Ethan,130516831.740.000.002071.424760.32
Patel, Cynthia, M,15222123.450.000.000.00123.45
Moreno, Kathleen, C,1523459.980.000.000.0059.98
Sai, Martin, L,2122129.990.000.000.0029.99
Ye, Claudia, J,191026029.570.003578.270.002451.30
Cai, Vincent, L,1175758.050.000.0024.4933.56
Jai, Alvin,195995279.260.003578.270.001700.99
Lal, Corey, H,233132906.030.000.002181.56724.47
Navarro, Julio, M,258221819.590.00699.100.001120.49
Raman, Edgar, A,2759664.470.000.000.0064.47
Xu, Tara,195925377.230.003578.270.001798.96
Reed, Steven,2437327.770.000.000.0027.77
Moreno, Robin,195635333.250.003578.270.001754.98
Serrano, Joanna, J,266631976.940.000.00782.991193.95
Madan, Stanley,196026093.200.003578.270.002514.93
Martinez, Kari,196096093.200.003578.270.002514.93
Sanz, Diane, M,2015313.980.000.000.0013.98
Sanchez, Candace, L,215674973.280.002443.350.002529.93
Ortega, Danny, K,197946098.580.003578.270.002520.31
Ma, Laura, L,245033617.830.000.002443.351174.48
Nath, Louis, C,258301833.570.00699.100.001134.47
Ashe, Brad,252282120.930.000.001000.441120.49
Alvarez, Max, M,119868245.230.003399.990.004845.24
Hernandez, Alberto, D,250292272.200.000.001000.441271.76
Moreno, Roy, J,199516021.620.003578.270.002443.35
Navarro, Casey,197956044.590.003578.270.002466.32
Shan, Derek, R,197826089.590.003578.270.002511.32
Mr., Solanki, Ajay,18295144.270.000.000.00144.27
Dominguez, Kellie, E,1724486.270.000.000.0086.27
Sanz, Walter, J,1819594.470.000.000.0094.47
Shan, Darrell, J,2734569.990.000.000.0069.99
Nara, Karla, C,258271873.580.00699.100.001174.48
Black, Shawna, C,152054433.690.000.002071.422362.27
Wu, Amy,197906089.590.003578.270.002511.32
Gutierrez, Ricky,197736056.610.003578.270.002478.34
Sara, Marco, L,1564196.750.000.000.0096.75
Prasad, Harold,1960868.450.000.000.0068.45
Liu, Darryl,199476056.510.003578.270.002478.24
Fernandez, Geoffrey,199636054.220.003578.270.002475.95
Liang, Rosa, L,197704127.250.003578.27548.980.00
Kumar, Tony, P,197836021.620.003578.270.002443.35
Carlson, Marc, W,17501141.980.000.000.00141.98
Raman, Candace, M,117668280.480.003399.992419.462461.03
Foster, Hunter, A,202694.990.000.000.004.99
Bradley, Diane, A,1514062.270.000.0027.2834.99
Madan, Kristi, I,291842420.340.000.000.002420.34
Hu, Kristen, C,197886056.610.003578.270.002478.34
Luo, Michele,260271938.470.00782.990.001155.48
Jai, Kathryn,235463337.040.000.002181.561155.48
Moreno, Tabitha,199596056.610.003578.270.002478.34
Hill, Aaron,2581835.960.000.000.0035.96
Ms., Rousey, Linda, R.,212794.990.000.000.004.99
Ashe, Jimmy, S,2895914.980.000.000.0014.98
Xu, Mindy,202466035.600.003578.270.002457.33
Serrano, Dana, S,12678341.430.000.000.00341.43
Blanco, Rodney, A,201584153.250.003578.27574.980.00
Foster, Madison,140386819.120.000.002049.104770.02
Deng, Johnny,2140935.000.000.000.0035.00
Xie, Drew, A,20218104.690.000.000.00104.69
Gonzalez, Virginia,119294965.780.003374.990.001590.79
Nara, Jaclyn, M,119305035.810.003399.990.001635.82
Gomez, Mallory, R,248987.280.000.000.007.28
Gonzalez, George, L,119424792.290.003399.99614.96777.34
Raji, Dawn, C,202446021.620.003578.270.002443.35
Raji, Derek, D,1959163.420.000.000.0063.42
Yuan, Marshall, P,199786060.500.003578.270.002482.23
Bailey, Savannah, J,2342839.980.000.000.0039.98
Gutierrez, Orlando,259201819.590.00699.100.001120.49
Martin, Gerald, K,1728490.250.000.0031.2758.98
Jimenez, Tanya, D,199706099.100.003578.270.002520.83
Rodriguez, Rachael, M,119444776.270.003374.99609.96791.32
Xu, Randy, S,119698173.020.003399.990.004773.03
Li, Gilbert,239992730.540.000.002181.56548.98
Xylaras, Ioannis,202155279.260.003578.270.001700.99
She, Candice,291782452.040.000.000.002452.04
Madan, Jay, L,201564139.750.003578.27561.480.00
Ortega, Jill, A,202396093.200.003578.270.002514.93
Hu, Leah,119948169.030.003374.990.004794.04
Yuan, Grant, C,249092149.910.000.001000.441149.47
Shan, Johnny,119997043.270.003399.990.003643.28
Carlson, Jonathon, N,1707378.970.000.000.0078.97
Munoz, Darren,235394144.340.000.002443.351700.99
He, Dennis, J,278781283.820.000.000.001283.82
Becker, Julie,13614114.210.000.000.00114.21
Srini, Douglas, M,1673335.260.000.000.0035.26
Blanco, Kari,1962741.750.000.0027.7713.98
Vance, Denise, L,212054886.700.002443.350.002443.35
Vance, Meredith, B,209834178.730.003578.270.00600.46
Green, Jennifer,125712641.390.002071.420.00569.97
Chande, Bonnie, L,239923167.820.000.002443.35724.47
Yang, Lacey,1315089.240.000.000.0089.24
Gill, Carolyn,2309467.930.000.000.0067.93
Garcia, Harold, K,14087341.970.000.00159.00182.97
Garcia, Monica, D,2026749.970.000.000.0049.97
Zhao, Shannon,1980735.470.000.000.0035.47
Sara, Cassandra, D,209894148.740.003578.270.00570.47
Hernandez, Logan,123506791.750.002071.420.004720.33
Flores, Katherine,211803882.550.002181.560.001700.99
Ms., Simon, Britta,259461873.580.00699.100.001174.48
Zhu, Omar,250332120.930.000.001000.441120.49
Gutierrez, Rodney, J,206286056.610.003578.270.002478.34
Pal, Terrence, M,1303759.980.000.000.0059.98
Li, Justin,1412457.590.000.000.0057.59
Bradley, Emma,142115662.900.000.002049.103613.80
Romero, Deanna, K,2357021.980.000.000.0021.98
Suri, Stanley, J,2749642.280.000.000.0042.28
Raje, Arturo, C,1422849.990.000.000.0049.99
Carlson, Francis,273401350.750.000.00782.99567.76
Gutierrez, Micheal, S,272991322.980.000.00782.99539.99
Zhang, Barbara,16338169.430.000.0058.47110.96
Zhou, Brent,1543432.280.000.000.0032.28
Anand, Carly,259181260.580.00699.100.00561.48
Arthur, Raymond, S,202286093.200.003578.270.002514.93
Becker, Kelsey, G,119688079.050.003399.992294.992384.07
Romero, Marie,204244132.240.003578.27553.970.00
Gutierrez, Larry,259261308.060.00699.100.00608.96
Shen, Katie, A,202835314.250.003578.270.001735.98
Wang, Rosa, I,119938131.320.003374.990.004756.33
Goel, Alicia, H,204234177.740.003578.270.00599.47
Sharma, Donna,119986962.100.003374.991249.842337.27
Torres, Sabrina, E,204254118.260.003578.27539.990.00
Wu, Laura,206156060.500.003578.270.002482.23
Alonso, Meredith, M,206216117.690.003578.270.002539.42
Subram, Kristi, N,15025128.940.000.000.00128.94
Suarez, Joy, B,1266574.540.000.000.0074.54
Guo, Micah, M,241632756.540.000.002181.56574.98
Hu, Susan,252422120.930.000.001000.441120.49

Generated 2024-11-13 00:59:00.474 UTC