set analysis to show only 'null values' in dimension

[#1]

hi,

im trying to get my pivot to show the results of an expression if the dimension (Diag Desc) value = isnull.

e.g. picture below shows my current table (left) and my disired table (right)

I have used the following expressions but none work:

• IF ([Diag Desc]=NULL(),Count({< [WL Type] = {"WL"},[TCI Status] = {"Without TCI"} >} [Hospital Number Weekly Diag]),'NA')
• Count({< [Diag Desc] = {"=Len([Diag Desc]) <4"},[WL Type] = {"WL"},[TCI Status] = {"Without TCI"} >} [Hospital Number Weekly Diag])
• Count({< [Diag Desc] = {" "},[WL Type] = {"WL"},[TCI Status] = {"Without TCI"} >} [Hospital Number Weekly Diag])
• if([Diag Desc]= '-',Count({$<[WL Type] = {"WL"},[TCI Status] = {"Without TCI"}>}[Hospital Number Weekly Diag]),null())

Any suggestions???

[boorgura]

Did you try using isnull([Diag Desc]) instead of [Diag Desc] = NULL().

you can give it a try.