Hi Every one,
I have 5 asset classes in my chart and periods are P0 to P1, out of 5 asset classes 1 is OTC Derivative, when I make selection of OTC and Period=P0 values should be added to other periods(P1 to P15) and you can find current chart and it should be change to my requirement.
Make sure that this change should not reflect to other selections.
Current expression is: if(Trad_PRODUCT_TYPE = 'OTC Derivative',sum(Trad_UNREALIZED_PL), if(Trad_PRODUCT_TYPE = 'SFT',sum(Trad_COLLATERAL_VALUE),sum(Trad_CURR_BOOK_VALUE)))
For ex: P0=10, P1=20,P2=5 then if select on OTC P0 value should be added to P1 to other periods.
Like our ex: after selection(OTC) P0=10 , P1=30(P0+P1), P2=15(P0+P2).
PFA for reference
Thanks for your help in advance.
Raj