Can't maange to filter and group

Josselin Guibert shared this problem 3 years ago
Solved

Hi all,


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:


Panel 1:


H1


H2 -> Selected by user


This implies that next panel 2 will show


Cat2


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.


Many thanks,


Jos

Comments (4)

photo
1

Hello Jos,


To use the header values, you may simply use the filter function as seen in the following tutorial:


http://www.justinmind.com/support/fil...


If you require additional help, you may submit your prototype file to jim.support@justinmind.com and we'd be happy to take a look.


Regards,


Luisa

photo
1

Thanks,


I of course seen that but this does not solve the issue as from above explain I need to create unique values.


Kind regards,


Josselin

photo
1

Exported to JustInMind customer support portal

photo
1

Thanks Luisa, note that I sent an email with data to the adress provided above.