+ Reply to Thread
Results 1 to 2 of 2

Pivot Tabke - Average Total

  1. #1
    Welly
    Guest

    Pivot Tabke - Average Total

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

  2. #2
    Debra Dalgleish
    Guest

    Re: 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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1