2 Replies Latest reply: Aug 11, 2015 10:26 AM by neetha P RSS

    Help with Waterfall Chart & Dimensions

    Darrell Butler

      I have a requirement to build a waterfall chart that shows the changes between two different forecasts plus the totals for those two forecasts positioned at the start and end of the chart. Ideally on the x-axis we will have a dimension that contains a drill down group (Region, Area,Market etc).

       

      I’m experiencing a few problems doing this,  the expression to get the difference between forecasts is easy and then creating a waterfall for those differences is straightforward. But then plotting the sum of the two forecasts either end of the chart is proving tricky.

       

      Has anybody got a recipe for completing such a task. Attached is an illustration of what I'm trying to achieve.