Results 1 to 13 of 13

Pivot Table: adding a percentage field as '% of Subtotal'

Threaded View

  1. #1
    Registered User
    Join Date
    11-13-2007
    Posts
    5

    Pivot Table: adding a percentage field as '% of Subtotal'

    Hello,

    In the attached Excel file, there is a pivot table.

    In the Data part of the table, there are two columns. The second is the exact same field than the first one but expressed as percentage (Field settings/Options/Show field as "% of" + "Total".

    The problem is: I don't want to express this field as a % of Total ('Grand total') but rather as a % of Subtotal (e.g. Danemark Total).

    Is this possible and how should I do it?

    Any help is appreciated, thank you!

    Xavier
    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