ID names with Mismatched category

[cbaqir]

My goal is to show the DESCRIPTION where DESCRIPTION is the same but there is more than one GOVERNING_CCG.

For example:

What's the best way to accomplish this?

[vishsaggi]

What is your expected output you are looking for and where?

[neelamsaroha157]

may be you can use the below expression to find out the numbers of GOVERNING_CCG by DESCRIPTION

Aggr(NODISTINCT Count(GOVERNING_CCG), DESCRIPTION)

and then use it in the IF condition -

[cbaqir]

I only want to ID those names with multiple CCGs.

[cbaqir]

Can you help me understand this? As a dimension?

[neelamsaroha157]

It is counting number of GOVERNING_CCG by DESCRIPTION. For example in the screenshot there are 2 GOVERNING_CCG for 'Burn Care Adult Admission'.

Note: you can use  - Aggr(NODISTINCT Count(distinct GOVERNING_CCG), DESCRIPTION), if you want to count only distinct values of GOVERNING_CCG.

[cbaqir]

I only want to show/count those names with multiple CCGs. I've tried your suggestions as both dimensions and expressions but I am not getting it.