Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
add these two in your mastercalendar
InYearToDate(TempDate,$(vToday),0)*-1 as CurYTDFlag
InYearToDate(TempDate,$(vToday),-1)*-1 as LastYTDFlag
and in the set analysis for the 2014 you can use the sum(field())*CurYTDFlag and for 2013 sum(field())*LastYTDFlag
This will show only till current month
Let me know if this doesn't work
Hi Noman,
You can restrict the previous year values to reflect only till Current year month.
Then your chart will work in the way you want.
Regards
Jeba
how to implement this , I am usnig 'calendermonthname' in dimension and sum(issuedbusiness) in expression
you can create a Flag field by using function YearToDate()
the flag will automatically take care of the those months of previous years which are present in this year as per your data set.
add these two in your mastercalendar
InYearToDate(TempDate,$(vToday),0)*-1 as CurYTDFlag
InYearToDate(TempDate,$(vToday),-1)*-1 as LastYTDFlag
and in the set analysis for the 2014 you can use the sum(field())*CurYTDFlag and for 2013 sum(field())*LastYTDFlag
This will show only till current month
Let me know if this doesn't work
Jebamalai Dass thanks its work fine.
Hi Noman,
Then you can update this question as answered so that others can also refer
Regards
Jeba