Set Analysis for Modifiers not present

[passionate]

Hi Geeks,

I am using Set analysis to show Product wise sales for every ID.

Eg:- Sum({<Product={'A'}>}Sales)

Please find attached QVW and data file.

Question:

I want to display Sum as Null if no Products are available for a particular id like in below example:

For ID 1 products available are A and B so I don't Want to Show "0" but Null().

Sum(Sales) for a particular product can be Zero or Null()

Appreciate your help.

Thanks and Regards,

Pankaj

[sunny_talwar]

May be use a pivot table or use an expression like this

If(Sum({<Product={'A'}>}Sales), Sum({<Product={'A'}>}Sales))

[passionate]

Thanks Sunny.

What if i also want to show Sum(Sales) as Zero as Well?

[antoniotiman · Accepted solution]

You wrote

Sum(Sales) for a particular product can be Zero or Null()

May be this

If(Count({<Product={'A'}>} Product)> 0,Sum({<Product={'A'}>} Sales))

[sunny_talwar]

What do you mean that you want to show it as 0 and null both at the same time?

[passionate]

Thanks, You both are Gem

Cheers!!!!