[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 19 > < TAKE 6 >
6 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Ramos, Marc,18212 | 6029.57 | 0.00 | 3578.27 | 2451.30 | 0.00 |
| Dominguez, Raquel, A,27470 | 1371.95 | 0.00 | 0.00 | 782.99 | 588.96 |
| Campbell, Jason, J,13625 | 6962.14 | 0.00 | 0.00 | 2049.10 | 4913.04 |
| Kim, Kari, S,11445 | 8098.03 | 0.00 | 3399.99 | 2304.98 | 2393.06 |
| Jimenez, Jill,11028 | 6474.62 | 3374.99 | 0.00 | 0.00 | 3099.63 |
| Arthur, Cassandra, M,22410 | 2983.34 | 0.00 | 0.00 | 2443.35 | 539.99 |
Generated 2025-12-22 00:43:11.876 UTC