Forum Discussion
Hide (blank) row headings/subtotals in pivot tables
Hi Team, I am looking for a solution to blank heading/subtotal rows in a pivot table with a multi level hierarchy. A label filter is an easy enough solution providing the (blank) label value is a...
Did you ever find a solution to this? I am grappling with the exact same problem. Would love to know what solution you found, if any.
Many thanks.
Hi ShogunPatch, sorry mate no solution. You can structure the data so there is a value for each hierarchy, or live with the blanks, or not use a pivot table. I have been living with the blanks.
Afraid that doesn't work, if only (blank) replace with any other text within PivotTable
