Pivot Table Grand Total

JasonKerr

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?

MichelleH

@JasonKerr Try using a FIXED function in your beast mode and put your row and column fields into the FIXED BY clause.

Here is an article on FIXED functions: Customer Support Community

MichelleH

@JasonKerr Try using a FIXED function in your beast mode and put your row and column fields into the FIXED BY clause.

Here is an article on FIXED functions: Customer Support Community

JasonKerr

@MichelleH This wouldn't work in a pivot table, right? Adding any new "value" fields will have them show up in each segmentation of the table. I am only looking to add one row at the bottom of the table with a total of the values in the columns.

MichelleH

@JasonKerr I mean to use the FIXED beast mode in place of the existing value field. By using the FIXED aggregation, you are dictating how you want the grand total row to calculate instead of the default aggregation.