[ROOT] dt FactInternetSale WHERE DimCurrency.AlternateKey EQ 'AUD' > PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount SHUFFLE < SKIP 60 > < TAKE 12 >
12 items
| DimCustomer.Name+','+DimCustomerIdId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| Zeng, Cara,20444 | 6085.59 | 0.00 | 3578.27 | 0.00 | 2507.32 |
| Deng, Tasha,11459 | 8141.33 | 0.00 | 3399.99 | 0.00 | 4741.34 |
| Hall, Amanda,26656 | 1345.95 | 0.00 | 0.00 | 1345.95 | 0.00 |
| Lal, Tara, S,18697 | 5279.26 | 0.00 | 3578.27 | 1700.99 | 0.00 |
| Gill, Javier,15645 | 3785.08 | 0.00 | 0.00 | 2049.10 | 1735.98 |
| Zheng, Dawn, F,19579 | 83.98 | 0.00 | 0.00 | 0.00 | 83.98 |
| Deng, Barbara,20445 | 6078.71 | 0.00 | 3578.27 | 0.00 | 2500.44 |
| Suri, Erick,16635 | 38.88 | 0.00 | 0.00 | 0.00 | 38.88 |
| Long, Megan, J,15791 | 42.26 | 0.00 | 0.00 | 0.00 | 42.26 |
| Nara, Lindsay, M,25247 | 4.99 | 0.00 | 0.00 | 0.00 | 4.99 |
| Sun, Rafael,26749 | 1322.98 | 0.00 | 0.00 | 1322.98 | 0.00 |
| Lal, Dustin, A,16484 | 4175.53 | 3578.27 | 0.00 | 0.00 | 597.26 |
Generated 2025-12-23 16:56:11.632 UTC