4 Replies Latest reply on Nov 19, 2016 11:55 AM by Yuriy Fal

    Showing running total based on filter

    nataraj.vijayanagaram

      Hi All,

       

      I am working on a small dashboard where I have a table which has a target value and two different values which I would sum up and then compare with Target.

       

           

      MonthTargetValue1Value2
      Jan-161147
      Feb-161558
      Mar-161453
      Apr-161558
      May-161246
      Jun-161347
      Jul-161557
      Aug-161325
      Sep-161254
      Oct-161336
      Nov-161048
      Dec-161423

       

      Also, I would like to setup the first chart as a filter and when the user selects a month, I want the chart next to the month on month chart to show running total till the selected month. Can some one please advise on how I can achieve this.

       

      Here I have attached a sample workbook for reference. Thank you very much for your advise.

       

      Thank you!