I would like to display charts or tables only if 2 values from the same filters selected.
I Tried several syntaxes without success such as :
=FILTER = 1011 and FILTER= 1002 or =FILTER = '1011' and '1002'
Is someone could advise?
Thanks a lot
Try this in the show condition:
Concat(DISTINCT FILTER,',') = '1002,1011'
This will mean the chart will only show if both 1002 and 1011 are selected, and no other values.
Hope this helps,
Message was edited by: Jason Michaelides - Changed calculation condition to show condition
Hi Jason and thanks for your quick answer.
I applied your formula and the result is that the table is displayed when i select the two values or any so i'm not yet at the result expected.
In fact the display is hidden only if i select one value or the another.
Please post your app and I'll have a look tonight when I get home.
I rewied my orignal request to check my data and reapply your formula.
It works now
how would you then filter on 2 selected fields but from 2 different listboxes??
Retrieving data ...