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

Top 1000 Australian Internet customers for 2020

250 items

DimCustomer.Name+','+DimCustomerIdId_SUM2022202320242025
Torres, Melinda, J,140336809.960.000.002071.424738.54
Raman, Johnathan,1910363.910.000.0041.9321.98
Rodriguez, Harold, M,2118474.980.000.000.0074.98
Goel, Lacey, N,1870433.260.000.0030.972.29
Chapman, Preston, O,182686102.190.003578.270.002523.92
Ye, Christy,142195744.220.000.002071.423672.80
Sharma, Tony,182416058.210.003578.272479.940.00
Yang, Jon, V,110008248.993399.990.002341.972507.03
Gomez, Felicia, J,182196038.560.003578.272460.290.00
Suarez, Carolyn, B,182226044.590.003578.272466.320.00
Johnson, Logan, K,229313882.550.000.003882.550.00
Lal, Katie, E,182106044.590.003578.272466.320.00
Fernandez, Kristopher, O,192714153.250.003578.27574.980.00
Huang, Colleen, S,213792992.330.002443.350.00548.98
Andersen, Carl, J,110578088.043374.990.002319.992393.06
Shen, Shaun,126846893.080.002049.100.004843.98
Kumar, Yolanda, J,1819485.960.000.000.0085.96
Sun, Louis, E,1618283.970.000.000.0083.97
Mehta, Mayra,129985694.900.000.002049.103645.80
Sai, Bruce,221944633.900.000.002181.562452.34
Sara, Tabitha, W,257151274.080.00699.100.00574.98
Schmidt, Deanna, H,259361248.080.00699.100.00548.98
Deng, Kate, L,157234444.070.000.002049.102394.97
Black, Rafael,1196655.760.000.000.0055.76
Deng, Latoya, H,219694759.470.000.002181.562577.91
Serrano, Alberto, L,158004399.080.000.002049.102349.98
Ferrier, Linda, D,1314964.970.000.000.0064.97
Ye, Lacey,29090778.620.000.000.00778.62
Gao, Curtis, D,204295377.750.003578.270.001799.48
Lopez, Heidi,110528131.323374.990.002337.272419.06
Sara, Edgar, A,111048173.030.003399.992334.982438.06
Harris, Eduardo, S,182386030.610.003578.272452.340.00
Jordan, Ross, F,111248129.020.003399.992309.972419.06
Raman, Deanna, H,17053123.960.000.000.00123.96
Kapoor, Pedro, H,242297.280.000.000.007.28
Ruiz, Adrienne,1352367.260.000.000.0067.26
Lin, Ronnie, D,213842921.020.002181.560.00739.46
Sanz, Marvin,196126029.570.003578.270.002451.30
Serrano, Anne,242443617.830.000.002443.351174.48
Jenkins, Anna, M,1723491.260.000.000.0091.26
Gill, Kristy,13669102.430.000.000.00102.43
Goel, Karl,1870559.260.000.000.0059.26
Alvarez, Mathew, L,17494111.960.000.000.00111.96
Sara, Cesar, C,221722932.300.000.002181.56750.74
Sai, Rachael,119128095.320.003374.990.004720.33
Li, Vincent, D,21207123.960.000.000.00123.96
Suarez, Melody, H,142765259.360.000.002049.103210.26
Ross, Julian,113635035.810.003399.990.001635.82
Li, Kristen, R,15153113.970.000.0088.9824.99
Malhotra, Janelle,2642569.990.000.000.0069.99
Zhao, Colin, D,242412997.320.000.002443.35553.97
Thomas, Sydney,143225111.440.000.002049.103062.34
Martinez, Harold, J,2060493.490.000.000.0093.49
Goel, Katie, D,2770864.470.000.000.0064.47
Gill, Stacy,12679187.980.000.0024.99162.99
Tang, April, A,259351256.030.00699.100.00556.93
He, Brent, R,257121262.060.00699.100.00562.96
Gonzalez, Virginia,119294965.780.003374.990.001590.79
Lu, Curtis,110118133.043399.990.004733.050.00
Ye, Leah,110778169.030.003374.992374.982419.06
Mehta, Brett,114508173.260.003374.992370.222428.05
Prasad, Arthur,142755158.370.000.002800.442357.93
Sai, Abby, L,111018262.520.003399.992439.992422.54
Kumar, Chad,110958158.010.003374.992363.962419.06
Sanz, Arthur,27688166.280.000.00166.280.00
Butler, Austin, W,1829374.240.000.0074.240.00
Sanz, Mathew, L,1455763.970.000.0063.970.00
Malhotra, Ross, R,2930714.980.000.0014.980.00
Lu, Christy,1706291.260.000.0091.260.00
Black, Priscilla,1576662.270.000.0034.9927.28
Wu, Mandy,183096090.590.003578.272512.320.00
Serrano, Diane, E,1485787.970.000.0078.988.99
Xu, Keith, J,2512464.470.000.000.0064.47
Lopez, Brenda,2659278.980.000.000.0078.98
Mehta, Nancy,181894118.260.003578.270.00539.99
She, Jerry, C,142775196.740.000.002071.423125.32
Jimenez, Naomi,249222145.920.000.001000.441145.48
Rivera, Devin, J,251094.990.000.000.004.99
Hayes, Eric, A,22964123.980.000.000.00123.98
Lal, Donna,25812113.970.000.000.00113.97
Guo, Rosa, M,244743882.550.000.002181.561700.99
Yuan, Derek, L,275891183.470.000.000.001183.47
Allen, Kaylee,266531938.470.000.00782.991155.48
Morgan, Sara,131345648.920.000.002049.103599.82
Moreno, Roberto, R,212063882.550.002181.560.001700.99
Black, Russell,1889737.290.000.000.0037.29
Garcia, Tina,1723183.980.000.000.0083.98
Ortega, Alfredo, W,259581903.480.00782.990.001120.49
Ruiz, Frank, M,142603716.230.000.002964.89751.34
Raman, Abby, T,151225193.720.000.002071.423122.30
Ma, Jorge, O,1405286.260.000.0027.2858.98
Torres, Neil,17305196.970.000.00196.970.00
Gutierrez, Frank, G,2284674.980.000.0074.980.00
Fernandez, Ross, R,1176376.650.000.0024.4952.16
Malhotra, Ruben, M,1707490.250.000.0058.9831.27
Lin, Suzanne,292874.990.000.004.990.00
Zhou, Rafael, A,244949.990.000.009.990.00
Navarro, Dana, J,1112579.690.000.0047.4232.27
Blanco, Rodney, A,201584153.250.003578.27574.980.00
Gonzalez, Veronica, C,233113337.040.000.003337.040.00
Deng, Kurt, D,13635215.740.000.0032.27183.47
Arun, Levi, A,1107494.190.000.0049.9744.22
Shen, Brendan, L,143053652.200.000.002049.101603.10
Serrano, Jésus, B,129915641.900.000.002049.103592.80
Vazquez, Latasha,2195299.470.000.000.0099.47
Rana, Carla, K,195935306.540.003578.270.001728.27
Rodriguez, Carolyn,210022992.330.002443.350.00548.98
Bradley, Emma,142115662.900.000.002049.103613.80
Russell, Alexis, L,13634234.930.000.000.00234.93
Serrano, Dwayne,1669576.150.000.000.0076.15
Zeng, Amy,242422756.540.000.002181.56574.98
Blanco, Larry, E,212164935.670.002443.350.002492.32
Vazquez, Victor, R,29453742.350.000.000.00742.35
Raji, Wayne, A,261611903.480.000.00782.991120.49
Zhu, Lacey,241672983.340.000.002443.35539.99
Hernandez, Jessie, A,241722735.530.000.002181.56553.97
Chande, Willie, B,161632641.390.000.002071.42569.97
Miller, Edward,113685106.240.003374.990.001731.25
Perez, Evelyn,143463583.260.000.002071.421511.84
Shen, Lindsey,265601396.440.000.00782.99613.45
Pal, Roger, D,2770539.980.000.000.0039.98
Nara, Jaclyn, M,119305035.810.003399.990.001635.82
Liang, Randy, E,2895814.980.000.000.0014.98
Romero, Philip, F,221954909.670.000.002443.352466.32
Moreno, Janet, L,1559259.980.000.0024.9934.99
Kapoor, Patricia, R,2188342.280.000.0042.280.00
Shen, Jodi, A,2202869.990.000.0069.990.00
Parker, Mason, W,259236.280.000.006.280.00
James, Evan, V,1111985.220.000.0035.2349.99
Xie, Alvin, M,16617160.550.000.0069.9790.58
Zhao, Ernest, C,187005328.230.003578.271749.960.00
Zhou, Cedric,175144142.230.003578.27563.960.00
Chen, Erica, P,183086037.890.003578.272459.620.00
Nara, Sharon,184826030.610.003578.272452.340.00
Yang, Heather,182756021.620.003578.272443.350.00
Chander, Misty,1733380.940.000.000.0080.94
Suri, Allen,215534666.500.002181.560.002484.94
Chandra, Jermaine, A,142995108.760.000.002071.423037.34
Clark, Joshua, A,2613769.990.000.000.0069.99
Xu, Martha, C,163515873.263578.270.000.002294.99
Martin, Diane,139586838.640.000.002049.104789.54
Adams, Devin,2187129.990.000.000.0029.99
Sai, Jay, A,234274.990.000.000.004.99
Romero, Ebony, A,2771712.940.000.000.0012.94
Suri, Holly, M,18286141.550.000.0069.9771.58
Chande, Kelli, C,229333917.540.000.002181.561735.98
Tang, Julie,265891966.460.000.00782.991183.47
Sara, Phillip, R,2511639.980.000.000.0039.98
Ma, Jessie,290926.280.000.000.006.28
Gray, Jeremiah,233314144.340.000.002443.351700.99
Ramirez, Mason, K,251072143.900.000.001000.441143.46
Brooks, Jared,244763563.840.000.002443.351120.49
Munoz, Deanna,110548223.023399.990.002403.972419.06
Luo, Alison, A,2352756.970.000.000.0056.97
Harrison, Colleen, L,202196044.590.003578.270.002466.32
Gomez, Jerome, J,250572120.930.000.001000.441120.49
Huang, Jorge,1729186.270.000.0053.9932.28
Zheng, Jenny, R,119474747.300.003374.99629.96742.35
Chander, Alison,182496044.590.003578.272466.320.00
Rivera, Nathaniel, M,140515606.910.000.003286.922319.99
Xie, Dawn,2139129.990.000.0029.990.00
Mehta, Brandy,2283939.250.000.0039.250.00
Liang, Steve,1431781.260.000.0049.9931.27
Vazquez, Anne,160273826.400.000.002071.421754.98
Sutton, Jaime, L,166305973.243578.270.000.002394.97
Ramos, Monique,164956002.233578.270.000.002423.96
Sanz, Eddie, A,19580173.930.000.000.00173.93
Rubio, Max, L,1957891.260.000.000.0091.26
Andersen, Brendan,151215202.730.000.002071.423131.31
Chander, Andres, E,29460751.340.000.000.00751.34
Madan, Michele, A,126766859.460.002071.420.004788.04
Moreno, Randall, F,2120939.990.000.000.0039.99
Blanco, Lori, A,15735116.250.000.000.00116.25
Raman, Dominique, D,1302358.980.000.000.0058.98
Pal, Sheena, D,211973917.540.002181.560.001735.98
Diaz, Kendra,130212668.380.000.002071.42596.96
Cox, Michelle, E,173284387.743578.270.000.00809.47
Martinez, Jay,245923896.530.000.002181.561714.97
Fernandez, Donald, C,244623617.830.000.002443.351174.48
Kapoor, Brandy, I,15236126.950.000.0037.9788.98
Xu, Lindsey,1558366.260.000.000.0066.26
Anderson, Richard, G,249242143.900.000.001000.441143.46
He, Susan, A,244673337.040.000.002181.561155.48
Huang, Tamara, E,1405386.260.000.0086.260.00
Nara, Tonya, C,17251123.960.000.0069.9753.99
Carlson, Jose,1995474.450.000.0060.4713.98
Reed, Riley, A,201574118.260.003578.27539.990.00
Zhang, Amy,183076021.620.003578.272443.350.00
Sai, Kari, E,1423183.970.000.0024.9958.98
Mr., Rovira Diez, Pablo,2119042.280.000.0042.280.00
Hernandez, Audrey,1829084.960.000.008.9975.97
Garcia, Harold, K,14087341.970.000.00159.00182.97
Ma, Cara,18885110.460.000.00110.460.00
Yuan, Colin,1175858.050.000.0024.4933.56
Perez, Bryant, L,150423807.400.000.002071.421735.98
Lal, Nina, L,142635647.930.000.002049.103598.83
Alvarez, Larry, T,142355682.200.000.002071.423610.78
Prasad, Cory,197484.990.000.000.004.99
Raje, April, R,1874432.220.000.000.0032.22
Bailey, Allison,2137769.990.000.000.0069.99
Rubio, Larry,14223155.940.000.000.00155.94
Yuan, Roger,1962261.750.000.000.0061.75
Ramos, Kristine,17479163.400.000.000.00163.40
Gonzales, Logan,166075897.533578.270.000.002319.26
Zhao, Lacey, M,277131158.960.000.000.001158.96
Ye, Alvin, B,155752910.900.000.002071.42839.48
Rana, Terrance, M,28134574.980.000.000.00574.98
Nelson, Julia, L,11102102.910.000.000.00102.91
Lin, Edwin,197664167.230.003578.27588.960.00
Black, Tonya, M,2125489.970.000.0089.970.00
Carter, Amber, E,16679106.560.000.0071.5834.98
Guo, Krystal, S,17381188.930.000.00188.930.00
Goel, Ricardo, T,259611938.470.00782.990.001155.48
Hernandez, Jaime,241703018.330.000.002443.35574.98
Dominguez, Wendy,110356451.313374.990.000.003076.32
Ramos, Naomi, M,236564144.340.000.002443.351700.99
Wu, Aimee,16690165.070.000.000.00165.07
Tang, Christy, R,236603917.540.000.002181.561735.98
King, Evan,166375900.553578.270.000.002322.28
Navarro, Cheryl,131095682.900.000.002049.103633.80
Hernandez, Krista, J,269181399.940.000.00782.99616.95
Weber, Cynthia,269211336.960.000.00782.99553.97
Rana, Pedro, F,139706843.140.000.002049.104794.04
Sanz, Lawrence, M,140306905.470.000.002071.424834.05
Suarez, Ruben,140316964.420.000.002049.104915.32
Kumar, Jaime, O,290613.990.000.000.003.99
Johnsen, Jerry,2667069.990.000.000.0069.99
She, Sharon, F,2201769.990.000.000.0069.99
Vance, Kristi, T,2833847.970.000.000.0047.97
Rubio, Bruce, E,233433936.540.000.002181.561754.98
Xu, Sharon, A,233443882.550.000.002181.561700.99
Fernandez, Candace,111058095.990.003399.992294.992401.01
Flores, Miranda,1724383.980.000.0053.9929.99
Suarez, Erika,151205217.700.000.002049.103168.60
Vazquez, Jimmy, D,123486906.090.002049.100.004856.99
Romero, Desiree, J,1723932.280.000.000.0032.28
Gao, Candice, M,17493130.960.000.000.00130.96
Hernandez, Bruce,179194733.750.003578.270.001155.48
Jai, Tommy, C,150272853.570.000.002049.10804.47
Sanz, Gerald, J,17060123.960.000.000.00123.96
Ma, Curtis,28119574.980.000.000.00574.98
Blanco, Hector, J,229384173.320.000.002443.351729.97
Zheng, Barbara,274931353.460.000.00782.99570.47
Pal, Dustin,265881938.470.000.00782.991155.48
Zhang, Kristen,274841322.980.000.00782.99539.99
Carlson, Wendy,202206060.500.003578.270.002482.23
Ye, Jenny,250362120.930.000.001000.441120.49
Lopez, Mayra, E,273561336.960.000.00782.99553.97
Gomez, Brandi, M,14675187.980.000.000.00187.98
Morris, Megan,2364164.470.000.000.0064.47

Generated 2025-10-31 15:38:48.956 UTC