Bar chart show latest 3 months sales if no selection

[boonhaw_tan]

Hi All,

I need to build to bar chart show sales by month.

There is a requirement to show latest 3 months of sales if no selection.

Also it need to display sales based on user selection.

Really appreciate for any advice.

e.g:

- If no selection, display sales for 201707, 201708 & 201709

- Display sales for 201701 & 201708, if user select 201701 & 201708  

YYYYMM	Sales
201701	100
201702	200
201703	300
201704	100
201705	200
201706	300
201707	400
201708	500
201709	600

Thanks,

Boon Haw

[antoniotiman · Accepted solution]

Hi,

Dimension : YYYYMM

Expression :

If(GetSelectedCount(YYYYMM)=0,Sum({<YYYYMM={">=$(=Max(YYYYMM,3))"}>} Sales),Sum(Sales))

Regards,

Antonio

[boonhaw_tan]

Thank you so much for response and it work well