I have a four column pivot table. The columns are Total Sales, Total Cost, Total Mgn, Margin %. The grand total row totals everything ok. Except the margin % total for in the grand total row does not calculate a %. It appears to summing the %'s in the column. I do have formulas in the margin % pivot column to calculate the % for each job in the row, but it is not working for the grand total row. Can you help?
Last edited:
