I have a field as MonthYear which have values as " JAN-2016 , Feb-2016 , and so on."
i am trying to show my trend line chart for last 12mths only.
i am creating a variable as
but its not working
if(gertselectedcount(MonthYear)=0, MonthYear= addmonths(date(MonthYear),'MM-DD-YYYY')-12),max(MonthYear)), but its not working .
ANy suggestions or help is highly appreciated.
The said filed was created in script by concatenating Month & Year