Exclude the selected value and display the Total

[Ramu_i]

Hi all,

I have a county information 

Here 

Country    State   Values 

IND      AP   10

IND     TS    20

IND    KA    30

IND    DL    50      in this way

Requirement:

Filters, Country and State.

Country is IND  KPI display the 110 

If select the state is   AP----110-10=100

If select the state is AP,KA ----110-10-30=70 ...

Total - selected values 

Only selected values for one KPI --- Ap is state  display -10

KA , AP ----30+10 

Here some time country info is there ,Some times country info not there in this case find the country for the state.

Thanks 

Ram

[vinieme12 · Accepted solution]

As below

=sum({<State=>}TOTAL <Country> Values)-sum(Values)

[Ramu_i]

Hi Vinieme,

Thanks for your are valuable solution.

It's working fine.

Regards,

Ram