Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Richard,
You may write like this in an expression tab:
Count(distinct {<Column1={'A','B','C'},Column2={'US','UK'}>}Column3)
Regards,
Brijesh
Hi Richard,
You may write like this in an expression tab:
Count(distinct {<Column1={'A','B','C'},Column2={'US','UK'}>}Column3)
Regards,
Brijesh
Hi Brijesh,
Thank you for quick support. It worked.
Regards,
Richard