App Development

[sujayrpatil]

Hello all,

I have to create a waterfall using a Bar chart. So I am creating offset using stacking.

Below is the sample data I have >

Dim 1	Count	Offset
A	100	0
B	15	1
C	20	1
D	30	1
E	10	1

And the required result is as below :

Dim 1	Dim 2	Count
A	Offset	0
A	Value	100
B	Offset	85
B	Value	15
C	Offset	65
C	Value	20
D	Offset	35
D	Value	30
E	Offset	25
E	Value	10

Here when the Offset is 0, result should be 0. when Offset is 1, result should be  count of previous Dim 1 - count of Dim1.

for example : For DIM1 = B and DIM 2 = 'Offset', result should be count of A - count of B ( 100 -15) = 15.

For DIM1 = C and DIM 2 = 'Offset', result should be count of B- count of C ( 85-20) = 65.

For DIM1 = D and DIM 2 = 'Offset', result should be count of C- count of D( 65-30) = 35 and so on.

Request for your suggestions.

Thanks In advance.

Regards,

Sujay.