Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Supposedly I have a table like this:
Client ID Category
1 No SPMF
1 Hope Fund
2 No SPMF
3 Sinda Bursary
4 No SPMF
4 Sinda Bursary
4 Hope Fund
How do I get an active selection for the clients that not only have 'No SPMF' Category but also other Category(es)? In this case, I should have ClientID 1 and 4 active.
Thank you.
dimension
Client ID
expression
count({$<Category={'No SPMF'}>} Category)=1 and count({$<Category-={'No SPMF'}>} Category)>0