Results 1 to 9 of 9

Adding and then averaging data in a pivot table

Threaded View

  1. #1
    Registered User
    Join Date
    11-06-2007
    Posts
    63

    Adding and then averaging data in a pivot table

    Hello.

    I have a large batch of data (small example attached) and I need to first sum it by product and then average it by person. (only one person is shown in the temp data)

    Seems like this would be a job for a pivot table but I can't figure out how to do both steps at the same time. As of right now, I am making a pivot table to sum the values by product then copying that data to another sheet and averaging it in another PT. Yeah, rookie move.

    I thought of using PT one as a source for PT two. Didn't know if I can do that or if there is an easier way all together.

    Any thoughts?

    Thank you in advance for your help.

    Cheers,
    Todd
    Attached Files Attached Files

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