Results 1 to 2 of 2

Thread: Pivot table totals

  1. #1

    Pivot table totals

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have data that comprises three columns. Dates, names and values. The names repeat many times in the list and I want to create a table that lists each name once, gives the number of times it occurs in the data list and also gives the total of the values against each name. I have looked at the Pivot table wizard but I cannot see how to get the total of the values. Where do I start?

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    In your pivot, drag Name to the Values pane in addition to the Rows pane.

Posting Permissions

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