+ Reply to Thread
Results 1 to 4 of 4

Pivot Table % Trouble

  1. #1
    Registered User
    Join Date
    04-08-2019
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Office 365
    Posts
    2

    Pivot Table % Trouble

    Hello everyone,
    I've tried searching for a question related to this already with no luck, so if someone already has an answer to it and is willing to share a link to the thread it'd be much appreciated! In trying to create a new pivot table, I've been able to pull in various data that I need but am stumped with trying to figure out how to display a percentage of total column. Here's a brief explanation of what I'm looking for:
    I want to be able to showcase how many audits each member of our team performed for a given time frame. I also want to be able to see how many times each person had a finding (shown as CD's, CO's, and CF's in the table below). I also want to create a column next to each of these CD, CO, CF fields that will show me a percentage of 'Sum of CD Count' / 'Count of Title (i.e. Al had 1 CD, 15 CO's, and 8 CF's - CD scored 0.23% of the time, CO scored 3.46% of the time, CF scored 1.85% of the time) but when I create a second 'Sum of CD Count' in the Values, I've only been able to calculate off of the Sum of CD Count column itself (i.e. Al's 1 CD equates out to 4.55% of the total 22 CD's that were given by the entire team through the month).
    Does anyone know of a way where I can return the value divided by the Count of Title? Your help is much appreciated!!!

    Capture01.PNG

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Pivot Table % Trouble

    Hi and welcome to the forum.

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context. Pictures are rarely much use and no one wants to spend time re-creating something you already have.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    04-08-2019
    Location
    Salt Lake City, Utah
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Pivot Table % Trouble

    That makes sense, here is an Excel file for the information I'm attempting to seek help on.

    Thanks!
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,548

    Re: Pivot Table % Trouble

    Perhaps the following will do what you want:
    The formula for CD/CoT is:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Similar formulas are used for CO/CoT and CF/CoT just change CD to CO and then CF
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Trouble with time value from pivot table in an IF formula
    By mrteater in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-08-2015, 12:01 PM
  2. trouble sorting pivot table
    By Execut1ve in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-29-2014, 08:49 AM
  3. Trouble creating simple pivot table using VBA
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-20-2012, 04:29 AM
  4. Pivot Table Sorting Trouble
    By wileymiester in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-12-2012, 07:49 AM
  5. trouble creating pivot table
    By blangeru in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-10-2012, 03:36 PM
  6. Pivot Table Skills Matrix Trouble
    By ramjet in forum Excel General
    Replies: 0
    Last Post: 06-05-2012, 11:14 AM
  7. Trouble Using Pivot Table off a DNR
    By Research RN in forum Excel General
    Replies: 7
    Last Post: 01-09-2009, 12:03 PM

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