I am trying to hide details of certain fields in the pivot table, however, when I do that it affects the grand total (decreases for entries I'm hiding).

Any way to still hide fields and not affect the grand total?

Any help is greatly appreciated.