Find the value excluded

[Anonymous]

hello everyone,

I have to find the excluded value.

Ex:

Year

2014,2015

Region:r1,r2,r3,r4

Sales :10,20,30,40,50

Once i click on year (2015)I have to excl

[prma7799]

Could you please explain little bit more?

[vishsaggi]

What is your table structure and what is that you are expecting to exclude the value?

[Anonymous]

My table is,

Year  Region Sales

2014  r1         10

2015  r2         20

         r3         30

         r4         40

When i click on 2015, r4 value will be excluded and only r1,r2,r3 will show with sales.

I hope it clear

[prma7799]

Please try like this

sum({1<Region -= {'r4'}>}Sales)

[Anonymous]

But value must be 600 i got by this formula 1300 , Its wrong

[prma7799]

What is logic of value 600 and what is year for  r3  and   40 you haven't mention year for this

[Anonymous]

The value i have like :

r1  r2 r3  r4

100 200 100 400

200 400 300 200

The value are shown above

[vishsaggi]

Do you mean r4 should be excluded only when you select 2015 or from the whole table expression?

[Anonymous]

correct