How to Find a person that has one specific and other categories

[#1]

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.

[maxgro]

dimension         

Client ID

expression         

count({$<Category={'No SPMF'}>} Category)=1 and count({$<Category-={'No SPMF'}>} Category)>0