Multiple IF condition and Distinct count

[richard24best]

Hi All,

Need your support and advice.

I have 3 columns Column1, 2 and 3

want to get an expression -  distinct count of Column3 when Column 1 = A,B,C and Column 2 = UK, US.

Please assist.

Thanks,

Richard

[brijesh_fofadiy · Accepted solution]

Hi Richard,

You may write like this in an expression tab:

Count(distinct {<Column1={'A','B','C'},Column2={'US','UK'}>}Column3)

Regards,

Brijesh

[richard24best]

Hi Brijesh,

Thank you for quick support. It worked.

Regards,

Richard