Results 1 to 4 of 4

Percentage in a Pivot Table

Threaded View

  1. #1
    Registered User
    Join Date
    07-07-2010
    Location
    Roanoke, VA
    MS-Off Ver
    Excel 2007
    Posts
    24

    Question Percentage in a Pivot Table

    Hi all!!

    I feel like there should be an easy answer to my question, but I'm drawing a blank.

    I have attached an example spreadsheet to help explain my question.

    I am using a Pivot Table to count the number of times each of our employees uses a specific piece of equipment. We also have many areas that our employee's work in, so the pivot table not only separates out how much of which equipment is used by individual person, but also by which area that employee uses it in.

    I am trying to get the pivot table to NOT count the number of times the individual person uses the specific piece of equipment, and instead give me a percentage.

    The problem I run into, is when I try "value field settings" "Show values as" and then i can choose from "% of total", "% of column", % of row" etc. I find that all these do not give me the result i'm looking for.

    What i'm looking for is to have the percentage of the equipment usage by individual person.

    Example:

    If it was just counting it would look like this:
    Emp Equip1 Equip2
    a 5 20
    b 3 1

    But I want it to give a percentage:
    Emp Equip1 Equip2
    a 20% 80%
    b 75% 25%

    Having the total that it is finding a percentage of, being the total pieces of equipment that individual person.

    Thank you all so much in advance!!

    I really think i made this more confusing than it actually is, but I think the example will explain it better than I can
    Attached Files Attached Files
    Last edited by rmikulas; 09-24-2010 at 12:56 PM.

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