[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount ORDER BY 2020 DESC > < SKIP 125 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Li, Margaret,15753 | 4399.08 | 0.00 | 0.00 | 2049.10 | 2349.98 |
| Alonso, Diana, L,24590 | 3911.53 | 0.00 | 0.00 | 2181.56 | 1729.97 |
| Sun, Dennis, K,24481 | 4179.33 | 0.00 | 0.00 | 2443.35 | 1735.98 |
| Navarro, Eddie, C,24504 | 3563.84 | 0.00 | 0.00 | 2443.35 | 1120.49 |
| Wang, Roger, P,24605 | 3627.81 | 0.00 | 0.00 | 3627.81 | 0.00 |
| Vazquez, Rebekah, A,15784 | 4379.09 | 0.00 | 0.00 | 2049.10 | 2329.99 |
| Deng, Jodi,16161 | 2700.05 | 0.00 | 0.00 | 2049.10 | 650.95 |
| Ma, Laura, L,24503 | 3617.83 | 0.00 | 0.00 | 2443.35 | 1174.48 |
| Liang, Amy,16164 | 2639.08 | 0.00 | 0.00 | 2049.10 | 589.98 |
| Patel, Monica, J,25234 | 2174.92 | 0.00 | 0.00 | 1000.44 | 1174.48 |
| Goldberg, Mindy,16159 | 4411.65 | 0.00 | 0.00 | 2071.42 | 2340.23 |
| Sun, Suzanne, P,24587 | 3882.55 | 0.00 | 0.00 | 2181.56 | 1700.99 |
| Ma, Franklin,24485 | 3356.04 | 0.00 | 0.00 | 2181.56 | 1174.48 |
| Rana, Ross,25240 | 2120.93 | 0.00 | 0.00 | 1000.44 | 1120.49 |
| Kumar, Bridget,15802 | 4444.07 | 0.00 | 0.00 | 2049.10 | 2394.97 |
Generated 2025-11-06 20:04:16.888 UTC