How do I average subtotals in a pivot table?
How do I average subtotals in a pivot table? How to set up custom subtotals in a PivotTable Right click on one of the categories within the PivotTable, for instance General Expenses. Select Field Settings from the list. Select Custom under Subtotals and Filters. From the functions list, select Sum and Average. Click OK. How […]