Is it possible to have an average at the bottom of a pivot table rather than the grand total?
W Welly Aug 18, 2006 #1 Is it possible to have an average at the bottom of a pivot table rather than the grand total?
D Debra Dalgleish Aug 18, 2006 #2 If you add a data field, and set it to show the average, the column total for that field would also be an average. To change the field settings, right-click on the Data field button, and choose Field Settings Under Summarize, select Average, and click OK
If you add a data field, and set it to show the average, the column total for that field would also be an average. To change the field settings, right-click on the Data field button, and choose Field Settings Under Summarize, select Average, and click OK
