Hello Zhouyi Zhang,
Thanks a lot for quick response and it is working fine for me.
Is there any solution for displaying sub-category always on the sheet, suppose if we select none of the values in Region filter then worksheet will be blank. Instead of making it blank I wanted to display the distinct sub-categories. (something like static.)
In that case, I think the best practice is to have two worksheets, one with sub-categories list only and the other one is the one we created above but hide the column header and then put them together into a dashboard.