Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See the attached example.
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])
I don't understand it pls clarify
See the attached example.
Thanks