need help,reducing the columns to get a clean single line graph.

[#1]

Hi all,

Can someone help me with the following issue please???????????????????

as attached in the file,I have a table with 3 columns and the same represented in the form of a line graph.

Now I want to reduce this table into just 2 columns keeping my strike_price1 as a dimention and the net as an expression so that I get a single curved line in my graph.

Please can anyone help me out with this??????

[tresesco · Accepted solution]

Try this expression:

=Sum(Aggr(sum({<xoptiontype_,buy_sell,strike_price>}(Nominal_Quantity))* $(voption) ,strike_price1,strike_price))

[SergeyMak]

Try this expression

Sum(AGGR(sum({<strike_price,xoptiontype_,buy_sell>}(Nominal_Quantity))* $(voption),strike_price,strike_price1))

and strike_price1 as dimension

[#4]

Thankyou all.