Expression

[upaliwije]

I have written following expression and it is working fine.  Here I am computing sum of amount relating dept='BRAN' irrespective of Branch selected by the user. Now I want to calculate the amount for a Region ( A Region consists of  a few Branches and  a BRAN consist of a few Regions) when I select a Branch. In other words when I select a branch ' X ' from list box I want the  Sum of amount of the region where  a few branches including  branch 'X comes under.

(Sum({<[TRN_TYPE]={'R'},DEPT={'BRAN'},BRANCH= >}[AMOUNT])

DEPT    REGION  BRANCH

BRAN      A           X

                            Y

                            Z

               B           P

                            Q

                            R

Pls some one help me to modify above expression. Thanks in Advance

[swuehl]

You can look into using implicite field value definitions, i.e. the p() function, try something like

(Sum({<[TRN_TYPE]={'R'},DEPT={'BRAN'},BRANCH=, REGION = p() >}[AMOUNT])

[upaliwije]

I don't understand it pls clarify

[Nicole-Smith · Accepted solution]

See the attached example.

[upaliwije]

Thanks