Closed Thread
Results 1 to 3 of 3

Pivot: Percentage of Subtotal and Total

  1. #1
    GMANFG
    Guest

    Pivot: Percentage of Subtotal and Total

    Hello All,

    I have created an old fashioned pivot table. I would like to have it show percentage of subtotal and show percentage of Grand Total, to 3 decimal places. See REPORT tab. In column D of attachment, I have entered in text what I would like to see in this column for INCOME, EXPENSE, AND SPENDING pivot table. But I'm stuck. Can any one help

    Thanks
    Attached Files Attached Files
    Last edited by GMANFG; 02-14-2010 at 07:08 PM.

  2. #2
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    Re: Pivot: Percentage of Subtotal and Total

    I've adjusted your SOURCE. See the summary

    HTML Code: 
    Attached Files Attached Files
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

  3. #3
    GMANFG
    Guest

    Re: Pivot: Percentage of Subtotal and Total

    Thanks you very much

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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