[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount < SKIP 1000 > < TAKE 15 >
15 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Andersen, Carl, J,11057 | 8088.04 | 0.00 | 3374.99 | 2319.99 | 2393.06 |
| Liu, Jessie,11106 | 8079.05 | 0.00 | 3399.99 | 2294.99 | 2384.07 |
| Xie, Cristina, C,17050 | 4496.23 | 0.00 | 3578.27 | 0.00 | 917.96 |
| Chander, Alison,18249 | 6044.59 | 0.00 | 3578.27 | 2466.32 | 0.00 |
| Munoz, Alfredo, C,23314 | 2744.52 | 0.00 | 0.00 | 2181.56 | 562.96 |
| Gomez, Felicia, J,18219 | 6038.56 | 0.00 | 3578.27 | 2460.29 | 0.00 |
| Diaz, Marc,11058 | 8248.02 | 0.00 | 3399.99 | 2374.98 | 2473.05 |
| Perez, Kevin, M,25565 | 1239.09 | 0.00 | 699.10 | 0.00 | 539.99 |
| Green, Jonathan, A,17332 | 4480.73 | 0.00 | 3578.27 | 0.00 | 902.46 |
| Smith, Arthur,18240 | 6098.58 | 0.00 | 3578.27 | 2520.31 | 0.00 |
| Green, Fernando,17258 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Wang, Crystal, C,11112 | 8295.02 | 0.00 | 3374.99 | 0.00 | 4920.03 |
| Lopez, Luis, P,17334 | 4347.76 | 0.00 | 3578.27 | 0.00 | 769.49 |
| Zhu, Alisha, G,18239 | 6030.61 | 0.00 | 3578.27 | 2452.34 | 0.00 |
| Lal, Shaun, H,17056 | 4417.75 | 0.00 | 3578.27 | 0.00 | 839.48 |
Generated 2025-12-23 07:25:57.208 UTC