Custom expression

[miranrai]

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.

[tresesco · Accepted solution]

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

[Anil_Babu_Samineni]

Or This miranrai

I've done simple add Dimension called EXPOSURE with short Expression Sum(EXPOSURE)

[miranrai]

Thank you Tresesco