Issue
When using table calculations, grand totals and subtotals might show unexpected results. The option to change the aggregation type of the grand total to something other than Automatic is grayed out.For example, the view shows the difference in average regional sales between quarters. The automatic grand total is incorrect: it shows the difference between the average sales for the entire quarters, rather than the sum of differences between the average regional sales.