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.
7
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 173 Academy
- 332 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 197 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- Board Community Captains
- DACH
- Japan
- 5 Community Captains
- 1 About Community Captains
- 3 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.3K Idea Exchange
- 341 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP