Delta Presentation

[#1]

Hi,

Is it possible to implement the attached chart on QV?

Grey -The total goal of activites

Green - The actual amount of activities

Blue - Delta-  The difference in number between the Goal and the Actual

(My problem is to display the Delta bar like on the attached file)

[swuehl · Accepted solution]

Search for 'Waterfall chart' here in the forum.

You can set a bar offset in your bar chart, so for example, create three expressions with no dimension in your chart

=Sum(Goal)

=Sum(Actual)

=Sum(Actual)-Sum(Goal)

open the bar offset attribute by clicking on the small + sign next to the third expression on expression tab.

Enter

=Sum(Goal)

as bar offset

[#3]

Thanks!!!!! works!