+ Reply to Thread
Results 1 to 4 of 4

Pivot tables - displaying "total total" but filtering on elements of list

  1. #1
    Registered User
    Join Date
    05-06-2020
    Location
    England
    MS-Off Ver
    2017
    Posts
    2

    Unhappy Pivot tables - displaying "total total" but filtering on elements of list

    Hi all,

    im not sure if this is possible but i have a big monthly job i could save so much time if i could simply display the averages for one element from my list at a time as well as the total, but if you filter on an element the total recalculates.

    i have NPS for a list of clients, and i deliver a benchmark, so the data is kinda like this:

    company, NPS
    company 1, 0
    company 2, 100
    total: 50

    what i want to create is simple bar charts to show company 1 versus the total average etc, but if i filter on it i get:

    company 1 = 0
    total = 0

    is it possible to create a total, in the pivot table or chart, that will consider all values in the cell

    i cant display the companies in a list as i need to report each companies number back against the benchmark confidentially.

    Thanks in advance for any suggestions you can give

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,654

    Re: Pivot tables - displaying "total total" but filtering on elements of list

    Hello pcarrington10 and Welcome to Excel Forum.
    Linked below is a tutorial for adding an average line to a pivot chart.
    If the link isn't helpful then please utilize the instructions in the banner at the top of the page to upload a small desensitized sample of your data along with the pivot chart that you currently get.
    https://www.excelhow.net/adding-gran...vot-chart.html
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    05-06-2020
    Location
    England
    MS-Off Ver
    2017
    Posts
    2

    Re: Pivot tables - displaying "total total" but filtering on elements of list

    Hi JeteMc,

    thanks so much for this, looks really helpful!

    Thanks again

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,654

    Re: Pivot tables - displaying "total total" but filtering on elements of list

    You're Welcome and thank you for the feedback. I hope that you have a blessed day.

+ 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. Pivot Table..."Grand total chaned to difference"
    By Statz in forum Excel General
    Replies: 2
    Last Post: 06-23-2019, 08:37 AM
  2. VBA to copy Pivot Table "Grand Total" column
    By rw2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2015, 05:33 AM
  3. [SOLVED] Filter Pivot Table with a fixed value called "TOTAL" in Pivot Field Name
    By trizzo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2015, 12:57 PM
  4. Replies: 0
    Last Post: 01-23-2014, 04:13 PM
  5. Pivot Tables: Filtered PT Showing "% of total" unfiltered data
    By ANS in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-07-2012, 05:22 AM
  6. [SOLVED] Macro to delete entire row if cell contains the word "total" or "Total"
    By theatricalveggie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2011, 12:38 PM
  7. [SOLVED] Linking two "total" pages to create a "Complete Total" page
    By Jordon in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-10-2006, 07:20 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