I have a pivot table with some monthly numbers and quarterly sub-totals, and a yearly grand-total at the bottom.
For two of the columns, there isn't a way to compute any sensible numbers for the sub-totals and grand-total, so I would prefer to just leave those cells blank.
I'm sure there is an easy way to change the value to "", but I've been going round in circles trying to work out how to do it. Can anyone help?
The exact cells that need to be blank are highlighted in the image (obviously this should also include the Q3 and Q4 sub-total lines that don't exist yet)
Please sign in to leave a comment.