Pivot Tabke - Average Total
 

Is it possible to have an average at the bottom of a pivot table rather than
the grand total?

Pivot Tabke - Average Total
 

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


Welly wrote:
Is it possible to have an average at the bottom of a pivot table rather than
the grand total?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html