+ Reply to Thread
Results 1 to 3 of 3

Calculate % from Total in Column

  1. #1
    Registered User
    Join Date
    03-13-2014
    Location
    Denver, CO
    MS-Off Ver
    Excel 2010
    Posts
    39

    Calculate % from Total in Column

    G'Day to the List

    Have Excel 2010 pivot table that has below summary totals. I need to calculate the percentage of each amount against the total for 815.
    Row Labels Count of Sector
    County 59
    Federal 125
    Federal 2 10
    International Org 5
    Municipal 98
    National 2
    National RC 22
    Private 399
    State 95
    (blank)
    Grand Total 815

    I'm a very inexperienced user, so detailed relies are very helpful.
    Thanks much in advance
    dana hoffman
    Colorado Emergency Preparedness Partnership
    Denver, CO
    dana hoffman

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Calculate % from Total in Column

    Click on the Pivot table to get the Pivot table Field list

    Click on the item in the values box (bottom right hand corner)

    Click on value filed settings.

    Click on Show Values As

    Select % of grand total
    Martin

  3. #3
    Registered User
    Join Date
    03-13-2014
    Location
    Denver, CO
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Calculate % from Total in Column

    Excellent Thanks much!!
    dana

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to calculate weekly sub-total of sale in a column with VBA.
    By sktneer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-30-2013, 03:55 AM
  2. Formula to calculate total from column with text
    By Sadalif in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-26-2013, 01:52 PM
  3. Replies: 3
    Last Post: 01-25-2009, 12:45 PM
  4. Replies: 0
    Last Post: 02-04-2005, 03:58 PM
  5. calculate which cells in column A will give me the total of column
    By Ken in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-06-2005, 03:06 AM

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