Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

0 Replies