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.
