I want to show the segment performance over time in the year of 2017.
What is the best way to show the over time analysis?
I want to know how each segment performed over time and made it to grand total.
Another requirement along with this is,
1. Create a Parameter for 3 , 6 and 12 months.
2. display Grand total of over all performance we calculate (above) as Average .
3. Now, this average Grand total should change as per the period Parameter. i.e, when we click 3 months, average should be based of 3 months similarly for 6 months and 12 months.
is this doable?
Any help is appreciated!
Retrieving data ...