[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < TAKE 31 > TITLE Top 1000 Australian Internet customers for 2020
31 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2023 | 2024 | 2025 | 2026 |
|---|---|---|---|---|---|
| Lu, Curtis,11011 | 8133.04 | 3399.99 | 0.00 | 4733.05 | 0.00 |
| Watson, Alexandra, H,25249 | 1868.56 | 699.10 | 0.00 | 0.00 | 1169.46 |
| Raji, Misty,16520 | 4727.74 | 3578.27 | 0.00 | 1149.47 | 0.00 |
| Pal, Casey,16522 | 4698.76 | 3578.27 | 0.00 | 1120.49 | 0.00 |
| Arun, Cory, O,16527 | 4752.75 | 3578.27 | 0.00 | 1174.48 | 0.00 |
| Arthur, Tabitha, E,16482 | 4783.74 | 3578.27 | 0.00 | 1205.47 | 0.00 |
| Wang, Shannon,11017 | 6434.31 | 3374.99 | 0.00 | 2316.97 | 742.35 |
| Fernandez, Brenda, L,16493 | 4197.25 | 3578.27 | 0.00 | 0.00 | 618.98 |
| Ashe, Ebony, E,16612 | 5898.26 | 3578.27 | 0.00 | 0.00 | 2319.99 |
| Perez, Arthur, L,16526 | 4758.24 | 3578.27 | 0.00 | 1179.97 | 0.00 |
| Zhao, Jessie, R,11027 | 6591.57 | 3399.99 | 0.00 | 2412.96 | 778.62 |
| Rai, Clarence, D,11018 | 6533.28 | 3399.99 | 0.00 | 2341.97 | 791.32 |
| Lal, Dustin, A,16484 | 4175.53 | 3578.27 | 0.00 | 0.00 | 597.26 |
| Lal, Andres, L,16623 | 5973.24 | 3578.27 | 0.00 | 0.00 | 2394.97 |
| Moreno, Jimmy, L,11029 | 6565.29 | 3399.99 | 0.00 | 2408.97 | 756.33 |
| Thompson, Fernando,16350 | 5903.19 | 3578.27 | 0.00 | 0.00 | 2324.92 |
| Sai, Harold,11026 | 6575.79 | 3399.99 | 0.00 | 2399.47 | 776.33 |
| Stewart, Ariana,16743 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Gonzalez, Ebony,11034 | 6491.32 | 3399.99 | 0.00 | 0.00 | 3091.33 |
| Ortega, Jessie, J,17051 | 6060.50 | 3578.27 | 0.00 | 2482.23 | 0.00 |
| Arthur, Kristi, W,16675 | 4385.03 | 3578.27 | 0.00 | 806.76 | 0.00 |
| Romero, Lawrence, C,16687 | 6070.59 | 3578.27 | 0.00 | 2492.32 | 0.00 |
| Lu, Jaclyn, D,11047 | 6582.33 | 3399.99 | 0.00 | 0.00 | 3182.34 |
| Raje, Ashlee, E,16658 | 5873.26 | 3578.27 | 0.00 | 0.00 | 2294.99 |
| Martin, Marc, J,11039 | 6636.58 | 3399.99 | 0.00 | 0.00 | 3236.59 |
| She, Alvin, E,16657 | 5900.55 | 3578.27 | 0.00 | 0.00 | 2322.28 |
| Nelson, Sophia,16664 | 4377.75 | 3578.27 | 0.00 | 799.48 | 0.00 |
| Ye, Dennis, M,16638 | 5974.23 | 3578.27 | 0.00 | 0.00 | 2395.96 |
| Scott, Savannah, E,16929 | 4733.75 | 3578.27 | 0.00 | 1155.48 | 0.00 |
| Lopez, Heidi,11052 | 8131.32 | 3374.99 | 0.00 | 4756.33 | 0.00 |
| Stone, Denise,11032 | 6525.56 | 3374.99 | 0.00 | 0.00 | 3150.57 |
Generated 2026-07-21 19:16:24.778 UTC