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
IF yes, then you can write like in your expression
= IF(GetFieldSelections(Year) = '2015', Sum({<Region -= {'r4'} >} Sales), Sum(Sales))
How to put in Straight table , I have Current year previous year and third filed is Excluded value.
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?