+ Reply to Thread
Results 1 to 4 of 4

Need Help displaying percentages in Pivot Table by category not row/column

  1. #1
    Registered User
    Join Date
    12-28-2006
    Posts
    42

    Need Help displaying percentages in Pivot Table by category not row/column

    It seems I'm having issues attaching the excel file due to a database error telling me I either do not have sufficient privileges or my account has been disabled . I'll get it posted as soon as I can. Sorry!

    Hello all -

    I have a pivot table problem that I need assistance with. I have a spreadsheet with an associated pivot table that is displaying counts for a unique item called "Seasoned Agent". N indicates a Non-Seasoned Agent while S indicates a Seasoned Agent. What I'm trying to do is display the numbers as percentages for each heading and month, not for the entire row or column.

    For example, for the first column, Binding Script Compliance, we had 31 for N and 219 for S for a total of 250. What I want to see is what percentage of 250 the 31 N's represent for January and what percentage of the 250 the 219 represents. This will be the same for the other columns and months.

    I've attached a sample spreadsheet showing the data I'm working with.

    Any help is appreciated.

    Thanks!
    Nick!
    Attached Files Attached Files
    Last edited by amsnss; 09-27-2010 at 09:01 AM. Reason: trying to attach excel file

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,116

    Re: Need Help Displaying Percentages within Pivot Table

    Hi Nick,
    You need to "Go Advanced" (just to the right of "Post Quick Reply") and click the paper clip icon above the message box. If the file is too big to upload you will fail. You may need to give us a sample instead of the whole thing.

    We need to know what version of Excel you are using. If you could update your profile it would show on each post.

    If you are trying to do percentages in a pivot table that has some text (instead of numbers) it may not give you that option. Look for text in the data and change it to numbers. Hope that helps.

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Need Help Displaying Percentages within Pivot Table

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Registered User
    Join Date
    12-28-2006
    Posts
    42

    Re: Need Help Displaying Percentages within Pivot Table

    Sorry about that. I tried to edit it to be more descriptive with the limited space as I'm really unsure how to describe what I'm trying to accomplish. I finally got the spreadsheet to attach as well.

    Quote Originally Posted by royUK View Post
    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    Last edited by amsnss; 09-27-2010 at 09:01 AM.

+ Reply to Thread

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