Can't maange to filter and group
I have the following issue, imagine the following data master
Header - Cat - Sub Cat
H1 Cat1 SubCat11
H1 Cat1 SubCat12
H2 Cat2 SubCat21
H2 Cat2 SubCat22
H2 Cat3 SubCat31
Now I want the user to go through category by category reducing filtering and generating unique values every time:
H2 -> Selected by user
This implies that next panel 2 will show
Cat3 -> Selected by user
Finally shows the value SubCat31.
Now the problem I have is that I don't seem to be able to select columns of a table like in SQL to apply a filter on. Hence the function "Filter Distinct" applies to the whole data master (and do not filter anything since the Sub Cat values are unique).
This must be a common request and I'm sure you have a solution but I just can't find it and getting a bit frustrated.