Set analysis

[bhavvibudagam]

Hi Everyone,

Can any one please help me on below logic.

I have taken the below logic in the KPI, its showing only maximum month related count.

=Sum(if(Aggr(Max({$<MonthYear={'$(=$(vG.CurrentPeriod))'}>}[RAG ind]),[Metric Group],Metric)=2,1,0))

But in another KPI i have to show all the months related count by including [Metric Group] = 'Entertainment' also need to avoid the {"'-'"}, in the Metric group.

Please help me what changes i need to do on the above expression as per the requirement,

Thanks in advance.

[MK9885]

Not sure if the below expression would work?

=Sum(if(Aggr([Metric Group]-={'-'}, [Metric Group] = {'Entertainment'}>}[RAG ind]),[Metric Group],Metric)=2,1,0))

Neglecting '-' and including Entertainment plus not using Max of Months which would give all months, I guess so.