Waterfall Chart

[Anonymous]

Hi geniuses,

I want to create a waterfall chart for a platform which has several BU something like below image

in this YTD budget can be calculated as sum(Budget)

Actual can be calculated as sum(Actual)

and now I want variance calculated as actual - budget and this variance should be in between budget and actual and is calculated with respect to all the business unit in this platform and also those BU is in form of waterfall

Thanks,

Shashank

[jpenuliar]

Have a look at a thread regarding waterfall,

Waterfall and changed behaviour of the Total function in QV11

[Anonymous]

Its not working as I want the YTD Budget and YTD Actuals at the two extremes of the chart

[#4]

You would not do offsets for the YTD Budget or YTD Actual, for the items in between, you would offset by the columns before, so for example

Offset for BU/Sector 1:  Column(1)

Offset for BU/Sector 2: Column(1)+Column(2)

Offset for BU/Sector 3: Column(1) + Column(2) + Column(3)

etc.