+ 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
    2

    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
    Posts
    385

    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
    2

    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)

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