[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 71 > < TAKE 14 >
14 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Gill, Dwayne, A,19675 | 198.99 | 0.00 | 0.00 | 0.00 | 198.99 |
| Rubio, Jay,15179 | 4444.89 | 0.00 | 0.00 | 2071.42 | 2373.47 |
| Srini, Cindy, E,26026 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Zhu, Amy, W,26664 | 123.98 | 0.00 | 0.00 | 0.00 | 123.98 |
| Raman, Deanna, H,17053 | 123.96 | 0.00 | 0.00 | 0.00 | 123.96 |
| Chen, Willie, C,28322 | 29.48 | 0.00 | 0.00 | 0.00 | 29.48 |
| Malhotra, Joel, E,16343 | 58.25 | 0.00 | 0.00 | 0.00 | 58.25 |
| Thompson, Fernando,16350 | 5903.19 | 3578.27 | 0.00 | 0.00 | 2324.92 |
| Lal, Mitchell, C,20403 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Zheng, Randy, B,22574 | 69.99 | 0.00 | 0.00 | 0.00 | 69.99 |
| Goel, Misty, M,18245 | 6021.62 | 0.00 | 3578.27 | 0.00 | 2443.35 |
| She, Jenny,27586 | 1120.49 | 0.00 | 0.00 | 0.00 | 1120.49 |
| Ma, Autumn,20994 | 4191.72 | 0.00 | 3578.27 | 0.00 | 613.45 |
| Vazquez, Joe, C,20418 | 4207.24 | 0.00 | 3578.27 | 0.00 | 628.97 |
Generated 2025-12-21 16:03:48.088 UTC