How do you suppress a dimension in a pivot table when all values in the current selection are null

[justin_morley]

Hi,

Firstly, apologies, as I'm sure this has been asked a million times, but no amount of rephrasing my question to google has turned up the answer I need.

I have a pivot table, with many, many dimensions. Most of these have conditional show enabled. I'd like to extend these conditional formulae to say "With the current selection applied, if all values for the given dimension are null, don't display this column".

NB This is *not* the same as the check box "Suppress When Value Is Null" which suppresses displaying the whole row. I want that row to still be displayed, just the column to disappear.

Thanks in advance,

Justin

[agni_gold]

Hi , I am also facing the same issue , but my any dimension is not completely null , all dimension has some value. thats why i am getting below pivot table .

I just want to hide these dimension when these does not have values . please see the attached data also .

[agni_gold]

Hi , I am also facing the same issue , but my any dimension is not completely null , all dimension has some value. thats why i am getting below pivot table .

I just want to hide these dimension when these does not have values . please see the attached data also .