Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Excel Pivot Calulated Field (Excel 2002)

    Please see the attached word doc of a picture of my pivot table. What I need is a percentage of the subtotals for each instead of a percentage of the grand total. How can I do this with a pivot?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel Pivot Calulated Field (Excel 2002)

    You can do it if you add a calculated column in your data table. An example and direction are given at Mr: Excel: Pivot Table question.

    If you need more details specific to your example, could you post an example workbook with the current pivot table?

    Steve

Posting Permissions

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