Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Could you please explain little bit more?
What is your table structure and what is that you are expecting to exclude the value?
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
Please try like this
sum({1<Region -= {'r4'}>}Sales)
But value must be 600 i got by this formula 1300 , Its wrong
What is logic of value 600 and what is year for r3 and 40 you haven't mention year for this
The value i have like :
r1 r2 r3 r4
100 200 100 400
200 400 300 200
The value are shown above
Do you mean r4 should be excluded only when you select 2015 or from the whole table expression?
correct