Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Waterfall with Opening and Closing Balance

Hello friends,   Currently the Waterfall chart shows one measure by categories. I need to show waterfall with Opening Balance column, then Changes Measure by categories, and finally the Closing Ba...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Cubist Thanks,

    The Opening Balance you've added to the left is not good:

    1. The bar next to it (-400K) shoud start at the top of BOP (230K) and not 0

    2. The EOP should give the actual EOP and not the Delta

     

    So I understand that the solution is to build my own visual or to hire you :)

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

The waterfall chart is not suitable for your scenario, you would need to consider to use other type of visuals. A waterfall chart shows a running total as values are added or subtracted.

The Waterfall chart cannot show a Series, such as Territory or Product, it is limited to one value only. It does not allow superimposing of a line with a secondary Y axis that shares the same X axis. For more details about when to use waterfall chart, please review this blog.


Thanks,
Lydia Zhang