Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a question concerning the exclusion of some values.
I have a dimension Year= 1998, 2013, 2014, 2015, 2016
And I have the dimension Month= jan ... dec.
When I create my report, I select the current month and year. A couple of my tables only show he results for that specific month and year. One of my tables however is a chart with all months visbible, so I use Month= in my expression. That's that.
But I also want multiple years visible. This is where the issue lies: I only want 2014, 2015 and 2016.
Problem is, to create my report, I selected '2016' and I cannot write Year= because that would also show me results for 1998 and 2013 in this specific chart (and I do not want those years being visible).
I tried to use the combination of both Year= in my expression and a calculated dimension saying =if(Year='2014' OR '2015' OR '2016', Year) but that does not work unfortunately, it still shows me all of the values for Year. Apparently an expression is 'stronger' dan a calculated dimension.
How can I solve this issue?
Thanks in advance!
chk below
if your expression is Sum(Sales) then to exclude the year 1998 you write the following:
sum(${<Year={'*'}>-<Year={1998}>} Sales)
* means all years (Nulls are excluded)
or
you can write sum({<Year -={1998}>}Sales)
Thanks for the link!
Using = - {} instead of - = {} did the trick!