Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Dimension : YYYYMM
Expression :
If(GetSelectedCount(YYYYMM)=0,Sum({<YYYYMM={">=$(=Max(YYYYMM,3))"}>} Sales),Sum(Sales))
Regards,
Antonio
Hi,
Dimension : YYYYMM
Expression :
If(GetSelectedCount(YYYYMM)=0,Sum({<YYYYMM={">=$(=Max(YYYYMM,3))"}>} Sales),Sum(Sales))
Regards,
Antonio
Thank you so much for response and it work well