This can be achieved by "Action filter". Please follow below steps:
1. Create a variable Blank=""
2. Create "Region" sheet with region value.
3. Create a variable with the value that you want to display and drag it to a new sheet(Display), Drag "Blank" to the detail:
4. Create a sales sheet:
Create a Dashboard and arrange all the three sheets sequentially:
Go to Dashboard -> Action
Create first action:
Create 2nd Action:
Select a region and content of display will dis-appear.
You can hide the title of "Display" workbook:
You can refer below link for details description on how it works:
Thanks for responding back. I did the same procedure except I was selecting " All Fields" in the action filter, instead of selected fields.
thanks once again. this solved my issue.