Barchart which sum / subtracts starting from previous bar

[chriys1337]

Hi,

I would like to build a barchart, which is stating with the highest value from the dimension, and next bar would start at the highest level of the first bar and so on. Also when there is a negative value the bar should "go down".

The standard Waterfall chart is not useable in this scenario, since the values of the dimension can't be defined as adding / subtracting, it dependas from month to month...

Please have a look into my sample application.

Thx for your support.

[lovekeshs]

Hi, if you don't want to use the waterfall chart, another option which left to you is to go far bar chart. 

for example, you have a time series like this you should stack two measures  

Sales month, Sales value 

January, 100

Feb, 200

1st with this formula  ::  RANGEsum(above(Sum("your measure"),0,RowNo())) - Sum("your measure")

2nd with this formula   ::    Sum("your measure")

Colour the 1st one in the white (so that it's not visible) and the second one in any colour. 

If you want to apply different colour for the first and last value then you have to use 4 stacks. 

I am facing a similar problem, the limitation of this is you can't show the segmental value labels, else the label for white portion will also be visible. 

[chriys1337]

Hi Lovekeshs,

thanks for your contribution.

I have just tried your formula, but this is putting all bars (also the negative values) on the x-Axis with starting point 0. I am looking for something like a waterfall, if the first sum of revenue for dimension A is 100, the second value for dimension value B should start at 100 and go higher or deeper from this point.

[anychart]

If I understood you right, you can try this in the AnyChart extension's Waterfall chart.