How to not show (blank) in pivot table

[jaryszek]

Hi,

i want to entirely delete (blank) column from pivot table.
how can i do this automatically?

I found 2 Solutions but their are not suit for me:
1. Exclude blanks from filter (demanding manually go to pivot and uncheck)
2. Change blanks for empty row using conditional formatting.

Any ideas?
Best,
Jacek

[PaulM100]

Try: Analyze - Options - Display - Uncheck Show items with no data. Otherwise, write a macro to un-filter blanks automatically from the pivot.

[jaryszek]

thank you!

The first option is not working...the field is not possible to check.

Best,
Jacek

[PaulM100]

You could try something like this:

Please Login or Register  to view this content.

[jaryszek]

ok thank you.

Jacek