Waterfall with "Switch row/column" option : allow to define a starting point / end point.
Etienne CAUSSE
Customer
Hi team,
when using the watefall chart, the "Switch row/column" is a very useful option to define each block of the waterfall through specific cubes/formulas.
My typical use is a "margin bridge" with the split of price, mix, volume and exchange rates effects, a classic of business controlling
When I build it, I miss the option to define the block "resulting margin" as a total of the waterfall.
Current workaround:
when using the watefall chart, the "Switch row/column" is a very useful option to define each block of the waterfall through specific cubes/formulas.
My typical use is a "margin bridge" with the split of price, mix, volume and exchange rates effects, a classic of business controlling
When I build it, I miss the option to define the block "resulting margin" as a total of the waterfall.
Current workaround:
- Put all colors to black or gray (instead of red/green) ;
- Reverse the sign of the last "total" block to make it look like it's a total (goes down to 0).
- Use a dataview on top of the chart to display the values, instead of using the labels.
This function "define as a total" is already implemented in Excel for example. When applied to the starting point and "ending" point of the bridge, and sometimes on intermediate points, it is a very practical way to show the data.
8