How to make my chart 1 also work fine , if i not select year = 2015 ?

[paulyeo11]

Hi All

My expression BELOW work fine FOR CHART 1 when i select year = 2015 :-

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}distinct REVENUE_C/1000)

My question is how to make my chart 1 also work fine , if i not select year = 2015 ?

Paul

[paulyeo11]

Okay this is what I am looking for.

Thank you very much.

Paul

Sent from my iPhone