Conditional Dimension

[cbaqir]

I have a dimension called DOMAIN. There are two possibilities, ECISA and CAREB.

If the dimension called DESCRIPTION and the LAST_REVIEWED_DATE are the same, I want the DOMAIN to show as A/B instead of one line for ECISA and one line for CAREB. 

For example: DESCRIPTION = NICU (Neonatal) Admission

If the dimension called DESCRIPTION and the LAST_REVIEWED_DATE are NOT the same, I want the DOMAIN on one line for ECISA and one line for CAREB. 

For example, DESCRIPTION = Heparin Infusion for ACS/Vascular (Xa)

Can someone please help me?

[Anil_Babu_Samineni]

Perhaps this?

sum(aggr(Sum({$<DOMAIN = {'A'}>}USAGE),DOMAIN,GOVERNING_CCG,DESCRIPTION,LAST_REVIEW_DATE))/sum(aggr(Sum({$<DOMAIN = {'B'}>}USAGE),DOMAIN,GOVERNING_CCG,DESCRIPTION,LAST_REVIEW_DATE))

[cbaqir]

I am not sure why there is "/" nor the sum function. Can you help me understand?

[cbaqir]

@sunny_talwar Any idea?

[sunny_talwar · Accepted solution]

Try this

=Aggr(If(Count(TOTAL <DESCRIPTION> DOMAIN)>1 and Count(DISTINCT TOTAL <DESCRIPTION> LAST_REVIEW_DATE) = 1,'A/B',DOMAIN), DESCRIPTION, DOMAIN)

[cbaqir]

OMG THANK YOU!!!