+ Reply to Thread
Results 1 to 5 of 5

Need to see percentage of group total for specific values

  1. #1
    Forum Contributor
    Join Date
    05-22-2012
    Location
    Boise, Idaho
    MS-Off Ver
    Office 365
    Posts
    156

    Need to see percentage of group total for specific values

    Hello I have a group of data that I can see overall totals for various "Caller Type". I need to be able to also see the % of the PRV and CLM of the overall at the same time or at least in an additional display next to the current table. I posted an example below of what I am looking for or something similar. The goal is to identify those who have a larger percentage of PRV participation.

    Total PRV
    Group 1 11 27%
    Group 2 11 36%
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,059

    Re: Need to see percentage of group total for specific values

    First, change the PivotTable Report Layout to Show in Tabular Form. Add Caller Type field to Values section of the PivotTable, then Show Values As > % of Parent Total.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    05-22-2012
    Location
    Boise, Idaho
    MS-Off Ver
    Office 365
    Posts
    156

    Re: Need to see percentage of group total for specific values

    Is there a way to do this if we do not want to include "Caller Type" CLM in the view? Once I remove CLM it obviously changes the total and % turns to 100%

  4. #4
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,059

    Re: Need to see percentage of group total for specific values

    Add a % column in your data. I have converted your data into an Excel table so any new rows or columns added, PivotTables can self-expand.

    Add in the new % field in Values section of PivotTable and Summarize Values By Average.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    05-22-2012
    Location
    Boise, Idaho
    MS-Off Ver
    Office 365
    Posts
    156

    Re: Need to see percentage of group total for specific values

    Thank you for your help-- perfect

+ 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] Group and total duplicate values in a column
    By Thistledown in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-26-2021, 11:30 AM
  2. Replies: 14
    Last Post: 01-12-2017, 01:41 PM
  3. [SOLVED] Group's Percentage of Total Sales
    By juanstermash in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-28-2016, 10:30 PM
  4. Replies: 1
    Last Post: 04-18-2014, 05:54 PM
  5. [SOLVED] present values as percentage of sum total of range
    By Christopher135 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2013, 07:50 PM
  6. [SOLVED] Group up same values and provide total
    By StuartO in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-13-2013, 01:26 PM
  7. Count specific percentage group in a range
    By cedarhill in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-06-2009, 04:06 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