Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dimension limit allows us to show First n values. Is it possible to show some values between n and m indices? I have attached a sample here. I would like to skip displaying the values for first 2 and last 2 years. Just show the values corresponding to the years left in between. How can this be achieved by using set analysis in expression.
Hi Nishant,
you can have a start and end year variable which can drive your set analysis yes, see example.
That allows users to drive the range they are after, if you just wanted a hard rule of removing the lowest and greatest two years then hide the variables and code them accordingly.
hope that helps
Joe
Hi, in expression you can use:
Only({<Year={">=$(=Min({1} Year)+2)<=$(=Max({1} Year)-2)"}>} Employees)
Hi Nishant
Please find the attached file
Regards
Harsha
Perhaps like this: sum({<Year={'>$(=min({1}Year,2))<$(=max({1}Year,2))'}>}Employees)
Hi Joe
You ignored the condition that was already there on that expression. I would need that condition as well. Can you suggest a way out?
The conditional you set was a calculation condition i.e should the expression show or not.
You can just enable that again if it's required, as all I have adjusted is the expression itself to be relative to the min/max year variables