Ignore Selections

[tchovanec]

I have the following expression and I would like to ignore the ISLAND_DEPT.DEPT_DESC selection and show the data for all depts.

SUM(AGGR(IF(FirstSortedValue(
 {<
 ADMIT_DT ={">= $(=NUM(ADDMONTHS(MONTHSTART(MAX(ISLAND_CALENDAR.DATE)),-12))) <=$(=MAX(ISLAND_CALENDAR.DATE))"},
 FLG_Z_PATIENTS = {0},
 >}
DISTINCT DEPT_ABBR,-ADMIT_DTTM)= ISLAND_DEPT.DEPT_ABBR,1,0),MRN,ISLAND_DEPT.DEPT_ABBR)) 

  I have tried the following without any success.

SUM(AGGR(IF(FirstSortedValue(
{1<
ADMIT_DT ={">= $(=NUM(ADDMONTHS(MONTHSTART(MAX(ISLAND_CALENDAR.DATE)),-12))) <=$(=MAX(ISLAND_CALENDAR.DATE))"},
FLG_Z_PATIENTS = {0},
ISLAND_DEPT.DEPT_DESC=
>}
DISTINCT DEPT_ABBR,-ADMIT_DTTM)= ISLAND_DEPT.DEPT_ABBR,1,0),MRN,ISLAND_DEPT.DEPT_ABBR))

Any idea why adding the 1 or ISLAND_DEPT.DEPT_DESC does not work. Any ideas on how to get this to work would be greatly appreciated. Thank you.

[tchovanec]

So you example did work, but the issue is that I do need the Dept list box to affect other charts. So if I do it the way in your example the other charts are also no affected by the changed dept. That is great info about alternate states, I really appreciate it.