Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to view my financials by year but I want to exclude the two bottoms ends. I do not want to see 2015 and 2020, which are at the ends of what I am trying to view. Is there a way to limit the display of the table's columns to 2016-2019.
Thanks,
May be use set analysis to exclude them..
{<Year -= {2015, 2020}>}
I type that in the {<Year -= {2015, 2020}>} into the expression editor and receive an error of "garbage after "-="
What do you think?
Maybe {<Year =- {2015, 2020}>} ?
Unfortunately we get the same error here
Can you show an image?
{<Year <> {2015, 2020}>} Try that ?
Where did the expression go?? Did you use this as a dimension?
that expression is going into limitation -> exact value -> expression box