Here is the scenario:
We have designed WAD in that we can see Tabular view and Graphical view.
In tabular view we have KPI names.
As per the requirement when we click on KPI names it has to show Graph for the previous 12 months below the tabular view.
In report we have
Pre month, present month, act yr to date, plan ytd, %var ytd, pre yr ytd act
If present month is March 2007
Graph has to show for rolling 12-month actual values for selected KPI rows
It has to start from Feb 2006- Feb 2007.
If present month is Aug 2007
Graph has to show for rolling 12 months actual values for selected KPI rows and it has to start from July 06- July07
What changes need to be done for report and for WAD.
Any experts can solve this.
Thanks in Advance