[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < ORDER BY 2020 < TAKE 125 > TITLE Top 1000 Australian Internet customers for 2020
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Brown, Edward,27621 | 5971.33 | 3578.27 | 0.00 | 0.00 | 2393.06 |
| Wu, Karen,21353 | 44.98 | 0.00 | 0.00 | 0.00 | 44.98 |
| Brown, Emma, W,27616 | 5998.61 | 3578.27 | 0.00 | 0.00 | 2420.34 |
| Cooper, Jennifer, S,11187 | 107.48 | 0.00 | 0.00 | 0.00 | 107.48 |
| Flores, Alexia, D,14896 | 1588.57 | 0.00 | 699.10 | 0.00 | 889.47 |
| Rogers, Sydney, C,27601 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Young, Mary, C,17689 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Bailey, Jesse, A,18061 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Xu, Bonnie, C,14520 | 1503.58 | 699.10 | 0.00 | 0.00 | 804.48 |
| Huang, Kelvin,14560 | 1538.58 | 699.10 | 0.00 | 0.00 | 839.48 |
| Martinez, Jeremiah, D,27671 | 5997.33 | 3578.27 | 0.00 | 0.00 | 2419.06 |
| Chande, Dustin,18786 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Baker, Jeremy,23471 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| Green, Carlos,18387 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Blanco, Nelson,23718 | 567.76 | 0.00 | 0.00 | 0.00 | 567.76 |
| Washington, Ashley,14559 | 1547.57 | 699.10 | 0.00 | 0.00 | 848.47 |
| Butler, Tristan,25865 | 4643.83 | 3374.99 | 0.00 | 0.00 | 1268.84 |
| Henderson, Maria, E,27615 | 5998.61 | 3578.27 | 0.00 | 0.00 | 2420.34 |
| Zheng, Bianca, G,27662 | 5997.33 | 3578.27 | 0.00 | 0.00 | 2419.06 |
| Nath, Brendan, C,22380 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Yuan, Donna, D,29434 | 77.96 | 0.00 | 0.00 | 0.00 | 77.96 |
| Truempy, Marcel,14558 | 1528.07 | 699.10 | 0.00 | 0.00 | 828.97 |
| Zhou, Brittney, K,24148 | 11.94 | 0.00 | 0.00 | 0.00 | 11.94 |
| Ross, Dylan, D,27988 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Price, Angela, D,19714 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Wood, Amanda, S,28068 | 6021.82 | 3578.27 | 0.00 | 0.00 | 2443.55 |
| Bennett, Cassidy, A,16951 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| Mitchell, Jack, L,28040 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Powell, Riley, M,22350 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Pal, Karla, A,25840 | 1249.84 | 0.00 | 0.00 | 0.00 | 1249.84 |
| Lee, Xavier, E,28039 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Turner, Gabrielle, A,28063 | 6026.31 | 3578.27 | 0.00 | 0.00 | 2448.04 |
| Martin, Christopher, B,28017 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Morgan, Maria,12941 | 4818.33 | 0.00 | 2443.35 | 0.00 | 2374.98 |
| Hughes, Rachel, R,15401 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Jackson, Olivia,27681 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Murphy, Jesse,11040 | 2350.96 | 0.00 | 0.00 | 0.00 | 2350.96 |
| Rai, Shawna, E,23898 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Ross, Samantha, R,27918 | 5998.61 | 3578.27 | 0.00 | 0.00 | 2420.34 |
| Lopez, Kyle,28061 | 6006.32 | 3578.27 | 0.00 | 0.00 | 2428.05 |
| King, Noah,25876 | 4629.07 | 3374.99 | 0.00 | 0.00 | 1254.08 |
| Lewis, Jessica, W,25868 | 5798.04 | 3399.99 | 0.00 | 0.00 | 2398.05 |
| Navarro, Craig,15357 | 7232.37 | 0.00 | 2443.35 | 0.00 | 4789.02 |
| Nath, Tamara,28064 | 5962.34 | 3578.27 | 0.00 | 0.00 | 2384.07 |
| Cai, Lisa,11241 | 11469.19 | 0.00 | 0.00 | 4379.08 | 7090.11 |
| Howard, Bryce, E,16108 | 633.96 | 0.00 | 0.00 | 0.00 | 633.96 |
| Harris, Rachel,16753 | 2319.99 | 0.00 | 0.00 | 0.00 | 2319.99 |
| Foster, Anna, A,11646 | 113.48 | 0.00 | 0.00 | 0.00 | 113.48 |
| Carter, Carlos, A,25867 | 5784.06 | 3399.99 | 0.00 | 0.00 | 2384.07 |
| Mehta, Francisco, K,17982 | 839.46 | 0.00 | 0.00 | 0.00 | 839.46 |
| Gonzalez, Robert,24289 | 32.60 | 0.00 | 0.00 | 0.00 | 32.60 |
| Harris, Kaitlyn,24927 | 191.27 | 0.00 | 0.00 | 0.00 | 191.27 |
| Zhu, Todd, G,28131 | 6011.31 | 3578.27 | 0.00 | 0.00 | 2433.04 |
| Turner, Fernando,28182 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Smith, Christopher, E,21233 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Alexander, Eric, S,28185 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Garcia, Lauren, D,23407 | 561.48 | 0.00 | 0.00 | 0.00 | 561.48 |
| Stewart, Nicole, A,20129 | 119.98 | 0.00 | 0.00 | 0.00 | 119.98 |
| Hayes, Alexandria, C,27474 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Howard, Nicole, M,28183 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Evans, Savannah, K,28112 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Edwards, Morgan, D,25888 | 4623.82 | 3374.99 | 0.00 | 0.00 | 1248.83 |
| Raji, Gilbert,23191 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Ortega, Erika, P,20878 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Coleman, Gabrielle,28164 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Stewart, Alexandra, S,28096 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Foster, Spencer, J,21612 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Yang, Tamara, R,28159 | 5978.61 | 3578.27 | 0.00 | 0.00 | 2400.34 |
| Martin, Matthew, F,26267 | 21.49 | 0.00 | 0.00 | 0.00 | 21.49 |
| Diaz, Kyle,14580 | 1468.59 | 699.10 | 0.00 | 0.00 | 769.49 |
| Wood, Alyssa, S,25879 | 4658.82 | 3399.99 | 0.00 | 0.00 | 1258.83 |
| Martinez, Ronald, J,23517 | 78.96 | 0.00 | 0.00 | 0.00 | 78.96 |
| Johnson, Isabella, P,28170 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Alvarez, Jonathon, D,12752 | 156.25 | 0.00 | 0.00 | 0.00 | 156.25 |
| Watson, Taylor,28155 | 5962.34 | 3578.27 | 0.00 | 0.00 | 2384.07 |
| Washington, Rachel,28163 | 3578.27 | 3578.27 | 0.00 | 0.00 | 0.00 |
| Ray, Regina, B,25142 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Ye, Karen, L,25476 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Turner, Jesse,28099 | 6021.82 | 3578.27 | 0.00 | 0.00 | 2443.55 |
| Zhang, Jason, L,12796 | 71.97 | 0.00 | 0.00 | 0.00 | 71.97 |
| Black, Omar,28147 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Yang, Brent,26847 | 60.47 | 0.00 | 0.00 | 0.00 | 60.47 |
| Murphy, Sara, M,12926 | 4795.31 | 0.00 | 2443.35 | 0.00 | 2351.96 |
| Hayes, Nathan, K,25905 | 4598.83 | 0.00 | 3374.99 | 0.00 | 1223.84 |
| Shan, Nicolas, A,28544 | 33.98 | 0.00 | 0.00 | 0.00 | 33.98 |
| Sai, Mayra, E,20897 | 88.97 | 0.00 | 0.00 | 0.00 | 88.97 |
| Davis, Samantha, P,28244 | 6026.31 | 0.00 | 3578.27 | 0.00 | 2448.04 |
| Zheng, Susan, K,24719 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Washington, Madison,20059 | 1170.48 | 0.00 | 0.00 | 0.00 | 1170.48 |
| Xie, Leonard, M,23226 | 588.96 | 0.00 | 0.00 | 0.00 | 588.96 |
| Rai, Marshall, A,25903 | 5773.04 | 0.00 | 3374.99 | 0.00 | 2398.05 |
| Butler, Thomas, C,28296 | 5997.33 | 0.00 | 3578.27 | 0.00 | 2419.06 |
| Brooks, Julia, W,11949 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Butler, Hailey, D,19865 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Gray, Alexa,28246 | 5976.32 | 0.00 | 3578.27 | 0.00 | 2398.05 |
| Russell, Kelly, E,19981 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Liu, Laura,19998 | 1155.48 | 0.00 | 0.00 | 0.00 | 1155.48 |
| Rana, Carmen, A,14940 | 8367.55 | 0.00 | 3578.27 | 2419.06 | 2370.22 |
| Butler, Lucas,28340 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Adams, Lucas,18559 | 1735.98 | 0.00 | 0.00 | 0.00 | 1735.98 |
| White, Ian, M,11649 | 91.28 | 0.00 | 0.00 | 0.00 | 91.28 |
| Cooper, Isaac, I,28809 | 24.99 | 0.00 | 0.00 | 0.00 | 24.99 |
| Cox, Shelby, V,28293 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Sanders, Makayla,21761 | 134.98 | 0.00 | 0.00 | 0.00 | 134.98 |
| Wood, Xavier,23732 | 74.45 | 0.00 | 0.00 | 0.00 | 74.45 |
| Rai, Nicolas, A,14601 | 3076.06 | 0.00 | 699.10 | 0.00 | 2376.96 |
| Long, Kyle,25917 | 4699.82 | 0.00 | 3399.99 | 0.00 | 1299.83 |
| Munoz, Janet,11439 | 12489.17 | 0.00 | 0.00 | 10070.11 | 2419.06 |
| Gill, Lance,12614 | 5918.24 | 0.00 | 3578.27 | 0.00 | 2339.97 |
| Russell, Gabrielle, J,28671 | 4320.62 | 0.00 | 3578.27 | 742.35 | 0.00 |
| Schmidt, Stanley, C,19035 | 3320.43 | 0.00 | 0.00 | 1000.44 | 2319.99 |
| Henderson, Taylor, M,19051 | 3104.57 | 0.00 | 699.10 | 0.00 | 2405.47 |
| Nara, Peter, T,11770 | 77.27 | 0.00 | 0.00 | 0.00 | 77.27 |
| Smith, Devin, T,28655 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Patel, Donald, M,15921 | 6549.29 | 0.00 | 0.00 | 2443.35 | 4105.94 |
| Serrano, Naomi,25916 | 4649.83 | 0.00 | 3399.99 | 0.00 | 1249.84 |
| Raji, Tonya,24804 | 2384.07 | 0.00 | 0.00 | 0.00 | 2384.07 |
| Cox, Sean, J,26086 | 149.98 | 0.00 | 0.00 | 0.00 | 149.98 |
| Pal, Mohamed, C,28763 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Cai, Alisha,19775 | 1183.47 | 0.00 | 0.00 | 0.00 | 1183.47 |
| Collins, Sara, P,26478 | 49.48 | 0.00 | 0.00 | 0.00 | 49.48 |
| Gray, Xavier,28643 | 3578.27 | 0.00 | 3578.27 | 0.00 | 0.00 |
| Russell, Alexia,19742 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Rana, Francisco,19754 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Lal, Chad, S,25725 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
Generated 2025-11-02 13:39:32.858 UTC