Alternate state in set analysis

[#1]

Hi,

I am facing a problem ...

I have 2 dimensions dimension 1.@_customer_Name  2.@_Item_Name  measure is #_netsales

I have created 2 alternate state groups 1.Group1  2. Group2  considering the @_Item_Name dimensions.

I want to display a straight table where I want to display "the customer wise #_netsales who didn't purchase any items from the @_item_Name listbox which is of  Alternate state - Group2"?

Can anyone please help me?

[#2]

Dimention : Customer

Expession : =Sum({Group2<@_item_Name=Null()>}#_netSales)

[Gysbert_Wassenaar · Accepted solution]

My guess would be sum({<@_item_Name=e({Group2}@_item_Name)>} #_netsales)

[#4]

no.It's giving syntax error.

[#5]

Can u provide some sample data ...

[#6]

Thanks a lot for your help.Working as expected.