When creating a pivot table, would like to have only certain columns on the pivot table display a grand total. These are the headers, we do not want How to Contact, Document Type to display grand total as it is just repeating the same information as these are done with table with concatenatex to display number and abbreviation of document type in the table. Row Label displays owning leader name and person's name, sum of total number of documents past due is number and would like grand total to display and
Row Labels | How To Contact | Count of Document Types | DocumentType | Sum of Total # documents past due | Sum of Total $ Held | Sum of Total by Owning Leader |