how can i exclude the selected value from the filter while calculating sum

[siddharthsoam]

Hi

I have a list of cities and sales corresponding to it

City  Sales

C1      10

C2        20

C3        30

i want to make a generic expression so that if i select city c1 from filter it should give me 50 in kpi(i.e. sum of sales for alternate cities)

[shiveshsingh]

hi

Please use this expression

=sum({<City =- {"$(=GetFieldSelections(City))"}>}Sales)

whenever you'll select City value from filterpane, sales for that specific City will be excluded.

Thanks