I want to fix the sum to one field of a list box and I want it to change w.r.t other parameters

[#1]

I have a formula can u tell me what wrong am I doing in it

sum({1<mSeg={'Total'},mMonth={'$(=only(mMonth))'},mYear={'$(=only(mYear))'}>} mRev.)

It works if I have only two list boxes

sum({1<mSeg={'Total'},mMonth={'$(=only(mMonth))'}>} m Rev.)  Working

but when I have more list boxes it dont

I want to fix the sum to one field of a list box and I want it to change w.r.t other parameters

Please Help

Best Regards,

Gaurav Tyagi

[jagannalla]

Hello,

Where are you using this expression. It doesn't matter how many listboxes you have. Anyway you are using {1} i.e. no selections should apply for this chart expression.

Cheers!!

Jagan

[#3]

I dont get this whole {1} thing yet someone gave that expression to it was working somewhere else but not everywhere. Can u elaborate lil more what to use here.

Best Regards,

Gaurav Tyagi

[#4]

if u want to fix month column then use

sum({1<mSeg={'Total'},mMonth= >} m Rev.)

if u would like to fix year

sum({1<mSeg={'Total'},mYear= >} m Rev.)

[#5]

I want to fix just one column and all the rest based on their respective selections

Segment shud fix to 'Total' but its value shud change when I choose different month,year,manager and so on. What shud I do in that case.

[#6]

when you use the modifier u cant fix the value to unchanged