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...
I just tried a bit of a workaround, and seemed to work. If you use 'Conditional Formatting', then 'New Rule', and Select Rule Type: "Use a formula to determine which cells to format".
Use a formula of:
=IF(B15="(blank)",1,0)
then apply the formatting to have the font color be the same color as the background (ie white font on a white background appears 'empty').
Good luck!