Null Handling

[sujeetsingh]

Hello Guys,

I am facing an issue :

I have Date as Dimension and i use expression Sum(Sales)

Now i want the exclusion of Brand Type in the expression.

as Sum({<Brand Type=->}Sales)

Now earlier i was having only data for dimensions available with value .

but now after using the set analysis i get a date added and have Value -    (null)

Note:

---I have checked all options with Supress missing and null.

Thanks

[tresesco]

Not very clear about your issue. May be you can try to use a calculated dimension with set analysis and then use, 'Supress When Value is Null' in the dimension tab. Otherwise please share a sample app.

[sujeetsingh]

I am using a group in dimension.

Seems experts are still away from the thread.