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

[vishsaggi]

IF yes, then you can write like in your expression

= IF(GetFieldSelections(Year) = '2015', Sum({<Region -= {'r4'} >} Sales), Sum(Sales))

[Anonymous]

How to put in Straight table , I have Current year previous year and third filed is Excluded value.

[vishsaggi]

Can you share your sample app you are working on? I am quite confused what you are looking for and can you put down the values in an excel sheet your expected output?