I have many categories of data in my pivot table rows. Within each category there are many many days of individual information. I want to collapse all of the daily data into the categories. Is there an easy way to do this without doing each one separately?
Hi - thanks in advance to anyone who can assist me with the following:
I have created a pivot table and I want to be able to hide the field heading (which at the moment says Data and has a drop down arrow next to it).
How can this be done?