Remove BLANK in PIVOT TABLE
Answers
-
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
-
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...
-
Noted, i observed this Pivot tool is not efficient as conventional pivots in excel. I used REPORT to sum-up these fields.