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...
Click on the filter dropdown in A1. Select the field "Reportlevel2" in the dropdown of the filterpane and then uncheck "(Blank)". Press OK. Repeat for field "Reportlevel3".