Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a bar chart that shows revenue on y axis and months on x axis. The chart is further categorized by cities which are shown in legend as different colors. The bars stacked with each segment of stack representing a different city.
What I would like is two graphs. Both chars have the same as above dimensions and expressions .i.e sum(revenue). The only difference is the offset of bars. Below is the description of both kind of offsets
1) The first graph is such that each Bar is offset by the previous bar expression value. The whole bar stack should move up only by the amount of previous expression
2) In this graph, each bar should be offset by the sum of all previous bars expression values (from first bar till previous bar)
Here is the attached data
Arif
See attached qvw
maybe also helpful?
Waterfall Chart for Bridging data
Waterfall Chart Offest Using Dimensions
Waterfall Chart with Dimension
regards
Marco