Forum Discussion
How to show grand total data when filters are cleared in pivot chart?
I have created a pivot chart from a pivot table (see below) and inserted a slicer. When all the filters are cleared and nothing is selected in the slicer, I want the chart to display the grand total,...
LL19911695 Created a mock-up resembling your example. You could add another Group/Region "All" to the source data using SUMIF, as demonstrated in the picture below. Attached the file as well. Perhaps this works for you.