Expression help set analysis

[abhaysingh]

Hi all

i have one field  FIELD whose values are DS and IS, i want to write expression of sales

sum({<FIELD = {'DS'}>} Sales= this give me sales w.r.t DS

sum({<FIELD = {'IS'}>}Sales = this give me sales w.r.t IS

i want to write it in single expression like if i select DS than it will me DS sales else IS sales in single expression....

pls help.

[shree909]

Hi use if condition

If (FIELD = 'DS' ,sum({<FIELD = {'DS'}>} Sales),

If (FIELD = 'IS' ,sum({<FIELD = {'IS'}>} Sales)))

Thanks

[abhaysingh]

i want to write it in set analysis..

[#4]

Set a variable like:
vField  =if(GetSelectedCount(Field)>0,concat(GetFieldSelections(Field),','),'IS')

then use the Expression:
sum({<Field={"$(vField)"}>} Sales)

[#5]

Maybe like attached? Similar to above posts

[manoj217]

so you are asking you have a list box if you select DS it need to show sales WRT DS right

[manoj217]

if (getfieldselections(fields)='DS',sum({<FIELD = {'DS'}>} Sales,sum({<FIELD = {'IS'}>}Sales)