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

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Deng, Casey, C,1967442.280.000.000.0042.28
Yuan, Cassie, J,2445360.470.000.000.0060.47
Ortega, Dwayne, C,246152155.920.000.002155.920.00
Chavez, Corey, R,1573159.980.000.000.0059.98
Prasad, Arthur,142755158.370.000.002800.442357.93
Becker, Grant,2139032.280.000.000.0032.28
Ramos, Danny,231214144.340.000.002443.351700.99
Kovár, Donald, M,242779.990.000.009.990.00
Raman, César, C,240042744.520.000.002181.56562.96
Munoz, Robyn,142145759.870.000.002049.103710.77
Raji, Kate, L,119038108.040.003374.992294.992438.06
Ruiz, Alberto, L,2521227.770.000.000.0027.77
Hernandez, Joe,1515484.980.000.000.0084.98
Liang, Louis, M,127066851.410.000.002071.424779.99
Gonzalez, Devin,184856063.210.003578.272484.940.00
Chen, Steve, R,189024186.230.003578.27607.960.00
Lu, Suzanne, K,167124417.753578.270.000.00839.48
Gao, Tiffany, E,163525948.493578.270.000.002370.22
Lu, Curtis,110118133.043399.990.004733.050.00
Ruiz, Kari, L,12695192.970.000.000.00192.97
Long, Isabelle, W,231043490.030.000.003490.030.00
Deng, Peter, A,240062721.550.000.002181.56539.99
Huang, Crystal, L,260231917.460.00782.990.001134.47
Jai, Gregory,1634246.470.000.000.0046.47
Anand, Tamara,29088756.330.000.000.00756.33
Perez, Edgar, B,293182384.070.000.000.002384.07
Ramos, Briana, J,143033636.910.000.002049.101587.81
Kumar, Rafael, L,1908824.270.000.002.2921.98
She, Corey, T,212144659.900.002181.560.002478.34
Morris, Megan,2364164.470.000.000.0064.47
Dominguez, Joy,221753018.330.000.002443.35574.98
Chen, Aimee,265911957.470.000.00782.991174.48
She, Katie, B,11965118.740.000.0094.2524.49
Ortega, Armando, K,25223102.960.000.000.00102.96
Garcia, Martin, l,233324144.340.000.002443.351700.99
Reed, Steven,2437327.770.000.000.0027.77
She, Rafael, I,201524142.750.003578.27564.480.00
Perez, Preston,1237061.530.000.002.2959.24
Carlson, Byron,119008257.010.003399.992374.982482.04
Pal, Christy, R,187395371.740.003578.271793.470.00
Reed, Riley, A,201574118.260.003578.27539.990.00
Yuan, Karla, W,136296889.110.000.002049.104840.01
Sanz, Ricky,182516035.600.003578.272457.330.00
She, Glenn, L,291179.990.000.000.009.99
Raman, Cassandra,2871867.970.000.000.0067.97
Lu, Trisha,255551277.56699.100.000.00578.46
Gonzalez, Meredith,221712721.550.000.002181.56539.99
Blanco, Billy,233162835.020.000.002181.56653.46
Ramos, Cindy, G,11361114.960.000.000.00114.96
Ross, Brandon,141323804.080.000.002049.101754.98
Bell, Isabella,276981179.970.000.000.001179.97
Weber, Jay, A,2524421.930.000.0021.930.00
Wu, Kelvin,2459561.960.000.000.0061.96
Sanchez, Cynthia, S,236623917.540.000.002181.561735.98
Carlson, Joy,13981124.210.000.000.00124.21
Bailey, Sean, L,27710563.770.000.000.00563.77
Butler, Elijah, D,2155129.990.000.000.0029.99
Torres, Gina,179044733.750.003578.270.001155.48
Stone, Mitchell,2501369.970.000.000.0069.97
Luo, Shawn,122463947.250.003374.990.00572.26
Goel, Roger, A,236523907.540.000.002181.561725.98
Suarez, Nelson,273551383.450.000.00782.99600.46
Yuan, Colin,1175858.050.000.000.0058.05
Alexander, Hailey, C,1966635.000.000.000.0035.00
Lopez, George,150403807.400.000.002071.421735.98
Chavez, Clayton,219494659.900.000.002181.562478.34
Perez, Ivan, S,234084218.820.000.002443.351775.47
Zhu, Lacey,241672983.340.000.002443.35539.99
Dominguez, Leslie,273461390.950.000.00782.99607.96
Raje, Marshall, J,1926742.280.000.000.0042.28
Gao, Jamie,260221938.470.00782.990.001155.48
Shen, Kelvin,224063018.330.000.002443.35574.98
Lal, Kate,215574886.700.002443.350.002443.35
Nath, Alvin, R,29301134.980.000.000.00134.98
Black, Wayne, E,250567.280.000.000.007.28
Srini, Darren, P,155914346.380.000.002049.102297.28
Raman, Geoffrey, P,154353801.390.000.002071.421729.97
Weber, Chelsea,291912393.060.000.000.002393.06
Patel, Rachael, G,1364071.250.000.0032.2738.98
Diaz, Roberto, A,222024671.740.000.002181.562490.18
Suri, Carmen, E,242502738.490.000.002181.56556.93
Alvarez, Desiree,13005223.970.000.000.00223.97
Garcia, Ivan, L,173546029.570.003578.270.002451.30
Hu, Cara,206086035.600.003578.270.002457.33
Chander, Damien,110808204.020.003374.992359.982469.05
Vazquez, Marc, H,243623600.770.000.002443.351157.42
Kapoor, Veronica, G,202536035.600.003578.270.002457.33
Martinez, Douglas, C,2284135.000.000.0035.000.00
Shan, Clarence,224082770.520.000.002181.56588.96
Madan, Candace,224092746.040.000.002181.56564.48
Henderson, Paige, C,1732554.940.000.000.0054.94
Garcia, Rebekah, M,140073772.410.000.003772.410.00
Liu, Jenny,1616581.810.000.000.0081.81
Perry, Madison, R,233084.990.000.000.004.99
Carlson, Clinton, E,11116148.700.000.0027.28121.42
Moreno, Felicia, A,129876759.470.000.002071.424688.05
Gao, Stacey,166624355.713578.270.00777.440.00
Evans, Jackson,1432127.280.000.000.0027.28
Rivera, Jada,2197032.280.000.000.0032.28
Alan, Bob, A,273661322.980.000.00782.99539.99
Sun, Christy,252182184.900.000.001000.441184.46
Ortega, Reginald, K,264291938.470.000.00782.991155.48
Sai, Francisco, W,187664752.750.003578.270.001174.48
Ramos, Audrey,119768087.310.003374.992319.262393.06
Peterson, Allison, A,2642160.470.000.000.0060.47
Zhu, Alisha, G,182396030.610.003578.272452.340.00
Zhang, Brittney, W,199756056.610.003578.270.002478.34
Deng, Michele,219464659.800.002181.560.002478.24
Nelson, Julia, L,11102102.910.000.000.00102.91
Lu, Margaret, D,208144186.230.003578.27607.960.00
Ward, Brooke,130075671.240.000.002071.423599.82
Munoz, Darren,235394144.340.000.002443.351700.99
Zhou, Steve, C,2026321.490.000.000.0021.49
Li, Kristen, R,15153113.970.000.0088.9824.99
Moreno, Meghan, J,151524464.570.000.002049.102415.47
Carlson, Jonathon, N,1707378.970.000.000.0078.97
Garcia, Charles, M,2025037.270.000.000.0037.27
Shen, Willie, S,1845025.480.000.000.0025.48
Mehta, Erick, E,1412361.580.000.000.0061.58
Garcia, Harold, K,14087341.970.000.00159.00182.97
Jai, Ethan,1521741.260.000.0031.279.99
Jai, Bonnie,119778212.500.003399.990.004812.51
Alexander, Elizabeth,130896800.450.000.002071.424729.03
Kapoor, Patricia, R,2188342.280.000.0042.280.00
Martin, Randall, B,195606117.690.003578.270.002539.42
Torres, Eddie, L,219853936.540.000.002181.561754.98
Pal, Nichole, J,2674169.990.000.000.0069.99
She, Ricardo, A,1423378.970.000.000.0078.97
Sanz, Kari, V,273411322.980.000.00782.99539.99
Sharma, Cedric, A,1406099.470.000.0049.9949.48
Shan, Colleen, D,151504379.080.000.002049.102329.98
Subram, Douglas,273521357.970.000.00782.99574.98
Malhotra, Pedro,215594900.680.002443.350.002457.33
Navarro, Erik, E,250557.280.000.000.007.28
Gill, Lawrence, J,2022444.460.000.000.0044.46
Hernandez, Monique, J,15138123.450.000.0034.9988.46
Martin, Reginald,14054210.770.000.000.00210.77
Malhotra, Kristina,2503125.480.000.000.0025.48
Cooper, Victoria, S,136376777.130.000.002049.104728.03
Alan, Meghan, I,28210564.480.000.000.00564.48
Ms., Sanchez, Madalena, J.,130202589.090.000.002049.10539.99
Blanco, Jésus, E,204486044.590.003578.270.002466.32
Goldstein, Dustin,123378137.010.003399.990.004737.02
Liang, Eugene,1397277.270.000.000.0077.27
Ramirez, Olivia, D,197856076.610.003578.270.002498.34
Torres, Alfredo,2768574.980.000.000.0074.98
Munoz, Meredith,139575645.240.000.002071.423573.82
Malhotra, Ross, R,2930714.980.000.0014.980.00
Zheng, Darryl,187066060.500.003578.270.002482.23
Gonzales, Victoria,117518215.020.003399.990.004815.03
Hernandez, Audrey,1829084.960.000.008.9975.97
Tang, Jenny, E,142105621.240.000.002071.423549.82
Gomez, Adrienne,119208156.320.003374.990.004781.33
Moreno, Beth,219804334.610.000.002443.351891.26
Chander, Shawn, S,202165338.740.003578.270.001760.47
Lal, Terrence,1236994.230.000.000.0094.23
Kumar, Chad,110958158.010.003374.992363.962419.06
Guo, Randy, L,2295664.470.000.000.0064.47
Nara, Yolanda,29080777.340.000.000.00777.34
Zhao, Jaclyn, D,261671903.480.000.00782.991120.49
Luo, Priscilla, R,1790727.770.000.000.0027.77
Garcia, Donald,189296029.570.003578.270.002451.30
Andersen, Calvin,2292091.950.000.000.0091.95
Guo, Glenn, J,1871224.270.000.000.0024.27
He, Louis, E,212114900.680.002443.350.002457.33
Rai, Bradley,1910079.260.000.000.0079.26
Deng, Gilbert, C,157654369.090.000.002049.102319.99
Shan, Connor, C,1890135.000.000.000.0035.00
Wood, Fernando, K,242539.990.000.000.009.99
Johnson, Logan, K,229313882.550.000.003882.550.00
Nara, Willie,244603302.050.000.002181.561120.49
Pal, Christine, I,182426121.710.003578.272543.440.00
Deng, Johnny,2140935.000.000.000.0035.00
Wang, Erica, J,221682997.320.000.002443.35553.97
Romero, Sabrina, L,28534603.490.000.000.00603.49
Alonso, Brandi,1706186.270.000.000.0086.27
Ruiz, Bruce, W,16171103.860.000.000.00103.86
Hall, Jesse,261331938.470.00782.990.001155.48
Zheng, Sandra, P,1514163.970.000.000.0063.97
Sanz, Jésus,29313539.990.000.000.00539.99
Lal, Alisha, C,2187234.980.000.000.0034.98
Raji, Kathryn, C,2199537.290.000.000.0037.29
Madan, Bruce, G,1820665.960.000.000.0065.96
Rai, Terrence, R,250372174.920.000.001000.441174.48
Yuan, Julie,229593917.540.000.002181.561735.98
Xu, Lacey, S,179134733.750.003578.270.001155.48
Suri, Cassandra, B,1871787.210.000.000.0087.21
Rodriguez, Evelyn,131176831.420.000.002049.104782.32
Li, Jack, J,140715617.920.000.002049.103568.82
Raje, Lacey, T,123586787.760.002071.420.004716.34
Ortega, Jill, A,202396093.200.003578.270.002514.93
Watson, Anna,202386021.620.003578.270.002443.35
Perez, Henry,267521917.460.000.00782.991134.47
Rana, Marco, K,2447313.980.000.000.0013.98
Tang, Drew, W,151784445.060.000.002049.102395.96
Chander, Gregory, J,2200174.980.000.000.0074.98
Hernandez, Kristine,142865234.400.000.002049.103185.30
Coleman, Paige, L,1526369.970.000.000.0069.97
Andersen, Karl, M,231053361.530.000.003361.530.00
Chen, Louis, J,17059123.960.000.000.00123.96
Garcia, Jermaine,2156642.280.000.0042.280.00
Goel, Bethany,27511548.980.000.000.00548.98
Ye, Alejandro, W,150293826.400.000.002071.421754.98
Cooper, Allison, J,29294553.970.000.000.00553.97
Zhu, Colleen,1725292.970.000.000.0092.97
Chow, Amy, E,126996798.130.002049.100.004749.03
Nath, Louis, C,258301833.570.00699.100.001134.47
Rodriguez, Pedro, L,179114698.760.003578.270.001120.49
Chandra, Carmen, R,2331515.230.000.000.0015.23
Madan, Rachael, R,1648676.970.000.0076.970.00
Ortega, Danny, K,197946098.580.003578.270.002520.31
Martin, Joan, R,255561253.070.00699.100.00553.97
Ashe, Tara, J,190936035.600.003578.270.002457.33
Suri, Whitney, J,219744925.170.000.002443.352481.82
Navarro, Rodney, L,293092419.060.000.000.002419.06
Nara, Michele, R,2284286.460.000.000.0086.46
Xu, Kristen,157514446.400.000.002071.422374.98
Romero, Erika,199586056.510.003578.270.002478.24
Raji, Derek, D,1959163.420.000.000.0063.42
Zeng, Micah, A,255611288.060.00699.100.00588.96
Andersen, Tara, L,244653356.040.000.002181.561174.48
Chen, Randy,13004190.270.000.000.00190.27
Zhang, Jenny, H,246092120.930.001000.441120.490.00
Chandra, Troy,2140674.980.000.0074.980.00
Kumar, Tommy,17297100.250.000.0037.2762.98
Foster, Luke,15137161.940.000.0097.9763.97
Zhao, Randy, J,278741288.310.000.001288.310.00
Richardson, Abigail, S,142365710.230.000.002071.423638.81
Rubio, Desiree, D,211894208.310.002443.350.001764.96
Raje, Ashlee, E,166585873.263578.270.000.002294.99
Sai, Frederick,209914118.260.003578.270.00539.99
Zhu, Edwin,2714878.980.000.000.0078.98
Jimenez, Gary, E,16609344.040.000.0084.95259.09
Kovar, Mayra, J,173124471.743578.270.000.00893.47
Prasad, Gerald, B,1203581.240.000.0064.9716.27
Ms., Robinson, Rebecca, A.,1191341.260.000.000.0041.26
Zhao, Ernest, C,187005328.230.003578.271749.960.00
Zhang, Claudia,131146807.450.000.002071.424736.03
Suri, Marie,242813302.050.000.002181.561120.49
Goel, Tonya,2912323.970.000.000.0023.97
Liu, Susan,187186035.600.003578.270.002457.33
Ferrier, Leslie, M,285352433.040.000.002433.040.00
Martinez, Bruce, D,184524752.750.003578.270.001174.48
King, Nathan,27719599.470.000.000.00599.47
Zhou, Laura, D,126836801.450.002071.420.004730.03
Rai, Michele, M,265671957.470.000.00782.991174.48
Pal, Nina,29297613.450.000.000.00613.45
Mr., Schmidt, Irving, W,126696791.100.002049.100.004742.00
Gao, Jorge,235733337.040.000.002181.561155.48
Gomez, Kathleen, J,161584369.090.000.002049.102319.99

Generated 2024-11-10 05:30:18.600 UTC