4 Replies Latest reply: Feb 14, 2012 2:17 PM by ludovic cousin

# How to build a waterfall that bridge Budget to Actual for a single dimension (account)?

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

• ###### How to build a waterfall that bridge Budget to Actual for a single dimension (account)?

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?

• ###### How to build a waterfall that bridge Budget to Actual for a single dimension (account)?

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

• ###### How to build a waterfall that bridge Budget to Actual for a single dimension (account)?

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.

• ###### How to build a waterfall that bridge Budget to Actual for a single dimension (account)?

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