I have columns say: Share1, Share 2, Share3 etc. Which I will be giving as dimmension, where my Share1 data should always be 2 months before my current month(June-12).
Now I want to display this columns in bar chart as date for eg:
Share1 as April-12
Share2 as March-12
Share3 as Feb-12 and so on......
Now if i am moving in July-2012 then my Share1 should be displayed as May-12
Please let me know if anyone has any idea.
Thanks in Advance