[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1093 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Madan, Jarrod, C,21555 | 4715.49 | 0.00 | 0.00 | 2181.56 | 2533.93 |
| Liang, Randy, E,28958 | 14.98 | 0.00 | 0.00 | 0.00 | 14.98 |
| Mehta, Ann, M,14518 | 126.95 | 0.00 | 0.00 | 0.00 | 126.95 |
| Jimenez, Melody, S,14066 | 3612.19 | 0.00 | 0.00 | 2853.57 | 758.62 |
| Vazquez, Jimmy, D,12348 | 6906.09 | 0.00 | 2049.10 | 0.00 | 4856.99 |
| Davis, Isabella, A,22929 | 4673.88 | 0.00 | 0.00 | 2181.56 | 2492.32 |
| Shan, Sheena, J,21565 | 48.98 | 0.00 | 0.00 | 0.00 | 48.98 |
| Chavez, Clayton,21949 | 4659.90 | 0.00 | 0.00 | 2181.56 | 2478.34 |
| Liu, Dawn, C,21960 | 39.99 | 0.00 | 0.00 | 0.00 | 39.99 |
| Romero, Philip, F,22195 | 4909.67 | 0.00 | 0.00 | 2443.35 | 2466.32 |
| Lin, Claudia, A,14312 | 191.27 | 0.00 | 0.00 | 0.00 | 191.27 |
| Li, Ramon,21248 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Lu, Curtis,11011 | 8133.04 | 3399.99 | 0.00 | 2294.99 | 2438.06 |
| Chande, Katrina, L,19968 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| Flores, Miranda,17243 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
Generated 2025-12-22 06:03:28.207 UTC