Set Analysis Exclude and Include null

[vardhancse]

Hi All,

Have a requirement is that,

expression:

Sum{$<[Group]={'*'}-{'I'}>}(Sales)

As per the above expression, we are getting sum(sales) where Group I were excluded.

But the issue is that null values were not getting included.

I want to exlude Group I and include null as well.

Is there a way using set analysis.

[tobias_klett]

No that's not true. Did you mark "Surpress when value is null" on the dimension tab of the Chart?