Hello Manjula Raj,
Thank you so much for providing a workbook to assist with this. I updated the workbook with a "Both" option. For this to work, i have added an additional Parameter option of "Both". I have then updated the field PnL to include an option for when "Both" to use Outright and then I created another field that is Null when Spread or Outright is selected but is equal to Spread when Both is selected. This field is set as a secondary axis on the view. Will that work?
I saved this in version 10.3 since no version was mentioned.
field "For Both selection" - If [Spread/Outright]='Both' then running_sum(sum([Spread PnL])) else null end
And for updated PnL -
IF [Spread/Outright] = "Spread" THEN [Spread PnL]
ELSEIF [Spread/Outright] = "Outright" THEN [Outright PnL]
elseif [Spread/Outright] = "Both" then [Outright PnL]
I hope this helps.
Please consider marking this post correct or helpful if it assists you with a resolution to your question.
Always Short Development_pv.twbx 16.1 MB