good day everybody,
I created sheet with 2 different tables with essential data, each table has relevant data based on the filter panel.
let's call them table A with Field_A and Table B with Field_B
Now, to get all the details, I created a container with 3 tables:
- a generic table, that should be visible if none of the fields in previous data are selected (Table A and Table B are hidden) this works
- table 1, which should be visible only if the data in Table A is selected (then the generic table and Table B are hidden)
- Table 2, which should be visible only if the data in Table B is selected (then the generic table and Table A are Hidden)
in the forum I found the formula Getselectedcount. Using this formula:
GetSelectedCount("Field_A")=0 and GetSelectedCount("Field_B")=0 and GetSelectedCount("Field_generic")=0
in theory I do not any fields selected, so the generic table is visible.
then, I tried to modify above formula to show the table 1 S:
GetSelectedCount("Field_A")>0 and GetSelectedCount("Field_B")=0 and GetSelectedCount("Field_generic")=0
but when I select the Field_A in Table A the generic table still visible, but with no item selected, Table 1 still hidden
thanks in advantage for your help.