Waterfall with "Switch row/column" option : allow to define a starting point / end point.

Etienne CAUSSE

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:

1. Put all colors to black or gray (instead of red/green) ;
2. Reverse the sign of the last "total" block to make it look like it's a total (goes down to 0).
3. 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.