I want to show 2013 bars along with 2014, rest of 2013 bar appear when 2014 months updated pls refer attachment.

[noman212]

I want  to show 2013 bars along with 2014, rest of 2013 bar appear when 2014 months updated pls refe...

[Anonymous]

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

[noman212]

how to implement this , I am usnig 'calendermonthname' in dimension and sum(issuedbusiness) in expression

[sudeepkm]

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.

[Anonymous · Accepted solution]

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

[noman212]

Jebamalai Dass thanks its work fine.

[Anonymous]

Hi Noman,

Then you can update this question as answered so that others can also refer

Regards

Jeba