Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a requirement where i need to calculate based on dimension values in expression.
I have tried to use aggr function but still can't get result what i wanted. I am not sure where i am going wrong.
What i need is, say for AU for PN_Status = 'Z' , value should be sum max values for both X & Y. i.e. , Z = 50.
In attached screen shot
Appreciate your help.
For front end solution, check this:
Expression to be used:
If ( PN_STATUS='Z', RangeSum(max( total <COUNTRY> If(PN_STATUS='X',EXPOSURE)), max(total <COUNTRY> If(PN_STATUS='Y',EXPOSURE))),
Sum(EXPOSURE)
)
PFA
Or This miranrai
I've done simple add Dimension called EXPOSURE with short Expression Sum(EXPOSURE)
Thank you Tresesco