[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 4 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zhu, Edwin,27148 | 78.98 | 0.00 | 0.00 | 0.00 | 78.98 |
| Sanchez, Lydia, S,12579 | 2589.09 | 0.00 | 0.00 | 2049.10 | 539.99 |
| Sanz, Eddie, A,19580 | 173.93 | 0.00 | 0.00 | 0.00 | 173.93 |
| Yuan, Kelsey, D,13034 | 94.71 | 0.00 | 0.00 | 0.00 | 94.71 |
| She, Jenny,27586 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Raje, Casey, A,14686 | 203.46 | 0.00 | 0.00 | 0.00 | 203.46 |
| Madan, Carla, D,28135 | 548.98 | 0.00 | 0.00 | 0.00 | 548.98 |
| Li, Trisha, A,18296 | 6117.69 | 0.00 | 3578.27 | 0.00 | 2539.42 |
| Dominguez, Ebony, R,17350 | 127.47 | 0.00 | 0.00 | 0.00 | 127.47 |
| Carlson, Joy,13981 | 124.21 | 0.00 | 0.00 | 0.00 | 124.21 |
| Tang, Cristina, D,19623 | 153.93 | 0.00 | 0.00 | 0.00 | 153.93 |
| Subram, Virginia,13036 | 2677.07 | 0.00 | 0.00 | 2049.10 | 627.97 |
| Torres, Sabrina, E,20425 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Zimmerman, Jenny,18197 | 30.97 | 0.00 | 0.00 | 0.00 | 30.97 |
Generated 2025-12-24 06:18:39.427 UTC