[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 73 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Raje, April, R,18744 | 32.22 | 0.00 | 0.00 | 0.00 | 32.22 |
| Serrano, Deanna, W,15144 | 4344.09 | 0.00 | 0.00 | 2049.10 | 2294.99 |
| Alvarez, Rodney, D,29286 | 13.98 | 0.00 | 0.00 | 0.00 | 13.98 |
| She, Mindy, J,13009 | 168.67 | 0.00 | 0.00 | 0.00 | 168.67 |
| Raji, Karl,29103 | 2419.06 | 0.00 | 0.00 | 0.00 | 2419.06 |
| Fernandez, George,19974 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Malhotra, Heidi, A,26426 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Lin, Darryl, J,15031 | 41.27 | 0.00 | 0.00 | 0.00 | 41.27 |
| Chen, Bianca,24891 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Perez, Bryant, L,15042 | 3807.40 | 0.00 | 0.00 | 2071.42 | 1735.98 |
| Zhao, Randy, J,27874 | 1288.31 | 0.00 | 0.00 | 0.00 | 1288.31 |
| Mehta, Carla, L,21563 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Chander, Brad, K,21382 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Yuan, Warren, P,19091 | 2.29 | 0.00 | 0.00 | 0.00 | 2.29 |
Generated 2025-12-21 17:20:55.704 UTC