0 Replies Latest reply: Jun 15, 2012 8:21 AM by Sagar Gupta RSS

    How to extract month from column names?

      Hi all,

       

      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

       

       

      Regards

      Sagar Gupta