[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE SKIP 0 > < TAKE 8 >
8 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Sai, Cesar,18243 | 6058.21 | 0.00 | 3578.27 | 2479.94 | 0.00 |
| Suri, Jarrod, E,12004 | 8114.04 | 0.00 | 3374.99 | 0.00 | 4739.05 |
| Rodriguez, Pamela,29065 | 777.34 | 0.00 | 0.00 | 0.00 | 777.34 |
| Stone, Denise,11032 | 6525.56 | 0.00 | 3374.99 | 0.00 | 3150.57 |
| Liang, Martha,16525 | 4752.75 | 3578.27 | 0.00 | 0.00 | 1174.48 |
| Jimenez, Gary, E,16609 | 344.04 | 0.00 | 0.00 | 84.95 | 259.09 |
| Vazquez, Hector, E,19772 | 6030.61 | 0.00 | 3578.27 | 0.00 | 2452.34 |
| Simmons, Gabrielle,29183 | 2393.06 | 0.00 | 0.00 | 0.00 | 2393.06 |
Generated 2025-12-21 23:18:24.845 UTC