Results 1 to 3 of 3

Adding a column to a pivot table

Threaded View

ezzy85 Adding a column to a pivot... 05-30-2008, 12:29 AM
arthurbr Hi, as you posted a jpg I... 05-30-2008, 02:32 AM
ezzy85 thanks, but im not sure if... 05-30-2008, 03:01 AM
  1. #1
    Registered User
    Join Date
    05-30-2008
    Posts
    64

    Adding a column to a pivot table

    Is it possible to add an additional column in a pivottable that has a formula based on data in the pivottable and that will get refreshed as the pivot table data gets updated.

    For example in the attached picture, I want to make a column after "grand total" that has sum of "a" and "b" as a percentage of total, sum of "a" and "c" as a percentage of total and various other combinations.

    I have tried just adding a regular formula, but this does not get updated as the amount of data changes.
    Any help would be greatly appreciated.
    Thanks
    Attached Images Attached Images

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