I have one pivot table that contains the customer and year dimension. In the expression, I have current year and previous year sales. But when I put the year dimension under the expression, the non-related year will still be displayed, but all values are zero. How can I suppress this?
Attached is the sample scenerio. For example, when 2008 is selected, 2007 shouldn't be shown in the Current Year column. Same for Previous Year (2008 shouldn't be shown).