Results 1 to 8 of 8

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

Threaded View

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

    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.

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. [SOLVED] 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