Using quick filters, I am allowing the user to select product category A or category B to filter a bar chart, or both "category A and category B". I did this by allowing the "All" filter value to select both categories.
The group executive is passionate about being specific and explicit in our chart titles, and including the selected category in the title. I used the "insert" function in the title to add the category next to the sheet name and accomplished this. However, when "All" is selected, the title shows "all" by default, and the business can misinterpret "All" in our case. We really need to show that the 2 specific categories are included in our data.
Is there a way to make it display "A and B" instead of "all" in the object title?
Compute using advanced setup:
And title I'm just surfacing what is on the marks shelf which is c.previous in this case
