0 Replies Latest reply on Jan 26, 2018 9:04 AM by Osama Shah

    Waterfall chart - Total of prior year becomes first bar, current year changes follow

    Osama Shah

      Hi there, I've got to create a waterfall chart. Here's what the data is like

       

      Dimension = Level 3 >> this contains multiple categories of expenses

      Measure 1 = FY 16  >> this contains the respective Fy16 expense

      Measure 2 = FY 17 >> This contains FY 17 expense amounts for Level 3

       

       

       

      I want the bar chart to look like the attached image and also attaching an image for what the chart looks like currently.

       

      Have read some forums online but they all involve massaging the data source. I can't do too much of that unfortunately as data coming from server (data cube).

       

      Prompt help would be hugely appreciated.

      @santhosh krishnan @ Ben Young