May 13 2022 01:21 AM
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, however it seems to only want to display North America data when no filters are applied in the slicer. I have tried adding a subtotal as a category (for all regions, i.e. to combine UK, Europe, and North America data) but this doesn't work either. Is this even possible? Screenshots below!
May 13 2022 03:38 AM
@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.