Hi All,
Could any one suggest how to get aggregate percenatge dynamically (sum of percentage for each year should be 100%).
For reference i have attached snapshot.
Temperorary i have created aggregation however i want that should be in dynamic so if we apply any filter or drill down further or any control it should have cumulative 100% for each year .
Please suggest.
![Should _have _100.png Should _have _100.png](https://communities.sas.com/t5/image/serverpage/image-id/13196i352E9D4FF439CFFE/image-size/large?v=1.0&px=600)