Results 1 to 7 of 7

Pivot Table Question - Finding Percentages of Counts

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-03-2009
    Location
    Florida
    MS-Off Ver
    Excel 2007 / Excel 2010
    Posts
    106

    Pivot Table Question - Finding Percentages of Counts

    Hello,

    After using Excel for years (still quite a novice), I have just discovered Pivot Tables. I love them!

    Here's my fun scenario. I have 5 game show participants, and I will throw varying amounts of dollar bills at them throughout the day. Some will not be able to play for the entire day, and some will be motivated to play if there's lot of $$$ to be had. I have made a Pivot and I can see how much money was in play for that hour. I can't seem to figure out how I can determine based on the total number of times I thew money out, the % of times each player caught the money. So basically I want % distribution of total attempts during a specific hour. If at 4 AM, I threw money out 5 times, "Frank" won twice, "Greg" once, "Moe" once, and "Tom" once, I would want to see a 40%, 20%, 20%, 20%, and 20% in my Count column. I've tried a few different options in the Pivot Table but hasn't yielded results I'm looking for.

    I attached a quick sample sheet.
    Attached Files Attached Files
    Last edited by ExcelQuestFL; 06-11-2012 at 05:51 PM.

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