I have a bar chart where i am unable to sum up negative values.
it sum up only positive values but not the negative values. can any one help?
Alternate way to show sum is
Remove Value on Data point from Expression Tab
Add one more expression, untick Bar and tick values on data point
SUM(Total <car> balance)
in your example you are saying that car c is showing 2000, it is correct. what are your expected values? for car c you have only one value which is 2000 so the sum will be 2000.
if you mean that for car b it is showing 2000 and -1000 and you want the sum to be 1000, then you need to remove the year dimension from the chart.
Add a second expression: if(Column(1) > 0, sum(total <car> balance), '')
Then turn off "Values on Data Points" for the first expression
Turn on "Values on Data Points" and turn off "Bar" for the second expression