Multiple Calculation Condition

[#1]

Hi,

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

[Jason_Michaelides · Accepted solution]

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,

Jason

Message was edited by: Jason Michaelides - Changed calculation condition to show condition

[#3]

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.

[Jason_Michaelides]

Hi,

Please post your app and I'll have a look tonight when I get home.

Jason

[#5]

Jason,

I rewied my orignal request to check my data and reapply your formula.

It works now

Thanks again

[Jason_Michaelides]

Jolly good.

[#7]

how would you then filter on 2 selected fields but from 2 different listboxes??