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

[pcarrington10]

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

[JeteMc]

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.

[pcarrington10]

Hi JeteMc,

thanks so much for this, looks really helpful!

Thanks again

[JeteMc]

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