Stacked Bar issue

[alec1982]

Hi Guys,

I have a stacked bar with two expressions in it.

since it is a stacked bar the values that show next on the bars are the Sum of the Stacked bars.

I have noticed that when there is a negative value at one of the stacked bars and positive value within the same stacked bars it doesn't give me the total of both meaning it shows two values the negative by itself and the positive by itself. and the negative value is showing at the other side of the bar.

How can I make the chart to show me the sum of both the negative and positive value as one value?

Sample on a single bar I have two stacked values  -50  and the second stacked value is   120  .. so I need the value on the value on data Point to show = 70

Thxs,

Alec

[#2]

Are you saying that 1 expressions returns a pos number and the other expression returns a neg number? Couldn't you just put together a formula that is the sum of both expressions?

EK

[alec1982]

the reason of having a stacked bar is when you move your mouce above any of the stacked bars you will get the value for it and the value of the data point should show both of them summed.

Thxs,

[bdunphy]

I have this same problem ? Any ideas ?

[alec1982]

I really couldn't find a slotion so i I am not using the stacked bar anymore!

[karolina_]

Has anyone came up with solution for this? I keep trying to have sum of negative and positive...

[michael_maeuser]

have you tried to calculate in the script so that you already have the aggregated value?

s.th. lik

load

dimension a

dimension b

sum(value)

residen table

group by dimension a, dimension b;

maybe then it shows only one value, but not sure

[karolina_]

I guess it's reply to my post.

[Edited] user can choose date so values out of the date range are not counted, but there are 5 options only so script might be good idea or 4 text boxes with rules and no options in chart to show values choosen