Capture.PNG
I have attached a picture of the way my pivot table looks. (I have crossed out all the info and numbers.) I want the fields that do not have any information to disappear when the more left fields are collapsed and so they're empty like they are in the picture. Here is a picture of what I want it to look like:
Capture2.PNG
In that pivot table, if you click on one of the +, it will expand the field and show the column headings, but otherwise, as you can see, they are not shown. How do I make my pivot table like that?
Bookmarks