Is it possible to have an average at the bottom of a pivot table rather than
the grand total?
Is it possible to have an average at the bottom of a pivot table rather than
the grand 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks