Please see the attached file. In the combo chart, I want that for the Year '2002', bar should not be displayed. Condition for the expression that I've written is: if(Year=2002,'0','1')
Please check what's wrong here.
Check attachment, have added the condition in the dimension. The else part i.e. 2002 will become null. Have suppressed nulls for dimension then.
Thanks for your reply. I made it using your approach. I made a slight change because for Year 2002, I just don't need bar. But line should always be displayed (even for Year 2002).
But I have a small doubt again. Please check the file attached. Instead of hard coding a value like in if(Year<>'2002',NumberOfParks), I would like to get '2002' from a field. This time the field can have more than 1 values. For example in the attached example, I have two values '2001' and '2002' in the Reference field. How to take these values into account?
Thanks for your reply but I didn't want my dimension to disappear from display. That's whyI don't use condition in Dimension. However I have the problem of using filter value from another field. Please see the attached example. I have two values '2001' and '2002' in the Reference field. How to take these values into account for filtering bar in the combo chart?