+ Reply to Thread
Results 1 to 3 of 3

Show combined count of values from multiple fields

  1. #1
    Registered User
    Join Date
    02-05-2017
    Location
    Kansas City, United States
    MS-Off Ver
    office 365
    Posts
    4

    Show combined count of values from multiple fields

    Hello everyone,
    I am trying to show a combined count of different values across multiple fields and would love some help figuring it out. Below is a screenshot of the data, and what I would like the result to look like, but I cannot figure out how to get the pivot table to display a total count of all three controllable's when added to columns. I have included a sample of the data as well. Any help would be much appreciated.
    Thanks!Data.PNGPivot.PNG
    Attached Files Attached Files

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

    Re: Show combined count of values from multiple fields

    Hello,
    I don't know if that was the case. See in the attachment.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-05-2017
    Location
    Kansas City, United States
    MS-Off Ver
    office 365
    Posts
    4

    Re: Show combined count of values from multiple fields

    Thanks, but that is not what I am looking for. I want the table to show all the values that are contained in all three controllables at the top like in the screenshot, and a combined total of each of those values in the table for each reviewer.
    For instance Bobby C. has a total of five number 30 across controllable, controllable 1 but when I add controllable 1 to the table it does not show the total of both it still shows 3. So I would like the table to combine the count for each value separately per reviewer.
    Hopefully that makes sense.

+ 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] Pivot Table - Show to separate fields of data in Values (as rows not columns)
    By Harribone in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 02-19-2019, 01:32 PM
  2. Macro to search a range with multiple combined values
    By COURTTROOPER in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-01-2017, 02:27 PM
  3. [SOLVED] How do i Summarize values from multiple sheets using vlookup combined with...?
    By BillaBoo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2016, 07:43 AM
  4. Replies: 37
    Last Post: 09-15-2015, 06:32 AM
  5. [SOLVED] 40K Rows with multiple values combined with duplicates removed
    By jthoogie in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 04-01-2013, 04:59 PM
  6. How to Show Multiple Data Fields in Columns in a Pivot Table?
    By m3atball in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2012, 12:18 PM
  7. [SOLVED] Why do old, unused values still show in my Pivot Page fields?
    By NateBrei in forum Excel General
    Replies: 3
    Last Post: 08-10-2005, 12: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