[ROOT]  dt  FactInternetSale  WHERE DimCurrency.AlternateKey EQ 'AUD'  >   PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount   ORDER BY 2020 DESC  >   <  TAKE 250  >   TITLE Top 1000 Australian Internet customers for 2020   

Top 1000 Australian Internet customers for 2020

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2021202220232024
Liu, Jessie,111068079.053399.990.004679.060.00
Torres, Ruben,110028114.043399.990.004714.050.00
Sanchez, Joel,184685333.253578.270.001754.980.00
Lal, Donna,25812113.970.000.000.00113.97
Chande, Mindy, V,274721345.950.000.00782.99562.96
She, Katie, B,11965118.740.000.0094.2524.49
Yuan, Derek, L,275891183.470.000.000.001183.47
Liu, Jaclyn,129966808.150.002049.102374.982384.07
Huang, Amy, C,12244114.960.000.00114.960.00
Raje, Raul, L,2678574.980.000.0074.980.00
Lu, Krystal,170494347.763578.270.00769.490.00
Gutierrez, Armando,293102419.060.000.002419.060.00
Chande, Michele, C,130786850.460.002071.422359.982419.06
Lopez, Edgar, O,1734681.460.000.0081.460.00
Li, Jake, L,1958397.960.000.0097.960.00
Sara, Ruben, A,19566164.910.000.00164.910.00
Ortega, Anne,130116819.110.002049.102316.972453.04
Goel, Barbara,129886915.440.002049.102482.272384.07
Vazquez, Hector, E,197726030.610.003578.272452.340.00
Black, Russell,1889737.290.000.000.0037.29
Zeng, Krystal, A,2581461.960.000.000.0061.96
Garcia, Tina,1723183.980.000.0029.9953.99
Collins, Rebecca, M,261531957.470.00782.990.001174.48
Ortega, Alfredo, W,259581903.480.00782.990.001120.49
Yuan, Lacey, W,123496772.140.002049.102329.982393.06
Xu, Lacey, S,179134733.753578.270.000.001155.48
Chen, Autumn, I,214084624.910.002181.560.002443.35
Moreno, Larry, W,282072461.550.000.002461.550.00
Raje, Terrence,182466030.613578.270.002452.340.00
Sai, Cesar,182436058.213578.270.002479.940.00
Chander, Bethany, K,114468237.013399.990.004837.020.00
Wang, Crystal, C,111128295.023374.990.002500.972419.06
Shen, Karla, E,22925134.930.000.000.00134.93
Gonzalez, Joel, A,150433846.890.000.002071.421775.47
Blanco, Larry, E,212164935.670.002443.350.002492.32
Stone, Keith,1733140.960.000.008.9931.97
Zhu, Lacey,241672983.340.000.002443.35539.99
Chande, Willie, B,161632641.390.000.002071.42569.97
Shen, Lindsey,265601396.440.00782.990.00613.45
Diaz, Derrick, R,1485337.970.000.000.0037.97
Jai, Brad, C,1826764.980.000.0034.9929.99
Zeng, Brittney, K,13670178.450.000.0054.47123.98
Nara, Gregory,266511957.470.00782.990.001174.48
Vazquez, Ross,11148126.240.000.0053.9972.25
Chandra, Ann,182096056.613578.270.002478.340.00
Hu, Alejandro,13125138.540.000.00104.9833.56
Powell, Thomas, R,182186021.623578.270.002443.350.00
Peterson, Juan, H,130826906.390.002071.422382.932452.04
Xu, Colleen, C,18325108.850.000.00108.850.00
She, Willie,170554347.763578.270.00769.490.00
Van, Cassandra,135254607.230.002071.422535.810.00
Kapoor, Ruben, D,111098245.013374.990.004870.020.00
Rana, Whitney, A,130066762.150.002049.102319.992393.06
Moreno, Kristine, K,28481778.620.000.00778.620.00
Sara, Ann, A,2357639.980.000.0039.980.00
Rubio, Erika, A,114528183.043374.990.004808.050.00
Jai, Maurice,229324169.330.002443.351725.980.00
Travers, Jimmy, V,126746829.470.002071.422319.992438.06
Nath, Carly, J,172554442.243578.270.000.00863.97
Ms., Sandidge, Mary, R.,14016121.060.000.0057.0963.97
Ruiz, Kristine, J,246074.990.000.000.004.99
Ye, Franklin, L,1395282.260.000.000.0082.26
Browning, Jay, M,242512983.340.000.002443.35539.99
Goel, Marshall, M,27691603.490.000.000.00603.49
Blanco, Robyn, R,241793052.310.000.002443.35608.96
Chandra, Jermaine, A,142995108.760.000.002813.772294.99
Zhu, Colin,1997383.440.000.0022.9760.47
Lal, Sheena,2331213.980.000.000.0013.98
Chow, Christy, M,126816784.130.002049.102341.972393.06
Sun, Louis, E,1618283.970.000.0058.9824.99
Hernandez, Wendy, A,15124122.440.000.00122.440.00
Martin, Ruben,224002737.820.002181.56556.260.00
Hernandez, Leslie, D,129906829.470.002071.422319.992438.06
Gonzalez, Ruth,126936820.470.002071.422329.992419.06
Subram, Virginia,130362677.070.002049.100.00627.97
Adams, Devin,2187129.990.000.000.0029.99
Vazquez, Jonathon,1790621.490.000.000.0021.49
Jai, Karla,18263126.940.000.0034.9991.95
Sai, Jay, A,234274.990.000.000.004.99
Dominguez, Larry,221974740.980.002181.560.002559.42
Allen, Ian, A,160313750.090.000.002049.101700.99
Williams, Anna, R,175044362.743578.270.000.00784.47
Jimenez, Kathleen,266541346.760.00782.99563.770.00
Raji, Sheena, J,182136070.593578.270.002492.320.00
Huang, Eugene, L,110016383.883374.990.002419.93588.96
Gao, Stacey,166624355.713578.270.00777.440.00
Long, Isabelle, W,231043490.030.002181.561308.470.00
Fernandez, Kristopher, O,192714153.253578.270.00574.980.00
Yang, Wesley, K,151275182.730.000.002071.423111.31
Sutton, Jaime, L,166305973.243578.270.000.002394.97
Mehta, Levi, M,131105583.940.002049.100.003534.84
Yuan, Terry, R,136466843.600.002049.102410.432384.07
Lal, Terrence,1236994.230.000.000.0094.23
Kapoor, Pedro, H,242297.280.000.007.280.00
Pal, Arturo, P,293032419.060.000.002419.060.00
Goel, Karl,1870559.260.000.0059.260.00
Liu, Clarence,197976021.620.003578.272443.350.00
Li, Vincent, D,21207123.960.000.00123.960.00
Vazquez, Jésus,2666578.980.000.0078.980.00
Subram, Tabitha, C,175114150.533578.270.00572.260.00
Sara, Edgar, A,111048173.033399.990.004773.040.00
Johnson, Elizabeth,110048196.013399.990.004796.020.00
Navarro, Kathleen, J,192694118.263578.270.00539.990.00
Andersen, Brendan,151215202.730.000.002071.423131.31
Coleman, Nicole, A,215584919.300.002443.350.002475.95
Chander, Andres, E,29460751.340.000.000.00751.34
Mehta, Heidi,142265656.240.000.002071.423584.82
Moreno, Randall, F,2120939.990.000.000.0039.99
Cai, Steve, M,2215569.990.000.000.0069.99
Zeng, Suzanne,179184733.753578.270.000.001155.48
Allen, Luis, C,260191957.470.00782.990.001174.48
Nara, Dale, L,212264659.800.002181.560.002478.24
Alvarez, Jessie,143245121.430.000.002049.103072.33
Carlson, Audrey, A,2526360.470.000.000.0060.47
Pal, Sheena, D,211973917.540.002181.560.001735.98
Flores, Brianna,27706553.970.000.000.00553.97
Sun, Jorge,160253831.890.000.002071.421760.47
Vazquez, Eddie, T,140125249.920.000.002826.442423.48
Black, Tommy,243764.990.000.000.004.99
Martinez, Stanley, Z,13668114.210.000.00106.267.95
Zhang, Cara,12351117.970.000.0093.4824.49
Hill, James, S,293172438.060.000.002438.060.00
Jones, Ethan,130516831.740.002071.422362.272398.05
Ruiz, Krista, C,130816772.150.002049.102329.992393.06
Zhou, Trisha, B,126866864.460.002071.422354.982438.06
Sai, Ivan, E,1730094.220.000.0094.220.00
Mehta, Nancy,181894118.263578.270.00539.990.00
Miller, Zachary, M,151692919.890.000.002071.42848.47
Chandra, Veronica,146815178.400.000.002049.103129.30
Chapman, Patricia,120377107.100.003374.991249.842482.27
Kumar, Chad,110958158.013374.990.004783.020.00
Zhang, Barbara,16338169.430.000.00169.430.00
Butler, Austin, W,1829374.240.000.0074.240.00
Suarez, Pedro, A,246112219.420.001000.441218.980.00
Black, Priscilla,1576662.270.000.0062.270.00
She, Kristin, L,1996197.970.000.008.9988.98
Chen, Bianca,248914.990.000.000.004.99
Chen, Louis, J,17059123.960.000.0069.9753.99
Taylor, Jennifer,184706021.623578.270.002443.350.00
Gao, Erica, R,1908747.200.000.0047.200.00
Lin, Dawn, N,15805127.470.000.000.00127.47
Kumar, Rafael, L,1908824.270.000.002.2921.98
Arun, Bryant, C,2045321.490.000.0021.490.00
Yang, Hunter, E,2023721.490.000.0021.490.00
Arun, Levi, A,1107494.190.000.0094.190.00
Diaz, Nelson, C,213872745.330.002181.56563.770.00
Beck, April,143025140.730.000.002813.772326.96
Simpson, Sharon, L,2512339.980.000.000.0039.98
Chander, Alisha,125722611.410.002071.420.00539.99
Coleman, Luis, L,142305661.900.000.002049.103612.80
Zheng, Sandra, P,1514163.970.000.000.0063.97
Tang, Christy, R,236603917.540.000.002181.561735.98
Vance, Henry,27986553.970.000.000.00553.97
Weber, Cynthia,269211336.960.000.00782.99553.97
Kapoor, Jarrod,2893015.230.000.000.0015.23
Kumar, Jaime, O,290613.990.000.000.003.99
Lee, Destiny,1705883.980.000.0029.9953.99
Dominguez, Micheal,261421952.450.00782.990.001169.46
Vazquez, Jimmy, D,123486906.090.002049.102423.952433.04
Romero, Desiree, J,1723932.280.000.000.0032.28
Serrano, Gloria, G,215564930.680.002443.350.002487.33
Jai, Tommy, C,150272853.570.000.002049.10804.47
Raman, Brandy,1224777.270.000.0077.270.00
Lin, Autumn, E,182726056.613578.270.002478.340.00
Liu, Candice,287202419.060.000.002419.060.00
Zhou, Cedric,175144142.233578.270.00563.960.00
Chen, Erica, P,183086037.893578.270.002459.620.00
Nara, Sharon,184826030.613578.270.002452.340.00
Kumar, Tonya, A,229344173.320.002443.350.001729.97
Zhang, Kristen,274841322.980.000.00782.99539.99
Arthur, Rebekah,229393961.030.002181.560.001779.47
Gonzalez, Cynthia,15787167.930.000.00103.9663.97
Xu, Alison,14227114.960.000.0049.9964.97
Sanders, Devin, J,120143949.970.003399.99549.980.00
Ramirez, Mason, K,251072143.900.000.002143.900.00
Andersen, Maurice,1520698.960.000.0063.9734.99
Luo, Alison, A,2352756.970.000.0056.970.00
Ward, Brooke,130075671.240.002071.421249.842349.98
Lin, Rafael,14099200.260.000.0041.26159.00
Bradley, Victoria,29454742.350.000.000.00742.35
She, Marshall, D,18707122.760.000.00120.472.29
Zeng, Jon, O,143105200.660.000.002071.423129.24
Yang, Tiffany, K,212154624.910.002181.560.002443.35
Ferrier, Jaime, P,2352875.970.000.000.0075.97
Gutierrez, Dana,2025460.470.000.000.0060.47
Gutierrez, Victor, J,2735769.990.000.000.0069.99
Sanchez, Henry,2696878.980.000.000.0078.98
Ma, Colin,2642869.990.000.000.0069.99
Raman, Ruth, L,211994144.340.002443.350.001700.99
Watson, Nathaniel, H,258261854.580.00699.100.001155.48
Li, Warren, R,29185563.770.000.000.00563.77
Luo, Lacey,241752743.040.000.002181.56561.48
Luo, Barbara,2797829.480.000.0029.480.00
Martin, Ethan, M,13998245.250.000.0097.97147.28
Vazquez, Neil, K,287192384.070.000.002384.070.00
Suarez, Daisy, A,182886093.203578.270.002514.930.00
Xie, Dawn,2139129.990.000.0029.990.00
Mehta, Brandy,2283939.250.000.0039.250.00
Ferrier, Leslie, M,285352433.040.000.002433.040.00
Green, Jonathan, A,173324480.733578.270.000.00902.46
Gao, Bianca, C,131125717.890.002049.100.003668.79
Martin, Pedro, B,281031214.850.000.000.001214.85
Andersen, Rafael, E,12691247.460.000.0049.48197.98
She, Gregory,184584733.753578.270.000.001155.48
Lal, Alisha, C,2187234.980.000.000.0034.98
Xie, Lindsey, M,251324.990.000.000.004.99
Huang, Lacey, J,1195163.520.000.000.0063.52
Vance, Toni, L,23438123.480.000.000.00123.48
Johnson, Brianna, J,1731938.980.000.000.0038.98
She, Mindy, J,13009168.670.000.000.00168.67
Serrano, Mathew, A,29186603.490.000.000.00603.49
Torres, Wendy, A,182696113.203578.270.000.002534.93
Luo, Nina,2749535.000.000.000.0035.00
Diaz, Dana, C,12361217.460.000.000.00217.46
Campbell, Haley, L,1730462.270.000.000.0062.27
Kapoor, Rachael, D,1191162.460.000.0037.4724.99
Fernandez, Donald, C,244623617.830.000.003617.830.00
Hernandez, Gina,140495290.680.002071.42876.332342.93
Subram, Kari,12682227.960.000.0068.96159.00
Xu, Lindsey,1558366.260.000.0034.9931.27
Lopez, Summer,1203669.550.000.0029.5739.98
Zheng, Randy, B,2257469.990.000.0069.990.00
Fernandez, Lydia, M,145233807.400.000.003807.400.00
Nara, Tonya, C,17251123.960.000.00123.960.00
Van, Brenda, J,2489039.980.000.0039.980.00
Zhu, Jorge,2614178.980.000.0078.980.00
Reed, Riley, A,201574118.260.003578.27539.990.00
Zhang, Amy,183076021.623578.270.002443.350.00
Lal, Franklin, A,141013679.900.000.003679.900.00
Nara, Tony, L,167136090.593578.270.002512.320.00
Sun, Suzanne, P,245873882.550.000.002181.561700.99
Ye, Dennis, M,166385974.233578.270.000.002395.96
Romero, Wendy, H,113724965.813374.990.000.001590.82
Cooper, Cody, A,160283807.400.000.002071.421735.98
Griffin, Caroline,177264721.733578.270.001143.460.00
Gill, Theodore,1114941.260.000.007.2833.98
Bailey, Allison,2137769.990.000.0069.990.00
Yang, Valerie, L,2736169.990.000.000.0069.99
Vazquez, Theresa, F,225812749.320.002181.56567.760.00
Zimmerman, Jenny,1819730.970.000.008.9921.98
Ramos, Jaime,1572070.220.000.0035.2334.99
Patel, Jillian,266671390.950.00782.99607.960.00
Black, Tonya, M,2125489.970.000.0089.970.00
Goel, April, C,16166108.850.000.0069.9738.88
Navarro, Erik, E,250557.280.000.000.007.28
Ruiz, Gloria,123435567.930.002049.101223.842294.99
Sanz, Francis,125772614.080.002049.100.00564.98
Xie, Michele, M,1503978.960.000.008.9969.97
Shen, Wayne, P,2364712.940.000.000.0012.94
Pal, Mindy,1909724.270.000.0021.982.29

Generated 2024-06-14 00:38:29.304 UTC