[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 31 > < TAKE 8 >
8 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Munoz, Briana,23437 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Chandra, Gerald,25131 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Fernandez, Ross, R,11763 | 76.65 | 0.00 | 0.00 | 24.49 | 52.16 |
| Moore, Natalie, W,18273 | 6104.21 | 0.00 | 3578.27 | 0.00 | 2525.94 |
| Tang, Rafael, A,11908 | 8079.05 | 0.00 | 3374.99 | 0.00 | 4704.06 |
| Alonso, Gloria, S,19964 | 6056.61 | 0.00 | 3578.27 | 0.00 | 2478.34 |
| Zhang, Jenny, H,24609 | 2120.93 | 0.00 | 0.00 | 2120.93 | 0.00 |
| Zhang, James,14684 | 38.55 | 0.00 | 0.00 | 0.00 | 38.55 |
Generated 2025-12-23 07:25:38.845 UTC