Hide a column (expression) in a pivot table

[#1]

I am looking to hide a column which is an expression within a pivot table.  I was able to use conditional logic to hide the column but it in turn hides all of my columns.  The column I am trying to hide is the only dimesion in the pivot, the rest are dimensions.  How can I just hide this one column?

[rwunderlich]

Uncheck "Suppress Zero Values" on the Presentation pane. That will allow your Dimension columns to display even when you have no enabled expression.

-Rob

[#3]

I did that, but it removes all the conditional formatting I have on the pivot chart.  Any way to retain the formatting?

[#4]

you can use a onetime macro run to hide a column

sub hide

     call HideColumn(''CH10",1)

End sub

private sub HideColumn(ch,n)

      set ch = activeDocument.getsheetobject(ch)

     ch.setpixwidth(n-1,0)

end sub

[rwunderlich]

Yes, that is a weird limitation -- You don't get formatting on Dimensions unless you have an Expression displayed. A couple of workarounds I've used.

1. Make the last dimension an expression.

2. Make a dummy expression =' ' and drag the column to be very small.

-Rob