[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 80 > < TAKE 6 >
6 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhang, Glenn, A,13967 | 5721.91 | 0.00 | 0.00 | 2049.10 | 3672.81 |
| Gonzalez, Savannah, F,15644 | 3803.68 | 0.00 | 0.00 | 2071.42 | 1732.26 |
| Garcia, Brandy,26028 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Sharma, Edwin, K,25021 | 1554.41 | 0.00 | 0.00 | 1000.44 | 553.97 |
| Pal, Lacey, K,26571 | 1938.47 | 0.00 | 0.00 | 782.99 | 1155.48 |
| Patel, Pamela, G,27875 | 1268.84 | 0.00 | 0.00 | 0.00 | 1268.84 |
Generated 2025-12-22 03:18:10.529 UTC