Can Bar Chart display same when user to select year=2016 month =11 it display ?

[paulyeo11]

Hi All

I have a chart 1 , which display correct value. I like to make it also able to display same chart , when user select month = 11 and year = 2016.

The reasons is i have annual sales meeting on Feb 2017 , and during 2017 Feb , i want the chart to display up to 2016 Dec. So i select month = 12 year =2016. , mean it will not display 2017 sales.

Hope some one can advise me how to modify the expression.

Paul

[paulyeo11]

Hi Hemanth

Can you pls help to take a look of below link :-

where go wrong with my expression :- Sum({<year= {$(=Only(year)-1)} >},{<rEVENUE={rEVENUE}...