Set Analysis - overall sum by month

[byrnel0586]

Hi,

Please see the table below:

For the Num column I am currently using this expression to sum the PHARM_NUM_STATUS based on selections and to show a YOY comparison and it is working.

=Sum({<PHARM_Year, PHARM_MonthNum = {"=PHARM_MonthNum = Max(TOTAL <PHARM_Year> Aggr(PHARM_MonthNum, PHARM_Year))"}>} PHARM_NUM_STATUS)

But now for the CP Num  column I am needing to show the overall sum of all data as a comparison, even when a selection is made. I tried

=Sum({<PHARM_Year, PHARM_MonthNum = {"=PHARM_MonthNum = Max(TOTAL <PHARM_Year> Aggr(PHARM_MonthNum, PHARM_Year))"}>} {1}PHARM_NUM_STATUS)

but this is summing all PHARM_NUM_STATUS for the entire year.

Any help is appreciated.

[byrnel0586]

Oh, I am talking about the Star value, not CP Star - that seems to be working. Below are the columns. But they should still point to the same thresholds as the CP Star value.

[sunny_talwar]

You seem to be using a old version of Rate % in your star expression... just updated that and it seems to be working

[byrnel0586]

I'm so sorry, my mistake! Thank you so much for your help!