Pivot Table Suppress Zero-Values & Suppress When Value Is Null Query

[mccook]

Hi,

I have a pivot table which has a null value in the dimension and has some months which have no values at all (Atachment A), I would like to only remove the null value from the dimension however when I try all the different combinations of Suppressing Zero Values and Null values the closest I get is removing the null values on dimensions and also removing the months which have zero values (attachment B).

Any advice?

Cheers,

Dean

[#2]

Hi,

can you post a small example of the data from your script so we can simulate what happens?

[mccook]

Hi,

I've attached a chopped down version of the issue.

Thanks,

Dean

[mccook · Accepted solution]

I'm not sure how, but the issue has now been resolved.