Hide column in Pivot table

Sandya_K — Tue, 13 Sep 2022 03:40:19 GMT

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?

topic Hide column in Pivot table in App Development