Show the total value at the top of stacked bar chart

[shahar_potash]

I want to show the total value on the top of the stacked bar chart.

I created an expression that sums the columns of the chart

(expression= cloumn(1)+cloumn(2)+column(3)...) and in the display options menu i ticked on the "Values on Data Point" option.

It works fine and i see the total value at the top of the stacked bar, but when some of the columns have a negative value i see the total value at the bottom of the stacked bar in addition to the top.

I want to show the total value only at the top of the staked bar even when some of the column have a negative value.

Any idea?

[kaushiknsolanki]

Try this,

Fabs(Column(1) + column(2) + column(3))

Regards,

Kaushik Solanki

[shahar_potash]

Thanks about the answer..but same result

[avinashelite]

Uses Fabs() function

[shahar_potash]

its doesn't work..

[arasaraja_cts]

Hi ,

Please share a sample application.

Thanks

Raja

[rohitraut]

Hello Shahar,

PLease find the .qvw.

Hope this help!