Piivot Table - Don't show blanks

[Jammydan]

Hi

I have looked everywhere and followed solutions but cannot seem to not show blanks "(blank)" in my pivot table.

I have selected "for empty cells, show: 0" but this has no effect.

Please help!

Thanks

 

[GlennUK]

Can you show what you mean? Give some data, and show what layout you are getting?

 

[Tuta]

in my case -- in the cell in the pivot table it actually lists out:

(blank)

But, I would prefer it simply not display/show anything.

 

[GlennUK]

Like I said before : Give some data, and show what layout you are getting?

 

[Tuta]

No reason to be passive aggressive.

I am thinking you haven't seen the issue either of us are facing because my explanation is actually pretty clear.



Quite literally, in a Notes column where there is not data in the source detail, this is what appears in the cell in the pivot table all the way down:
(blank)
(blank)
(blank)
(blank)
(blank)
etc. etc.


(for even more clarity -- open parentheses the letter 'b' the letter 'l' the letter 'a' the letter 'n' the letter 'k' then a closing parentheses)



Thanks!

 

[GlennUK]

No reason to be passive aggressive.I am thinking you haven't seen the issue either of us are facing because my explanation is actually pretty clear.

I am not being passive-aggressive, and don't think I ever am. I repeated the question because you didn't answer it .... how else would you have me react, precisely?

I have seen "(blank)" appear in PivotTables, so I have seen the issue, and the cause is usually to do with which field of the raw data you are choosing to go into the PivotTable ... but you still haven't show the data ( which I've asked for twice now ). I give up on this thread ... read about PivotTables here:

http://blog.contextures.com/archives/2008/12/04/counting-blank-cells-in-source-data/

 

[GlennUK]

Note to JammyDan ... if you want to continue this thread then fine ... I seem to be having communication problems with another person who has joined in this thread.