...
Please, see an example below:
- The waterfall shows the positive or negative contribution of a region or any analytical dimension member to the deviation between budget and actual for an account. This can be a change between categories within a month but also a change over a time period (i.e. variance). When you click on one of the red or green bars behind a product you can choose to drill down or to show detail. When you choose to show details the bar charts on the right show the details for that product. When you choose to drill down the bar charts on the right will also show the details for that product and the waterfall will drill down one level in the entity hierarchy. In this example we are looking at the Net Profit account that you can select and change via a pick list (1A).
- With this button you can choose whether you view the data in the waterfall graph from a base member perspective or from an aggregated perspective.
- You can select compared categories, by using a pick list
- With this button you can switch between regular view and zoom. The Regular view shows the waterfall from zero to the highest value and zoom shows the area where the actual variance is.
- The top right bar chart shows the account (1A) for the dimension in the POV in two categories for the current and previous 5 months. You can look for further details by clicking on any bar behind an account in the waterfall and choose show detail or drill down. The displayed categories can be changed in the business settings.
- The bar chart in the right bottom shows the variance. You can choose between variance in percentages and absolute values.