Set Analysis

[rahulsingh12]

Hi,

I have the following table structure.

State          desc          volume

AP               STW          10

MH               STW          20

AP               STR          30

MH               STR          30

RJ               STR          40

I have to write an expression such that in Numerator I have  the following condition:

when state ='MH' Then take desc as STW And sum of volume + when other states take STR as desc and then sum of volume.

so the value will be : 30+20+40

and if some one selects just MH the value is 30 alone no calculation for other states.

Regards

[sunny_talwar]

May be this

Sum({<State *= {'MH'}, desc *= {'STW'}>+<State -= {'MH'}, desc = {'STR'}>} volume)