How is your action working?
If you could provide a sample workbook, will be much easier to people help you address your problem.
I am attaching the screenshots of the filter which I have used and also the
number of countries in the worksheet and the filter (showing the number of
countries) in the dashboard.
Also let me explain my problem again, I have a list of 23 countries out if
which I showed a Top 5. All is fine, except when I put the worksheet in the
dashboard and i show a filter (allowing the target audience to drill down
to the country of their choice), the list shows all the 23 counties, which
I don't want. I want the filter list to show only those 5 countries.
Thanks in advance.
PS - File 204044 shows the filter formula
File 203917 shows the 5 territories which i want to show
File 203851 shows the filter in the dashboard showing all 23 countries.
On Jun 11, 2017 7:10 PM, "Zhouyi Zhang" <firstname.lastname@example.org>
It is really helpless with your screen shot, I have no idea about your issue without a sample workbook.