[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
Ruiz, Francis, D,2138169.990.000.000.0069.99
Zhao, Crystal,259066.280.000.000.006.28
Munoz, Ebony,131065697.520.000.002071.423626.10
Anderson, Victoria,157994423.380.000.002071.422351.96
Subram, Troy, R,196076054.220.003578.272475.950.00
Jackson, Eduardo, C,1174939.970.000.0039.970.00
Vance, Phillip,293082438.060.000.002438.060.00
Mehta, Denise,130806844.410.002049.102362.272433.04
Nara, Cassie,1364279.970.000.0029.9849.99
Carlson, Tanya,1618331.270.000.0031.270.00
Ramos, Marie, A,143085140.400.000.002049.103091.30
Madan, Michele, A,126766859.460.002071.422349.982438.06
Blanco, Lori, A,15735116.250.000.000.00116.25
Zeng, Suzanne,179184733.753578.270.000.001155.48
Rai, Willie,146735117.750.000.002071.423046.33
Alvarez, Jessie,143245121.430.000.002049.103072.33
Raje, Casey, A,14686203.460.000.0059.98143.48
Arun, Denise,2821818.970.000.000.0018.97
Pal, Sheena, D,211973917.540.002181.560.001735.98
Alexander, Gabriel, C,14073156.840.000.0038.88117.96
Li, Elijah,167406099.103578.270.002520.830.00
Martinez, Cory, A,1512581.260.000.0031.2749.99
Jai, Ethan,1521741.260.000.0031.279.99
Hernandez, Orlando, C,219514923.290.002443.350.002479.94
Evans, Jackson,1432127.280.000.000.0027.28
Li, Justin,1412457.590.000.0032.6024.99
Luo, Bethany,1958236.270.000.000.0036.27
Patel, Douglas,179274726.043578.270.000.001147.77
Chapman, Kristi, l,219863882.550.002181.560.001700.99
Zhao, Marshall, C,220333917.540.002181.560.001735.98
Malhotra, Cynthia,113585034.780.003374.990.001659.79
Ruiz, Alberto, L,2521227.770.000.000.0027.77
Ross, Brandon,141323804.080.000.003804.080.00
Perez, Edgar, B,293182384.070.000.002384.070.00
Barnes, Angelica,1512877.270.000.0077.270.00
Henderson, Xavier, K,1299396.250.000.0067.2628.99
Ramos, Meredith, A,2330767.930.000.0067.930.00
Ramos, Michele, J,1957496.740.000.0096.740.00
Romero, Dwayne,28314553.970.000.00553.970.00
Liang, Louis, M,127066851.410.002071.422331.952448.04
Chandra, Veronica,146815178.400.000.002049.103129.30
Lal, Nina, L,142635647.930.000.002049.103598.83
Sharma, Donna,119986962.100.003374.991249.842337.27
Arthur, Kristi, W,166754385.033578.270.00806.760.00
Mehta, Ann, M,14518126.950.000.0063.9762.98
Rodriguez, Dylan, E,1661175.530.000.0042.9332.60
Lin, Claudia, A,14312191.270.000.00166.2824.99
Xu, Kelsey, W,2822013.980.000.000.0013.98
Ma, Brittney,125842633.390.002071.420.00561.97
Kumar, Louis, A,182034172.253578.270.000.00593.98
Lin, Kelli, A,2139229.990.000.000.0029.99
Xu, Barbara,1407459.880.000.0027.2832.60
Mr., Solanki, Ajay,18295144.270.000.00144.270.00
Carter, Sophia, D,2523080.960.000.0080.960.00
Romero, Max, C,293162433.040.000.002433.040.00
Jimenez, Jill,110286474.623374.990.002357.28742.35
Liu, Christy,197846021.620.003578.272443.350.00
Zheng, Omar, C,14522126.950.000.000.00126.95
Anand, Lacey, J,27150201.280.000.000.00201.28
Vance, Ruth, D,17302147.440.000.0058.9888.46
Zheng, Shannon, M,1467849.990.000.0049.990.00
Zimmerman, Jenny,1819730.970.000.008.9921.98
Serrano, Shannon, R,183036030.610.003578.272452.340.00
Johnson, Morgan, E,120114735.810.003374.99618.47742.35
Vazquez, Lawrence,1963256.980.000.0056.980.00
Ramos, Craig,14209193.970.000.004.99188.98
Washington, Marcus,283296.280.000.000.006.28
Wu, Aimee,16690165.070.000.000.00165.07
Suri, Phillip,179144698.763578.270.000.001120.49
Walker, Seth, E,27689539.990.000.000.00539.99
Sanz, Gerald, J,17060123.960.000.000.00123.96
Li, Margaret,157534399.080.000.002049.102349.98
Rai, Johnny, A,131356773.140.000.002049.104724.04
Carlson, Alfredo,16178108.850.000.0038.8869.97
Ma, Christy,1502040.260.000.000.0040.26
Carlson, Billy, C,19667150.950.000.000.00150.95
Prasad, Gerald, B,1203581.240.000.0078.952.29
Xie, Cristina, C,170504496.233578.270.000.00917.96
Wu, Bianca, F,28485751.340.000.000.00751.34
Perez, Marie,1399666.260.000.000.0066.26
She, Colleen, E,2931269.970.000.000.0069.97
Anand, Rafael,293062384.070.000.000.002384.07
Lopez, Toni, K,2514021.490.000.000.0021.49
Alonso, Billy, M,2285239.990.000.000.0039.99
Xie, Alicia,26427123.980.000.000.00123.98
Gill, Joanna,2618638.980.000.000.0038.98
Lal, Leonard,261601938.470.00782.990.001155.48
Suri, Pedro,264221980.960.000.00782.991197.97
Zimmerman, Candice, J,267541938.470.000.00782.991155.48
Cai, Jorge,220313896.530.002181.560.001714.97
Green, Devin, J,264401957.470.000.00782.991174.48
Long, Nicole, C,13624114.970.000.0059.9854.99
Sharma, Christian,1580962.590.000.0032.6029.99
Mehta, Gerald,2023432.280.000.0032.280.00
Chavez, Colin,1603290.950.000.0090.950.00
Kovár, Donald, M,242779.990.000.009.990.00
Rodriguez, Francisco,243613391.030.000.002181.561209.47
Lopez, Edgar, O,1734681.460.000.000.0081.46
Navarro, Casey,197956044.590.003578.270.002466.32
Chow, Amy, E,126996798.130.002049.100.004749.03
Alvarez, Stacy,119018248.010.003399.990.004848.02
Vazquez, Hector, E,197726030.610.003578.270.002452.34
Liang, Amy,161642639.080.000.002049.10589.98
Bradley, Victoria,29454742.350.000.000.00742.35
Flores, Antonio, D,142593630.930.000.002888.58742.35
Fernandez, Shane, A,1312786.260.000.000.0086.26
Ferrier, Jaime, P,2352875.970.000.000.0075.97
Gutierrez, Dana,2025460.470.000.000.0060.47
Sanchez, Henry,2696878.980.000.000.0078.98
Raman, Ruth, L,211994144.340.002443.350.001700.99
Li, Warren, R,29185563.770.000.000.00563.77
Sanz, Orlando,1430999.470.000.0074.4824.99
Smith, Adriana,187025333.250.003578.271754.980.00
Rodriguez, Rachael, M,119444776.270.003374.99609.96791.32
Deng, Carl,182846029.570.003578.272451.300.00
Alvarez, Gloria, B,182976119.590.003578.272541.320.00
Zeng, Heather, E,1828772.160.000.0072.160.00
Madan, Marco,1889527.770.000.0027.770.00
Martin, Roy,2206569.990.000.0069.990.00
Smith, Christian, L,14313222.440.000.000.00222.44
Nelson, Mary, L,131075650.900.000.002049.103601.80
Ferrier, Jenny,219554900.680.002443.350.002457.33
Deng, Jaime, R,219684722.880.002181.560.002541.32
Alonso, Jimmy, T,18280126.560.000.000.00126.56
Li, Jaclyn,182816081.100.003578.270.002502.83
Johnson, Brianna, J,1731938.980.000.000.0038.98
Ramos, Roberto, M,13159208.180.000.000.00208.18
Serrano, Mathew, A,29186603.490.000.000.00603.49
Hu, Amy,14320261.950.000.000.00261.95
Malhotra, Douglas, L,229604.990.000.000.004.99
Campbell, Haley, L,1730462.270.000.000.0062.27
Torres, Jacquelyn, P,274646.280.000.000.006.28
Hu, Alejandro,13125138.540.000.000.00138.54
Munoz, Craig, V,130766862.140.002049.100.004813.04
Peterson, Juan, H,130826906.390.002071.420.004834.97
Allen, Logan,1581281.250.000.000.0081.25
Serrano, Leslie, T,1401462.270.000.000.0062.27
Ortega, Max,234133617.830.000.003617.830.00
Moreno, Kristine, K,28481778.620.000.000.00778.62
Prasad, Marco, C,15606115.930.000.0077.9637.97
Sanz, Hector,2734469.990.000.000.0069.99
Tang, Rafael, A,119088079.050.003374.992319.992384.07
Subram, Martin, S,1959032.280.000.0032.280.00
Sun, Jaclyn,1821165.960.000.0056.978.99
Mehta, Carla, L,2156339.990.000.0039.990.00
Reed, Kimberly, D,1731169.970.000.000.0069.97
Chandra, Virginia, M,2758815.230.000.000.0015.23
James, Evan, V,1111985.220.000.0035.2349.99
Sai, Barry,229074169.330.000.002443.351725.98
Zhang, Claudia,131146807.450.000.002071.424736.03
Hernandez, Kellie, A,125862636.410.002071.420.00564.99
Suri, Lydia,131266815.080.000.002049.104765.98
Goel, Chad,2821939.980.000.000.0039.98
Huang, Colleen, S,213792992.330.002443.350.00548.98
Andersen, Carl, J,110578088.043374.990.002319.992393.06
Martinez, Kari,196096093.200.003578.270.002514.93
Shen, Shaun,126846893.080.002049.100.004843.98
Kumar, Yolanda, J,1819485.960.000.000.0085.96
Hernandez, Leslie, D,129906829.470.002071.420.004758.05
Rubio, Tanya, I,15598167.930.000.000.00167.93
Shan, Drew,236594179.330.000.002443.351735.98
Malhotra, Marco, L,29459805.330.000.000.00805.33
Wood, Julia, L,123566810.130.002049.102341.972419.06
Li, Cedric,2736478.980.000.0078.980.00
Gao, Rafael, R,1873324.270.000.0024.270.00
Nara, Johnny, R,184896081.100.003578.272502.830.00
Navarro, Jacquelyn,1546540.230.000.0029.9910.24
Nara, Derek, A,2613934.470.000.0034.470.00
Sharma, Carl,2137539.980.000.0039.980.00
Henderson, Dalton,248954.990.000.004.990.00
Weber, Jay, A,2524421.930.000.0021.930.00
Rodriguez, Bobby,157524408.690.000.002071.422337.27
Guo, Jaclyn,131196829.450.000.002071.424758.03
Serrano, Randall,27973539.990.000.000.00539.99
Raji, Dale,1926542.280.000.000.0042.28
Gutierrez, Pedro, S,1522471.920.000.0036.9334.99
Kapoor, Kaitlin, M,17072123.960.000.000.00123.96
Foster, Aidan,264451938.470.000.00782.991155.48
Hu, Barbara,19567104.960.000.0075.9728.99
Zhao, Jessie, R,110276591.573399.990.000.003191.58
Gill, Kristy,13669102.430.000.0094.487.95
Alvarez, Mathew, L,17494111.960.000.000.00111.96
Martin, Beth, K,2331739.980.000.000.0039.98
Gill, Hector, M,261871932.460.00782.990.001149.47
Raje, Derek,125742626.390.002071.420.00554.97
Ramos, Briana, J,143033636.910.000.002894.56742.35
Xie, Michele, M,1503978.960.000.000.0078.96
Andersen, Jaime,2526860.470.000.000.0060.47
Gomez, Carrie,229657.280.000.000.007.28
Liu, Jenny,1616581.810.000.000.0081.81
Sun, Shannon,120077023.780.003399.991283.822339.97
Raman, Johnathan,1910363.910.000.0041.9321.98
Carlson, Philip, P,119158143.000.003374.992369.962398.05
Blanco, Sheila, I,1772436.960.000.000.0036.96
Rubio, Marie, V,2061821.490.000.0021.490.00
Davis, Nicole,2295739.980.000.000.0039.98
Morris, Eduardo,19619112.750.000.0088.9723.78
Diaz, Felicia, J,1502629.980.000.0024.994.99
Rana, Jermaine, S,289272419.060.000.002419.060.00
Arun, Ross, C,236583936.540.000.002181.561754.98
Sara, Tabitha, W,257151274.080.00699.100.00574.98
Alvarez, Larry, T,142355682.200.000.002071.423610.78
Sharma, Misty,257081253.070.00699.100.00553.97
Li, Crystal, L,143255152.700.000.002049.103103.60
Deng, Kate, L,157234444.070.000.002049.102394.97
Alexander, Olivia, L,146675295.410.000.002049.103246.31
Serrano, Marvin, E,1731697.450.000.000.0097.45
Ramos, Naomi, M,236564144.340.000.002443.351700.99
Hill, James, S,293172438.060.000.000.002438.06
Harris, Thomas,240022744.520.000.002181.56562.96
Jones, Ethan,130516831.740.002071.420.004760.32
Lal, Cristina, M,146712934.370.000.002071.42862.95
Sai, Ivan, E,1730094.220.000.000.0094.22
Luo, Christine, J,241592756.540.000.002181.56574.98
Gomez, Adrienne,119208156.320.003374.990.004781.33
Goel, Roger, A,236523907.540.000.002181.561725.98
Sanz, Paula,2643069.990.000.000.0069.99
Evans, Jonathan, D,151854393.700.000.002071.422322.28
Nara, Dustin, M,179104698.763578.270.000.001120.49
Shan, Tasha,151924384.080.000.002049.102334.98
Rana, Darren, M,172574480.733578.270.000.00902.46
Diaz, Josue,152074446.400.000.002071.422374.98
Nara, Karla, C,258271873.580.00699.100.001174.48
Gutierrez, Latasha, C,150222999.910.000.002071.42928.49
Chapman, Alicia, A,214184659.900.002181.560.002478.34
Liu, Randy,150153804.080.000.002049.101754.98
Ross, Adam,110998215.993399.990.002363.962452.04
Serrano, Deanna, W,151444344.090.000.002049.102294.99
Ortega, Dwayne, C,246152155.920.001000.441155.480.00
Sara, Donald, M,251142155.920.000.001000.441155.48
Zeng, Colleen, L,2830491.970.000.0091.970.00
Howard, Jesse, D,242492756.540.000.002181.56574.98
Shen, Bridget,1723762.980.000.0062.980.00
Lu, Suzanne, K,167124417.753578.270.00839.480.00
Zhao, Jorge,16711132.950.000.0062.9869.97
Hill, Mackenzie,195766058.210.003578.272479.940.00
Zeng, Claudia, M,166964506.763578.270.00928.490.00
Kumar, Kenneth,114728165.820.003399.992322.282443.55
Sai, Summer, S,2285570.960.000.000.0070.96
Lal, Carl, C,2895044.980.000.0044.980.00
Ramos, Rebekah, L,27984561.480.000.000.00561.48
Weber, Chelsea,291912393.060.000.002393.060.00
Martin, Reginald,14054210.770.000.000.00210.77
She, Latoya, A,117508148.020.003399.992349.982398.05
Ortega, Briana, L,29346567.760.000.000.00567.76
Blanco, Marc,249082155.920.000.002155.920.00
Gonzalez, Virginia,119294965.780.003374.990.001590.79
Andersen, Kate,1423790.250.000.0031.2758.98
Ramirez, Olivia, D,197856076.610.003578.270.002498.34
Rana, Stanley, J,2291958.980.000.000.0058.98

Generated 2024-09-16 19:51:06.582 UTC