Can't handle Negative Value in Waterfall chart

[Anonymous]

Hi Everyone,

I need help to develop waterfall chart with negative values, chart structure change wherever we get the negative value.It will not be able combine /merge/stacked all the value for the country with the negative value

[vishsaggi]

Try this in your Bar OffSet Amt1 expr:

= IF(sum(Amt1) > 0, Sum(offset))

[sunny_talwar]

Not sure why it works, but it seems to work

Added a bar offset on Amt3 expression

-Sum(offset)

[Anonymous]

your output is quite wrong.This is not the required output as shared by you

See the attachment of  output in your application

[Anonymous]

If I do so then this chart will not be a waterfall chart anymore.See the output shared by you

[Anonymous]

Position of Amt1 for Greece should be same and Amt2 and Amt3 should be combine with Amt1 as in other bars

[Anil_Babu_Samineni]

This?

[Anonymous]

yes  hope u haven't apply the fabs function ,as we can't change the value

[Anil_Babu_Samineni]

I don't think Whether we have that control in Waterfall chart. May be work around with two objects? Your customers likes work around?

May be marcowedel‌

[Anonymous]

please share what you have done