My need is not to select multiple sub-cat but to select a sub-cat and display all the category it comes under along with all the other sub-cats under the category. Let me explain with the below example.
Category Sub-Category Cat 1 Sub-1 Cat 1 Sub-2 Cat 1 Sub-3 Cat 2 Sub-2 Cat 2 Sub-3 Cat-3 Sub-3 Cat-3 Sub-4 Cat-4 Sub-1 Cat-4 Sub-3 Cat-5 Sub-1 Cat-5 Sub-2 Cat-5 Sub-4
For the above data, I want a filter on Sub-Category. But once I select one sub-cat, say Sub-4, I want to see all the sub-category details under Cat-3 & Cat-5 that contain the Sub-4 like the below chart:
Hope you understand what I am trying to achieve here.
That is clever..
But it wont work for me as the SubCat value is dynamic for me..
Nice try man..
I knew that!
Still trying my best.
Did you find any solution for this?
Sorry mate.. still no solution.. guess the way filters work we cannot do it in one sheet
The only way I can think of is using an intermediate sheet to pass on the Category value to view using action filter.
This is the solution I had posted in my 1st post if you are interested in it.