I have a Pivot table with three measures, and would want to hide one column for certain dimensions.
Dimension:
Total Units
Tables
Risers
Chairs
Measures:
Target
Sales
% to Target
I want to hide the % to Target for all dimensions except "Total Units"
If I add a condition in 'Show column if' to hide when the value is zero, it hides the column from all dimensions.
Any help is appreciated?