+ Reply to Thread
Results 1 to 2 of 2

Adding new calculated/column field to pivot table

  1. #1
    Registered User
    Join Date
    09-08-2010
    Location
    Sacramento, California
    MS-Off Ver
    Excel 2003
    Posts
    1

    Adding new calculated/column field to pivot table

    I generated a pivot table using financial data for clients/by year/by sales rep. The table successfully calculated the Individual totals by rep by year as well as the grand totals by rep and by year. The only grand total it did not calculate is the overall grand total by client. I know I can simply generate a sum field/cell manually, but am unable to label that column as the grand total. How can I get this grand total to calculate and have it become part of the pivot table itself?

    Thank you.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Adding new calculated/column field to pivot table

    Impossible to say without seeing an example.
    You need to post a file with dummy data that demonstrates how you constructed the PT and has incorrect grand totals.

    Also explain why you think the grand total is incorrect.
    Cheers
    Andy
    www.andypope.info

+ 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