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
Bookmarks