Conditional Hide Expression based on Dimension Value
I have not found a thread on this topic, so I'm hoping someone can help now. I have a pivot table with 2 expressions. I want Expression1 to show with all dimensions, but I want Expression2 to only show when dimension value = 'A' or 'B', not for 'C' or 'D'.
I know i can exclude the values with an if statement embedded in the expression, but then I have expression columns that are always blank and just taking up space... and the user is requesting they be suppressed for those dimension values.
I have tried using the Conditional Show feature on the expression with If(Match(Brand,'A','B'),1,0) but that hides the expression for every dimension.