Calculated Dimension variables

[danielnevitt]

Hi,

I currenlty have a graph that I have set the below calculated dimension:

IF(MATCH(trim(CONTRACT_MONTH),('Jan'),trim('Feb'),trim('Mar'),trim('Apr'),trim('May'),trim('Jun'),trim('Jul'),trim('Aug'),trim('Sep'),trim('Oct')),CONTRACT_MONTH)

CONTRACT_MONTH is in the format Jan, Feb, Mar, Apr etc

I would like to replace CONTRACT_MONTH with CONTRACT_MONTHYEAR which is in the format Jan 2013, Feb 2013, Mar 2013 etc and also replace the hard coded 'Jan', 'Feb', 'Mar' with variables:

vCurrentMonth =MonthName(Today())

vCurrentMonthLess1 =MonthName(Today(),-1)

vCurrentMonthLess2 =MonthName(Today(),-2)

etc

Is anyone able to help with this, or point me in the right direction?

Thanks,

Daniel