Pivot tables and blank cells
Beke wrote:
In a few of my columns I have blank cells, when I create a pivot table it
automatically inserts a row for blank cells. I do not need to incorporate
blank cell data into my report. How do I get rid of this?
Hi Beke,
In the drop-down button for the category that contains blanks, uncheck
(blank).
|