Hello Excel Wizards,
How do you show in a pivot table Grand Total and Grand Average?
I know how to change the Grand Total from Sum to Average by changing the Summarize Values By setting, but I need to show both Total and Average.
Below is my table. Any help is appreciated.
How do you show in a pivot table Grand Total and Grand Average?
I know how to change the Grand Total from Sum to Average by changing the Summarize Values By setting, but I need to show both Total and Average.
Below is my table. Any help is appreciated.