When using a pivot table, if you have Grand Totals displayed, it displays them for all fields that are being summarized.
How can I display the grand total for only certain fields.
For example, in the image below, I only want to see the grand total for
Amount and not
Is this possible ?
I currently have to use conditional formatting to look for the row containing ‘Grand Total’ and then format text in that row to the same colour as the cell fill etc.