Line Chart Design: Can't show a calculated variable like a entire in of a dimention

[Former Member]

Hi everybody

I have a little problem on SAP BO 4.0.

I want to display the next crosstab like line chart :

But the column "Total", is a calculated field, the rest is a "Zona SM" dimention, i can to do the next line chart

with the next Assing Data:

But when i want show the field "Total:", the formula is applied to each value of the "Zona SM" dimension as follows:

then we have the next chart:

That isn't correct because i want show as follows:

Thanks a lot for any suggestion

Kind Regards

[former_member189638]

Check the below blog and let us know if it fixes your problem.

[former_member189638]

Looks tricky. You might need to merge 2 charts for this,

[Former Member]

Thanks a lot Rakesh

Your answer is really awesome!!!. That trick is very useful

Thanks again for you help