5 Replies Latest reply on Nov 3, 2016 5:15 PM by Keshia Rose

    Running Total based on Action filter

    nataraj.vijayanagaram

      Hello,

       

      Looking for some help to solve a tricky requirement. I have a line chart which is month on month using a running sum. Next to it I have a bar chart which shows the end / sum value. When a user selects a month, I want the bar chart to show sum of all the values till that selection.

       

      Example - When the user selects September in the line chart, I want the bar chart to sum up all the values till September and show the total in bar chart next to it instead showing the value only for the month. Attached the workbook for reference

       

      Can anyone please advise on how this can be achieved.

       

      Thank you!