When I add the "Total Row" to a pivot table, it does not always show the "Grand Total". If the column has an aggregation applied, then the Grand Total shows the aggregation (Average, Maximum, Minimum, etc.) instead of a Total.
Is there a way to show the actual "Grand Total" (aka the sum of the values) rather than the aggregation?