Waterfall Chart: Color Subtotals like Increase / Decrease

[Dominik_Z]

Hi everybody,

in Waterfall Chart in SAC we want to color a subtotal bar according to its value. We can switch between 3 and 4 colors in waterfall color layout. If we select three colors, subtotal is colored like a total. When we change to 4 colors, we can define a certain color for subtotals. But we want the subtotal bar to change its color according to the value.

In the following screenshot the second bar should be formatted like the following bars. (green or red according to its value)

Is this possible somehow? Am I missing something here. Datasource is BW4HANA live connection. Subtotal is a hierarchy node in BW.

An alternative could be, to not show the subtotal bar at all, but only the child nodes. But I have not found a way to do this either, so far.

Any help is much appreciated. Thanks.

Dominik