Connect two filters through set analysis

[rm1]

Hi everyone,

I'd need to know if there is the possibility to connect 2 filters through set analysis. Consider the following 2 filters

Filter 1 --> field 1, field 2, field 3

Filter 2 --> field 4, field 5, field 6

What I need to know is

1) how to write: if Filter 1 - field 1, is selected then select Filter 2 - Field 2, OR if Filter 1 - field 2 is selected then select Filter 2 - field 4, etc etc

2) how to insert the code above it into a set analysis expression as:  sum (${.....} sales)

Thanks in advance for any hint!

[Anil_Babu_Samineni]

May be think from P() and E() like, Below condition works when you have relation between tables

Sum({<Field1=P(Field4)>} Sales)

[rm1 · Accepted solution]

Thanks for the hint.

I get the results using if and GetSelectedCount nested:

If((GetSelectedCount(field 1)>0), sum(${<Filter2 ={field 4}>}sales),

If((GetSelectedCount(field 2)>0), sum(${<Filter2 ={field 5}>}sales)... and so on...