[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 749 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Guo, Clarence,20265 | 32.28 | 0.00 | 0.00 | 0.00 | 32.28 |
| Raje, Karla,28936 | 7.28 | 0.00 | 0.00 | 0.00 | 7.28 |
| Rubio, Kathleen, A,20820 | 4143.74 | 0.00 | 3578.27 | 0.00 | 565.47 |
| Madan, Raymond, W,20819 | 4181.76 | 0.00 | 3578.27 | 0.00 | 603.49 |
| Carlson, Orlando, J,11893 | 8123.03 | 0.00 | 3374.99 | 0.00 | 4748.04 |
| Diaz, Tyrone,13116 | 230.25 | 0.00 | 0.00 | 0.00 | 230.25 |
| Diaz, Kellie, A,18330 | 34.98 | 0.00 | 0.00 | 0.00 | 34.98 |
| Butler, Katherine, F,26760 | 1322.98 | 0.00 | 0.00 | 782.99 | 539.99 |
| Fernandez, Holly, M,12675 | 6812.77 | 0.00 | 0.00 | 2071.42 | 4741.35 |
| Raji, Kate, L,11903 | 8108.04 | 0.00 | 3374.99 | 0.00 | 4733.05 |
| Sai, Tina, L,15425 | 3772.41 | 0.00 | 0.00 | 2071.42 | 1700.99 |
| Zeng, Jon, O,14310 | 5200.66 | 0.00 | 0.00 | 2071.42 | 3129.24 |
| Rodriguez, Geoffrey,20817 | 4118.26 | 0.00 | 3578.27 | 0.00 | 539.99 |
| Powell, Rachel,20818 | 4230.73 | 0.00 | 3578.27 | 0.00 | 652.46 |
| Raman, Ruth, L,21199 | 4144.34 | 0.00 | 2443.35 | 0.00 | 1700.99 |
Generated 2025-12-23 17:03:10.118 UTC