+ Reply to Thread
Results 1 to 8 of 8

Pivot Table - how to count the % of values = "4" and "5" from a column in the source data?

  1. #1
    Registered User
    Join Date
    10-19-2018
    Location
    Lisbon
    MS-Off Ver
    Office 2013
    Posts
    15

    Unhappy Pivot Table - how to count the % of values = "4" and "5" from a column in the source data?

    Hello,

    The file attached contains a very simplified example of the raw data set I'm working with.

    I work with a satisfaction score from 1-5 where only "4" or "5" are considered "happy customers".
    I am using a pivot table so I can enter slicers to allow me to filter data per a number of parameters - I really need the pivot.

    I'm having difficulties adding a field to this Pivot that automatically calculates the percentage of "5" and "4" survey scores per each individual agent (not from a column total or grand total).

    For example, this file's RAW DATA tab shows that "Anne" has 4 surveys, all of which scored at "4" or "5" so this formula would have to return a value "100%".
    On the other hand, "Bryan" has 2 surveys of "1" so he'd return as 0%.

    Satisfaction.PNG

    Is this possible?


    Thanks in advance for your assistance!
    Attached Files Attached Files
    Last edited by vangamut; 03-05-2019 at 09:03 AM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,242

    Re: Pivot table problem

    Administrative Note:
    Welcome to the forum
    We would very much like to help you with your query, however the thread title does not really convey what your request is about.
    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit.

    Please see Forum Rule #1 about proper thread titles and adjust accordingly...

    (note: this change is not optional No Help to be offered until this moderation request has been fulfilled)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    10-19-2018
    Location
    Lisbon
    MS-Off Ver
    Office 2013
    Posts
    15

    Re: Pivot Table - how to count % specific values from a column in source data?

    I've changed the title and made it as specific as I could. Will forum members still be able to respond to my query?

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,242

    Re: Pivot Table - how to count the % of values = "4" and "5" from a column in the source d

    Yup, it's all good now, thank you

  5. #5
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Pivot Table - how to count the % of values = "4" and "5" from a column in the source d

    Hello,
    See if it can be (with auxiliary columns)
    Regards
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    10-19-2018
    Location
    Lisbon
    MS-Off Ver
    Office 2013
    Posts
    15

    Re: Pivot Table - how to count the % of values = "4" and "5" from a column in the source d

    That worked for me Stasinek, thank you very much!

  7. #7
    Registered User
    Join Date
    03-06-2019
    Location
    Darlington
    MS-Off Ver
    2016
    Posts
    19

    Re: Pivot Table - how to count the % of values = "4" and "5" from a column in the source d

    Quote Originally Posted by stasinek View Post
    Hello,
    See if it can be (with auxiliary columns)
    Regards
    Hi Stasinek, - where does the % sum come from on the pivot? I can see the data set is the detail on the raw data tab but their is no sum on there or a column called Sum of 4/5 as %?

  8. #8
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Pivot Table - how to count the % of values = "4" and "5" from a column in the source d

    Calculation field in the PivotTable = x1 / x2

+ 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. Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  2. Pivot table problem - how to relate 3 sheets' data into 1 pivot table?
    By GRG Stevan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-14-2015, 06:12 AM
  3. VBA Pivot Table: Problem with pivot item visibility
    By rotown21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2013, 03:56 AM
  4. Excel 2007 : Pivot Table problem
    By seeker101 in forum Excel General
    Replies: 3
    Last Post: 06-10-2012, 03:35 AM
  5. Pivot table problem
    By neil40 in forum Excel General
    Replies: 0
    Last Post: 05-21-2006, 06:45 PM
  6. Pivot table problem
    By seantera in forum Excel General
    Replies: 1
    Last Post: 01-26-2006, 11:45 AM
  7. Problem with pivot table
    By 85225 in forum Excel General
    Replies: 2
    Last Post: 10-11-2005, 02:05 PM

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