I am attempting to format a pivot table (which I am quite familiar with), but am having a problem suppressing a particular portion.
The data analyzed is three levels deep. It will always be coded at the first level, and may, or may not be coded at the second or third levels. (If coded at the third level it MUST be coded at the second level as well.)
My problem is that, when not coded at the third level the table still shows a value of "blank" of course, with the sum of the amount. I want it just to stop at the second level. See pictures below:
However, when I filter to suppress label = (balnk), the second level also gets suppressed, so that no data shows.
To be clear: I want to suppress the lowest level(s) of blank data, but preserve their presentation at the next-highest level if also non-blank.
Can't figure out how to do this!!