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




      Sagar Gupta