Hi all,
I am trying to subtract the Grand total by the count of a category, all within a pivot table. Is this possible?
Example:
So I am trying to subtract :HTML Code:
Grand total (29) - Pay Band A (7) = 22
Grand total (29) - Pay Band B (8) = 21
Grand total (29) - Pay Band C (6) = 23
Grand total (29) - Pay Band D (8) = 21
Any help would be greatly appreciated.
Regards,
forrestgump1980
Bookmarks