SUM with where condition and ignore certain selections

[matthewp]

I want to SUM(value) WHERE type = 'TOP' but i want it not to be affected by selections made in the 'com' and 'mon' fields

[sunny_talwar]

May be this

Sum({<type = {'TOP'}, com, mon>}value)

[Miguel_Angel_Baeyens]

In general when you want to avoid in an expression a field value or state of selections you use the syntax in set analysis like

Sum({< Field1 =, Field2 = >} Value)

All selections in Field1 and Field2 will be disregarded.