+ Reply to Thread
Results 1 to 3 of 3

Multiple calculations in Pivot Table

  1. #1
    Registered User
    Join Date
    07-21-2008
    Location
    southern california
    Posts
    10

    Multiple calculations in Pivot Table

    Hi. I asked this awhile back but didn't receive much feedback. But I'm still dealing with this and am hoping someone can help out.

    I have a pivot table with several Value fields. I want multiple calculations to be displayed in the pivot table for that Value...for example, not only do I want "count", but also an average as well as standard dev.

    How can I get the final pivot table to display multiple calculations of that Value? I'd rather not have to duplicate that column in the raw data, since I have many columns.

    Thanks!
    Last edited by rylo; 08-01-2008 at 01:59 AM.

  2. #2
    Forum Contributor
    Join Date
    01-23-2006
    Posts
    194
    Right click in the data area of the pivot table >Pivot Table Wizard >Layout.
    Drag the 'Value' column into the data area of the pivot table multiple times and then use 'field settings' to set one to sum, the next to count, the next to average etc. (I hope I have understood yr question)
    regards

  3. #3
    Registered User
    Join Date
    07-21-2008
    Location
    southern california
    Posts
    10
    Thanks! You understood correctly, and the solution worked out perfectly.

+ 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