[ROOT]  dt  FactInternetSale  <  WHERE DimCurrency.AlternateKey EQ ALL   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
Roberts, Jordan, M,1680075.840.000.000.0075.84
Thomas, Madison, M,13389115.950.000.000.00115.95
Kumar, Nathan,19168119.980.000.00119.980.00
Coleman, Miguel, D,2740069.990.000.0069.990.00
Scott, Samuel, C,23161574.980.000.000.00574.98
Collins, Isabella, D,1681439.980.000.0039.980.00
Beck, Alicia, L,172484382.753578.270.000.00804.48
Allen, Jason,155291587.470.000.00782.99804.48
James, Bailey, A,22972539.990.000.000.00539.99
Sanders, Paige,252872983.340.002443.350.00539.99
Moreno, Jessie, C,229064624.910.000.002181.562443.35
Russell, Brandon,1527856.970.000.0056.970.00
Garcia, Tina,1723183.980.000.000.0083.98
Flores, Angela, B,200281174.480.000.000.001174.48
Howard, Erin, L,183621725.210.000.000.001725.21
Perez, Levi,26830553.970.000.000.00553.97
Reed, Alexandra, C,2768338.980.000.000.0038.98
Goel, Latoya, C,112397511.553374.990.002353.951782.61
Howard, Garrett,189761750.980.000.000.001750.98
Parker, Seth, R,18962567.270.000.00567.270.00
Diaz, Katherine, P,115262376.960.000.002376.960.00
Chande, Christy,26214553.970.000.000.00553.97
Nelson, Chloe, E,120585936.200.003578.272357.930.00
Chande, Mindy, V,274721345.950.000.00782.99562.96
Huang, Willie, C,28133574.980.000.000.00574.98
Raman, Harold, F,28484778.620.000.000.00778.62
Rodriguez, Richard,12969180.790.000.000.00180.79
Xie, Devon, L,200994.990.000.000.004.99
Lopez, Madeline, G,12044105.950.000.000.00105.95
Beck, Alisha, E,1146347.920.000.007.9539.97
Kumar, Calvin, L,293882639.180.000.002639.180.00
Raji, Kelvin, S,288854470.890.000.002071.422399.47
Chen, Erica, P,183086037.890.003578.272459.620.00
Xie, Tasha, D,2469623.780.000.000.0023.78
Chander, Priscilla,165303001.040.000.002181.56819.48
Yang, Heather,182756021.620.003578.272443.350.00
Chande, Calvin, E,114834966.390.000.004426.40539.99
Sharma, Lacey, M,2947288.980.000.000.0088.98
Luo, Barbara,2797829.480.000.0029.480.00
Vance, Kaitlin,2938323.780.000.000.0023.78
Shan, Karla,194933515.370.000.003515.370.00
Butler, Maria,16067664.890.000.000.00664.89
Russell, Samantha,11211793.550.000.00118.46675.09
Thompson, Ryan, M,113301136.350.000.00198.94937.41
Hernandez, Philip,211933905.520.002181.560.001723.96
Gomez, Kristy, M,1923769.990.000.000.0069.99
Cook, Evan, H,1899169.990.000.000.0069.99
Jackson, Isabella, L,2203884.950.000.0084.950.00
Foster, Isabelle,2637739.980.000.000.0039.98
Lu, Brittney, A,1284873.960.000.000.0073.96
Hernandez, Diana, F,110386437.333374.990.000.003062.34
Watson, Eduardo, M,2345232.280.000.0032.280.00
Cooper, Morgan, R,23510553.970.000.000.00553.97
Arun, Sergio,2564339.980.000.000.0039.98
Raje, Dawn, D,256941223.840.000.000.001223.84
Moore, Richard, L,2242023.780.000.000.0023.78
Price, Jasmine, L,2890029.480.000.000.0029.48
Lewis, Sydney, L,1744713.980.000.0013.980.00
Lal, Arturo,1128344.570.000.000.0044.57
Mehta, Ruth,157026917.540.002181.560.004735.98
Rai, Michele, M,265671957.470.000.00782.991174.48
Bennett, Dalton, L,1187169.990.000.0034.9935.00
Yuan, Lacey, W,123496772.140.002049.100.004723.04
Cox, Allison, L,143351804.920.000.001000.44804.48
Gao, Tiffany, E,163525948.493578.270.000.002370.22
Raji, Yolanda, W,180195706.380.000.002181.563524.82
Edwards, Isaac, R,1337276.970.000.0076.970.00
Smith, Hunter, L,2150724.990.000.0024.990.00
Madan, Stanley,196026093.200.003578.270.002514.93
Turner, Eduardo,158764789.020.000.000.004789.02
Green, Luke, R,2839223.780.000.0023.780.00
Zukowski, Jake,220584118.263578.270.000.00539.99
Martinez, Joshua, M,23881548.980.000.000.00548.98
Wilson, Lucas,2762228.990.000.000.0028.99
Xie, Tommy, J,2942523.780.000.0023.780.00
Murphy, Morgan, J,253911256.780.000.000.001256.78
Hughes, Marissa,2472671.580.000.000.0071.58
Pal, Cedric,2323539.980.000.0039.980.00
Washington, Cassidy,1770134.470.000.0029.484.99
Martinez, Austin,2129214.980.000.000.0014.98
Lopez, Marco,1142910468.380.000.004401.406066.98
Ward, Isabella,148308346.280.003578.272433.042334.97
Raman, Stefanie,144246998.860.002181.560.004817.30
Lin, Vincent, A,28516563.770.000.000.00563.77
Evans, Alexandra,2432268.490.000.000.0068.49
Butler, Blake,135838375.293578.270.000.004797.02
Howard, Haley,24029562.960.000.000.00562.96
Perez, Timothy, L,227304.990.000.000.004.99
Pal, Franklin,1484185.480.000.000.0085.48
Torres, Derrick,1469189.970.000.000.0089.97
Lopez, Brandy, S,1819999.940.000.000.0099.94
Cooper, Michelle, L,1782229.990.000.000.0029.99
Perez, Evelyn,143463583.260.000.002071.421511.84
Sara, Phillip, R,2511639.980.000.000.0039.98
Navarro, Brandi,2553539.980.000.000.0039.98
Diaz, Derrick, R,1485337.970.000.000.0037.97
Munoz, Eddie,1209183.970.000.008.9974.98
Ms., Sloan, Cathy, J.,279482457.330.000.000.002457.33
Blanco, Tabitha,21609553.970.000.00553.970.00
Long, Megan, J,1579142.260.000.0024.9917.27
Flores, Blake,1120677.270.000.000.0077.27
He, Alisha, R,180262988.320.000.002181.56806.76
Hu, Shannon,194384337.900.00699.100.003638.80
Zeng, Kristen, A,175414.990.000.000.004.99
Jones, Andrew, C,165947231.370.000.002443.354788.02
Thomas, Eduardo, J,1424996.460.000.000.0096.46
Xu, Lacey, S,179134733.750.003578.270.001155.48
Young, Carlos, G,1780532.280.000.000.0032.28
He, Randy, R,240726.280.000.000.006.28
Garcia, Henry, B,112871167.070.000.00219.26947.81
Flores, Olivia, V,266384518.150.000.002049.102469.05
Gonzalez, Carlos,2047173.970.000.000.0073.97
Pal, Peter, K,2284839.990.000.0039.990.00
Lopez, Noah, M,1316330.970.000.000.0030.97
Washington, Logan, A,180571700.990.000.000.001700.99
Rai, Katie, A,149514153.250.003578.27574.980.00
Wang, Crystal, C,111128295.020.003374.990.004920.03
Navarro, Beth,1353486.240.000.000.0086.24
Wood, Jessica,1186347.940.000.000.0047.94
Carter, Jason,11724210.090.000.00113.8696.23
Hill, Katelyn,26945777.340.000.000.00777.34
Roberts, Jesse,16211586.970.000.000.00586.97
Washington, Oscar,2298029.990.000.0029.990.00
Pal, Jerry,255881223.840.000.000.001223.84
Ross, Angela, D,183932294.990.000.000.002294.99
Rubio, Marc, I,27854750.300.000.000.00750.30
Rodriguez, Cesar, L,2533559.980.000.0059.980.00
Xu, Eugene, A,14208117.430.000.0058.4758.96
Subram, Douglas,273521357.970.000.00782.99574.98
Munoz, Deanna,110548223.023399.990.002403.972419.06
Martinez, Brandon, S,2535229.980.000.000.0029.98
Griffin, Marcus,2075634.560.000.000.0034.56
Phillips, Jordan,23179539.990.000.000.00539.99
Jimenez, Hector,2625782.950.000.000.0082.95
Martin, Kristy, B,172621735.980.000.000.001735.98
Anderson, Zachary,113245945.230.003578.272366.960.00
Baker, Kyle,189821783.960.000.000.001783.96
Blanco, Lawrence, W,111895944.220.003578.272365.950.00
Parker, Katherine,13268289.700.000.0068.97220.73
Lal, Drew, A,28325574.980.000.000.00574.98
Ferrier, Leslie, M,285352433.040.000.002433.040.00
Sai, Ronald, B,136436799.450.000.002071.424728.03
Sun, Arturo, C,11498561.530.000.00151.90409.63
Malhotra, Manuel, S,21602548.980.000.00548.980.00
Serrano, Gary, G,21021628.970.000.00628.970.00
Perez, Miguel,13184220.460.000.000.00220.46
Ma, Colleen, A,114804935.360.000.004381.39553.97
Ashe, Jill, J,177562715.410.000.001000.441714.97
Pal, Mario, C,178244334.610.000.002443.351891.26
Gao, Erica, R,1908747.200.000.0047.200.00
Kumar, Sharon, C,135425943.243578.270.000.002364.97
Jimenez, Jaime, J,2833353.990.000.0053.990.00
Luo, Lindsay,135145973.243578.270.000.002394.97
Serrano, Theresa,1128455.480.000.0010.2445.24
Scott, Isaiah, E,1205189.980.000.0039.9949.99
Reed, Charles,147561588.570.00699.100.00889.47
Lopez, Pedro,21038573.980.000.000.00573.98
James, Richard, D,15760146.520.000.003.99142.53
Sanz, Julio, H,214044684.390.002181.560.002502.83
Cooper, Danielle, J,2584935.230.000.0035.230.00
Long, Isabella, C,23060126.930.000.000.00126.93
Bryant, Emma, E,185694.990.000.004.990.00
Jenkins, Samantha,113311329.310.000.00410.31919.00
Thompson, Joseph,2011478.980.000.000.0078.98
Madan, Tammy, K,19856144.470.000.000.00144.47
Gomez, Byron,24049574.980.000.000.00574.98
Jai, Christy, G,26979588.960.000.000.00588.96
Jones, Christopher, J,1451239.980.000.0039.980.00
Vazquez, Victor, R,29453742.350.000.000.00742.35
Gonzalez, Dominic, L,136937171.583578.270.000.003593.31
Schmidt, Meredith,2549938.980.000.000.0038.98
Prasad, Johnathan,2111225.480.000.000.0025.48
Arun, Henry, L,2717728.480.000.000.0028.48
Cai, Rafael, A,2944036.270.000.000.0036.27
Salah, Tamer, A,1263648.970.000.000.0048.97
Wang, Jorge, M,2782939.980.000.000.0039.98
Hall, Marcus,1356948.970.000.000.0048.97
Raman, Dominic,194431863.570.00699.101164.470.00
Jai, Jose,12944164.210.000.0039.99124.22
Mehta, Sergio,2692628.990.000.000.0028.99
James, Zoe, R,14611304.550.000.000.00304.55
Suarez, Deanna,1135422.970.000.000.0022.97
Van, Brenda, J,2489039.980.000.0039.980.00
Gill, Natasha, A,203889.990.000.000.009.99
Zhu, Jorge,2614178.980.000.0078.980.00
Gill, Alfredo, M,236292466.320.000.002466.320.00
Flores, Faith,188492366.960.000.000.002366.96
Green, Jenna, J,1152739.580.000.002.2937.29
Jones, Samuel, P,158967.280.000.000.007.28
Butler, Isabella, A,184372359.980.000.000.002359.98
Simmons, Dylan,16133164.820.000.0038.88125.94
Johnson, Joseph, L,2439336.590.000.0036.590.00
Richardson, Sebastian, C,2236532.280.000.0032.280.00
Alonso, Roberto, M,14533160.550.000.000.00160.55
Serrano, Audrey,183376021.620.003578.270.002443.35
Romero, Philip, F,221954909.670.000.002443.352466.32
Watson, Lauren, K,151987.280.000.007.280.00
Shen, Tamara, G,229353951.520.000.002181.561769.96
Stewart, Cole, L,135959390.530.002181.560.007208.97
Xu, Martha, C,163515873.263578.270.000.002294.99
Sanchez, Veronica, A,1245849.990.000.000.0049.99
Zhang, Gilbert, E,176304.990.000.004.990.00
Scott, Jenna, M,147401533.560.00699.100.00834.46
Gray, Devin,16584172.950.000.0039.98132.97
Munoz, Roberto,17628106.240.000.007.2898.96
Ward, Natalie, J,132412325.960.000.000.002325.96
Sanz, Ross,114558142.030.003374.992319.992447.05
Nath, Kenneth, W,170372334.970.000.000.002334.97
Taylor, David,159913127.250.000.00782.992344.26
Romero, Danny,268671728.270.000.000.001728.27
Pal, Dawn,209551164.470.000.000.001164.47
Serrano, Tanya,237501155.480.000.001155.480.00
Chen, Alan,135797295.043578.270.000.003716.77
Patterson, Isabel, M,22288561.480.000.00561.480.00
She, Corey, T,212144659.900.002181.560.002478.34
Beck, Barbara,265471407.960.000.00782.99624.97
Hernandez, Renee, C,178032761.020.000.002181.56579.46
Subram, Virginia,130362677.070.000.002049.10627.97
Hughes, Madison, J,144268319.300.003578.272384.072356.96
Moore, Christian, B,18916658.950.000.000.00658.95
Jai, Karla,18263126.940.000.0034.9991.95
Liu, Shannon, D,112507116.253399.990.002339.971376.29
Sai, Jay, A,234274.990.000.000.004.99
Romero, Ebony, A,2771712.940.000.000.0012.94
Mr., Rovira Diez, Pablo,2119042.280.000.0042.280.00
Lopez, Connor,2600032.270.000.000.0032.27
Henderson, Vanessa,135385908.253578.270.000.002329.98
Nath, Carly, J,172554442.243578.270.000.00863.97
Griffin, Luke,1386756.970.000.000.0056.97
Chander, Raul, D,181673405.410.000.001000.442404.97
Brown, Alyssa, O,2646827.280.000.0027.280.00
Alexander, Paige, W,1860459.250.000.0037.2721.98
Xie, Alisha, C,173684.990.000.004.990.00
Moore, Logan,2634889.970.000.0089.970.00
Watson, Hailey, I,1611913.980.000.0013.980.00
Xu, Kelli, T,2162877.960.000.000.0077.96
Long, Jose,1446096.460.000.000.0096.46
Kapoor, Roy,2245529.480.000.0029.480.00
Hughes, Noah, J,140053319.400.001000.440.002318.96
Lopez, Geoffrey, A,2945125.480.000.0025.480.00
Madan, Darren,2635562.980.000.000.0062.98
Sharma, Tonya, L,239146.280.000.000.006.28
Chande, Darrell,1163542.280.000.0039.992.29
Sandberg, Alexandria,119565873.260.003578.270.002294.99
Rodriguez, Megan, M,1162044.570.000.0042.282.29
Wilson, Alyssa,12897106.960.000.000.00106.96
Hall, Kaitlyn,11682252.980.000.000.00252.98
Sanchez, Sebastian,11736166.450.000.000.00166.45
Anderson, Taylor, A,158513198.460.000.00782.992415.47
Bell, Steven,155343199.440.000.00782.992416.45

Generated 2025-11-02 13:39:06.060 UTC