I have created a pivot table that has a dimension for specific products.
The field has 5 different values and I want the dimension to only display information for three of the values.
I'm using a =if(Match(PRODUCTS,'ABC','DEF','GHI'),PRODUCTS)
My problem is that the pivot table is showing a blank field for anything other than the matched values. I don't want this to display at all. Is there a way to get it not to show this extra row?????