In you totals drop down menu there is a Total ALL Using drop down option. Make sure it is set to automatic and not sum.
Looks like it's set to automatic. But it still sums the percentages.
1 of 1 people found this helpful
That's because your % is not calculated within the workbook but it looks like it is read directly from the source.
Create your calculated field as SUM([Dollar Change])/SUM([2015 Estimate]) and format as % - should be displayed then as AGG(...) instead of SUM(...)
That did the trick! Thanks!