[ROOT] dt FactInternetSale < WHERE DimCurrency.AlternateKey EQ 'USD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 125 > TITLE Top 1000 Australian Internet customers for 2020
125 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Chander, Tamara, L,11741 | 6079.24 | 0.00 | 3578.27 | 2500.97 | 0.00 |
| Munoz, Marc, W,27774 | 771.34 | 0.00 | 0.00 | 771.34 | 0.00 |
| Martin, Jarred,27777 | 778.62 | 0.00 | 0.00 | 778.62 | 0.00 |
| Gill, Raquel, T,17217 | 80.96 | 0.00 | 0.00 | 0.00 | 80.96 |
| Tang, Donna, S,20554 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Sanchez, Savannah,12927 | 108.46 | 0.00 | 0.00 | 0.00 | 108.46 |
| Scott, Lucas, L,11866 | 42.95 | 0.00 | 0.00 | 7.95 | 35.00 |
| Bryant, Vanessa,12929 | 4820.31 | 0.00 | 2443.35 | 0.00 | 2376.96 |
| Perry, Stephanie,28599 | 7.95 | 0.00 | 0.00 | 0.00 | 7.95 |
| Blue, Paige,20326 | 128.97 | 0.00 | 0.00 | 0.00 | 128.97 |
| Wang, Hunter,20699 | 1209.47 | 0.00 | 0.00 | 0.00 | 1209.47 |
| Ross, Isabel,27379 | 152.47 | 0.00 | 0.00 | 0.00 | 152.47 |
| Garcia, Jeremiah,26798 | 28.99 | 0.00 | 0.00 | 0.00 | 28.99 |
| Gill, Arthur,26689 | 96.92 | 0.00 | 0.00 | 0.00 | 96.92 |
| Cooper, Sebastian, A,17599 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| Henderson, Eric,13457 | 56.97 | 0.00 | 0.00 | 0.00 | 56.97 |
| Liu, Alisha, L,23764 | 2457.33 | 0.00 | 0.00 | 2457.33 | 0.00 |
| Weber, Cindy,22448 | 2479.94 | 0.00 | 0.00 | 2479.94 | 0.00 |
| Jackson, Alexander, R,28793 | 24.99 | 0.00 | 0.00 | 24.99 | 0.00 |
| Coleman, Grace, J,28032 | 75.47 | 0.00 | 0.00 | 75.47 | 0.00 |
| Guo, Amy, A,15301 | 15.23 | 0.00 | 0.00 | 15.23 | 0.00 |
| Morris, Maria, K,16254 | 24.99 | 0.00 | 0.00 | 24.99 | 0.00 |
| Yuan, Tara, G,22795 | 67.97 | 0.00 | 0.00 | 67.97 | 0.00 |
| Xu, Kenneth,12646 | 13.98 | 0.00 | 0.00 | 4.99 | 8.99 |
| Anderson, Hannah, C,11883 | 77.27 | 0.00 | 0.00 | 42.28 | 34.99 |
| Luo, Jon,11298 | 5922.23 | 0.00 | 3578.27 | 2343.96 | 0.00 |
| Li, Cameron,25902 | 64.97 | 0.00 | 0.00 | 64.97 | 0.00 |
| Coleman, Alyssa, C,15366 | 59.98 | 0.00 | 0.00 | 59.98 | 0.00 |
| Davis, Rachel, T,14404 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Griffin, Jocelyn,23623 | 3.99 | 0.00 | 0.00 | 3.99 | 0.00 |
| Simmons, Kaitlyn,28845 | 4320.62 | 0.00 | 3578.27 | 0.00 | 742.35 |
| Dominguez, Anne,13258 | 5308.26 | 0.00 | 0.00 | 0.00 | 5308.26 |
| Lin, Alvin,24140 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Rubio, Theresa,21743 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Perry, Jack,23389 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Carlson, Victor,14425 | 8332.30 | 0.00 | 3578.27 | 2419.06 | 2334.97 |
| Edwards, Samuel,12024 | 83.97 | 0.00 | 0.00 | 8.99 | 74.98 |
| Sharma, Mindy,21350 | 69.97 | 0.00 | 0.00 | 69.97 | 0.00 |
| Adams, Jordan, F,16377 | 13.98 | 0.00 | 0.00 | 13.98 | 0.00 |
| Carlson, Tabitha,14688 | 74.98 | 0.00 | 0.00 | 74.98 | 0.00 |
| Vance, Rachael,26899 | 23.78 | 0.00 | 0.00 | 23.78 | 0.00 |
| Malhotra, Don, S,25472 | 27.77 | 0.00 | 0.00 | 0.00 | 27.77 |
| Suarez, Armando,28430 | 42.97 | 0.00 | 0.00 | 0.00 | 42.97 |
| Madan, Meredith, D,12591 | 49.97 | 0.00 | 0.00 | 0.00 | 49.97 |
| Mr., Simpson, Marty, E.,26292 | 4456.14 | 0.00 | 2049.10 | 0.00 | 2407.04 |
| Yuan, Tommy, L,17940 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| James, Jacqueline, L,17209 | 7182.40 | 0.00 | 0.00 | 2443.35 | 4739.05 |
| Jordan, Stefanie,22676 | 28.99 | 0.00 | 0.00 | 28.99 | 0.00 |
| Patterson, Blake,11889 | 50.23 | 0.00 | 0.00 | 50.23 | 0.00 |
| Lin, Colin,11255 | 113.96 | 0.00 | 0.00 | 74.98 | 38.98 |
| Coleman, Julia,11303 | 5875.55 | 0.00 | 3578.27 | 2297.28 | 0.00 |
| Sun, Amy, C,11421 | 9780.04 | 0.00 | 3399.99 | 2294.99 | 4085.06 |
| He, Heather, G,22449 | 2514.93 | 0.00 | 0.00 | 2514.93 | 0.00 |
| Adams, Maria, N,22734 | 73.96 | 0.00 | 0.00 | 73.96 | 0.00 |
| Rogers, Chloe, M,20439 | 14.98 | 0.00 | 0.00 | 14.98 | 0.00 |
| Powell, Marcus, A,20366 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Bryant, Benjamin, E,14909 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Martinez, Cesar,23981 | 33.98 | 0.00 | 0.00 | 33.98 | 0.00 |
| Sharma, Deborah, R,13497 | 39.98 | 0.00 | 0.00 | 39.98 | 0.00 |
| Gray, Sydney, K,11735 | 109.97 | 0.00 | 0.00 | 74.98 | 34.99 |
| Long, Edward, H,12062 | 87.28 | 0.00 | 0.00 | 37.29 | 49.99 |
| Bailey, Jade, E,11319 | 5930.23 | 0.00 | 3578.27 | 2351.96 | 0.00 |
| Clark, Chloe, K,24340 | 2393.06 | 0.00 | 0.00 | 2393.06 | 0.00 |
| Jones, Wyatt, M,24341 | 2453.04 | 0.00 | 0.00 | 2453.04 | 0.00 |
| Peterson, Grace, Y,22329 | 574.98 | 0.00 | 0.00 | 574.98 | 0.00 |
| Liang, Tamara, L,11087 | 200.28 | 0.00 | 0.00 | 162.99 | 37.29 |
| Goel, Kate,21783 | 49.97 | 0.00 | 0.00 | 49.97 | 0.00 |
| Roberts, James,23757 | 38.98 | 0.00 | 0.00 | 0.00 | 38.98 |
| Cai, Tamara,19744 | 1179.47 | 0.00 | 0.00 | 0.00 | 1179.47 |
| Garcia, Allen, F,13259 | 4275.22 | 0.00 | 0.00 | 0.00 | 4275.22 |
| Rogers, Nathaniel, J,18473 | 127.28 | 0.00 | 0.00 | 0.00 | 127.28 |
| Cox, Ariana, B,15270 | 39.98 | 0.00 | 0.00 | 0.00 | 39.98 |
| Sai, Brett,19251 | 27.28 | 0.00 | 0.00 | 0.00 | 27.28 |
| Zhu, Ronnie, M,25316 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Cooper, Carlos, S,17608 | 1700.99 | 0.00 | 0.00 | 0.00 | 1700.99 |
| Malhotra, Molly,24551 | 142.45 | 0.00 | 0.00 | 142.45 | 0.00 |
| Gray, Ian, A,11193 | 41.28 | 0.00 | 0.00 | 35.00 | 6.28 |
| Hernandez, Jennifer,24436 | 2438.06 | 0.00 | 0.00 | 2438.06 | 0.00 |
| Kelly, Jared, J,19429 | 1854.58 | 0.00 | 699.10 | 1155.48 | 0.00 |
| Raji, Clarence, A,14733 | 1854.58 | 0.00 | 699.10 | 1155.48 | 0.00 |
| Jackson, Hunter,12168 | 72.88 | 0.00 | 0.00 | 7.95 | 64.93 |
| Bennett, Sydney,11014 | 138.45 | 0.00 | 0.00 | 38.98 | 99.47 |
| West, Jasmine, L,28871 | 4414.59 | 0.00 | 3578.27 | 0.00 | 836.32 |
| Carter, Charles, R,22899 | 600.46 | 0.00 | 0.00 | 0.00 | 600.46 |
| She, Brad,12307 | 9594.92 | 0.00 | 0.00 | 2443.35 | 7151.57 |
| James, Ariana,23282 | 37.27 | 0.00 | 0.00 | 0.00 | 37.27 |
| Jimenez, Kristy, E,23299 | 29.99 | 0.00 | 0.00 | 29.99 | 0.00 |
| Young, Sara,19860 | 132.97 | 0.00 | 0.00 | 132.97 | 0.00 |
| Richardson, Isabella, F,13933 | 56.97 | 0.00 | 0.00 | 56.97 | 0.00 |
| Martinez, Jacob,16224 | 556.26 | 0.00 | 0.00 | 556.26 | 0.00 |
| Barnes, Caroline,11973 | 88.96 | 0.00 | 0.00 | 88.96 | 0.00 |
| Wood, Kayla, L,27565 | 33.43 | 0.00 | 0.00 | 33.43 | 0.00 |
| Bennett, Julia,23577 | 94.46 | 0.00 | 0.00 | 94.46 | 0.00 |
| Bryant, Jack, D,15940 | 7.28 | 0.00 | 0.00 | 7.28 | 0.00 |
| Alvarez, Victor,18022 | 63.97 | 0.00 | 0.00 | 63.97 | 0.00 |
| Powell, Brianna, L,15570 | 1344.96 | 0.00 | 0.00 | 1344.96 | 0.00 |
| Coleman, Gavin,24527 | 2419.06 | 0.00 | 0.00 | 2419.06 | 0.00 |
| Edwards, Caleb,21610 | 548.98 | 0.00 | 0.00 | 548.98 | 0.00 |
| Blanco, Lance, M,13255 | 7393.06 | 0.00 | 0.00 | 2638.06 | 4755.00 |
| Wagner, Ronnie,16513 | 4669.45 | 0.00 | 0.00 | 2181.56 | 2487.89 |
| Raman, Troy,21164 | 68.97 | 0.00 | 0.00 | 0.00 | 68.97 |
| Adams, Jesse, M,17172 | 68.49 | 0.00 | 0.00 | 0.00 | 68.49 |
| Robinson, Katherine,15483 | 3120.26 | 0.00 | 0.00 | 782.99 | 2337.27 |
| Sanders, Dalton,24739 | 2453.04 | 0.00 | 0.00 | 0.00 | 2453.04 |
| Javier Castrejón, Francisco,20497 | 69.99 | 0.00 | 0.00 | 69.99 | 0.00 |
| Smith, Taylor,18816 | 148.47 | 0.00 | 0.00 | 148.47 | 0.00 |
| Mr., Robinett, David, R.,11377 | 83.97 | 0.00 | 0.00 | 83.97 | 0.00 |
| Allen, Sydney, K,13363 | 71.97 | 0.00 | 0.00 | 71.97 | 0.00 |
| Gray, Chase, J,15688 | 6221.52 | 0.00 | 0.00 | 3882.55 | 2338.97 |
| Deng, Tony,27309 | 2457.33 | 0.00 | 0.00 | 2457.33 | 0.00 |
| White, Alexander, D,20487 | 9.99 | 0.00 | 0.00 | 0.00 | 9.99 |
| King, Richard,13549 | 94.48 | 0.00 | 0.00 | 0.00 | 94.48 |
| Hughes, Jeremiah, C,19161 | 584.90 | 0.00 | 0.00 | 0.00 | 584.90 |
| Turner, Xavier,14343 | 1839.92 | 0.00 | 0.00 | 1000.44 | 839.48 |
| Li, Jose, K,11725 | 123.91 | 0.00 | 0.00 | 0.00 | 123.91 |
| Perez, Jay, M,18624 | 29.99 | 0.00 | 0.00 | 29.99 | 0.00 |
| Thompson, Elizabeth, W,11864 | 47.94 | 0.00 | 0.00 | 39.99 | 7.95 |
| Butler, Noah, E,12164 | 5908.26 | 0.00 | 3578.27 | 2329.99 | 0.00 |
| Peterson, Nathaniel, R,28082 | 60.47 | 0.00 | 0.00 | 60.47 | 0.00 |
| Stewart, Carlos, E,27995 | 4.99 | 0.00 | 0.00 | 4.99 | 0.00 |
| Serrano, Lance,23355 | 603.49 | 0.00 | 0.00 | 0.00 | 603.49 |
| Anand, Arturo,22626 | 565.47 | 0.00 | 0.00 | 0.00 | 565.47 |
| Rubio, Alfredo, D,17929 | 3896.53 | 0.00 | 0.00 | 2181.56 | 1714.97 |
| Sharma, Shaun, L,14148 | 4406.74 | 0.00 | 3578.27 | 0.00 | 828.47 |
| Gonzales, Oscar, H,27481 | 58.47 | 0.00 | 0.00 | 0.00 | 58.47 |
Generated 2025-11-03 01:20:25.844 UTC