Hi All
I have this expression is working fine , it will display YTD sales by year ( Jan and Feb ) :-
money(sum(-$(ColumnDim51)/$(Columndim89) * YearToDate(date, year-Year(Today())))/1000,$(vMoneyFormatK))
Now it display :-
Examople now is 24/2/16 :-
1st bar will display 1/1/16 - 24/2/16
2st bar will display 1/1/15 - 24/2/15
3st bar will display 1/1/14 - 24/2/14
As i need to display Current month Feb 2016 MTD sales.
May i know how to modify the above expression , only Feb month to date sales.
Examople now is 24/2/16 :-
1st bar will display 1/2/16 - 24/2/16
2st bar will display 1/2/15 - 24/2/15
3st bar will display 1/2/14 - 24/2/14
Hope some one can help me.
Paul