Remove BLANK in PIVOT TABLE

tamiz.vedachalam

How to remove BLANK values in Pivot sheet. The source sheet is having a default rows, but I am maintaining limited rows and rest of the blank rows are reflecting in Pivot sheet. How do I remove ?

Genevieve P.

Hi @tamiz.vedachalam

You can hide the column in your destination Pivot sheet or create a Report from this sheet that filters out both the row and the column.

Cheers,

Genevieve

johngraham78

Hiding columns will only remove some blanks. There doesn't seem to be a good way to remove them from the rows. A report will do that, but it will not keep indents...

tamiz.vedachalam

Noted, i observed this Pivot tool is not efficient as conventional pivots in excel. I used REPORT to sum-up these fields.