I have a pivot table with payment types as column labels (e.g. cash, credit card, check), payments in the values section and location in the row labels. Is there a way to modifier the column grand total calculation so it does not include check? I figure you have to do this programmatically otherwise my only solution was to create a "Total" payment type in the column labels that would do this calculation.