Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 6 years of data in my DB but in chart i want to display only 4 years.
Eg: 2013 ,2014,2015,2016,2017,2018
Expected result : 2015,2016,2017,2018 in dimension of chart.
But all 6 years should be there in the list box filter.
If I want to see 2013 data I can select from list box.
Please help with the solution.
Thanks.
Hi,
You need Set analysis for the same.
Try below example.
Sum({<Year = {">=$(=Max(Year)-3)"}>}Sales)
Regards,
Kaushik Solanki
May be implicit command helps you
Hi,
I have already a dimension in chart as below
=if('20'& Right(TMonth.Year,2)<>20,'20'&Right(TMonth.Year,2))
which is displaying the year of 2015 -2016 as 2016 and so on.
I have to display only 4 years in that ie.2015 2016 2017 2018
I dont want the sum of sales.Just the year needs to be filtered.
Please help if you have solution to this.