Set analysis: sum of all values based on selections except one

[xx75]

Dear all I need your help.

I'm trying to specify a set analysis that acts like that:

Totals sales calculated with the active selections (ie Year, product line) but if I select a specific customer, this selection doesn't have to be applied

thank you in advance

[martinpohl]

hi,

with

sum({<Supplier=>} sales)

you achieve that all field selections except in field Supplier is relevant to your expression.

Regards

[xx75]

thank you!!!!!