Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
We need to build a waterfall chart that bridge the Actual Amount and Budget Amount for an year with Account as the only one dimension.
The start bar should have the Total of Acutal amount for all the account and the end bar to have total of Budget Amount for all the account.
The bars in between to have the account level variance (Actual - Budget). The number of account (dimension) appearing in the chart is
dynamic based on the user selection.
Can anyone suggest how to build the solution?
Regards,
Rajesh
To make a waterfall charts you need to use the function Bar Offset in a barcharts.
You can find that by using the + infront of your Expression.
In the field Defination you can define where you want your bar to start.
Is this what you are looking for?
Hi Dennis,
Not really,
The problem is in plotting single start bar (sum of Actual for all accounts) and ending bar (sum of Budget for all accounts) with multiple bars for variance bridging the Actual and Budget.
Bridging bars (variance of Actual and Budget at dimension account) is plotted perfectly using offset.
Regards,
Rajesh
Can you share some date in Excel and an example of how you want the outcome to be?
I am pretty sure it is possible.
Hi,
I often use waterfall chart which are the most accurate point of view for "evolutions", meanings budget to realized or Past year/ YTD.
As said by Dennis, you must use offset possibilities.
Each must be expressions, without dimensions:
Start bar
First bridging bar
scd bridging bar
...
Final bar
At your disposal for help.
regards,
Ludovic