Pivot table with Grand Total and Grand Average

[iggydarsa]

Hi all,
I was wondering if there is a way to show the Grand Average Column next to the Grand Total Column.
If I can duplicate Grand Total then I can change the settings of the second Grand Total to show the average but I could not figure out how to show an additional Grand Total.

Thanks.

 

[Trevor G]

Look to create a new calculated field.

 

[iggydarsa]

Thanks for the response Trevor,
Calculated fields appear for each column, I am interested seeing only the Grand Average (along with Grand Total)
Thanks

 

[SpillerBD]

... That would fall in PowerPivot. Not personally good on that myself but should be like doing the calculations except an inverse of where the Total Rows are not shown.
A general Video for PowerPivot from Mike Girvin, Excel Trick 1395
The inverse of what you describe.... P3 Nation