Hi all,
This may be quite an easy question but I just don't know how to get it done or search for the answer correctly.
I have a table of data and have created a pivot chart. I have added a slicer for the Countries and have a shape box with the name of a country in it.
I have linked up a formula so that when I slice by country, the text in the shape box will correspond with the country 'sliced'. However, when I unselect all, I want the text to say 'All countries', however, because the formula is linked to the first cell in the pivot, it will always show the first country.
So right now when a country is selected the right country is populated in the text box, but when I want to show performance for all countries by unfiltering the slicer, the name of the first country pops up.
I believe my current formula isn't correct and only works when I select one at a time.
I have attached a workbook as a reference.
If anyone can give me some advice and point me in the right direction that would be really appreciated.
Thanks!
Bookmarks