1 2 Previous Next 17 Replies Latest reply on Oct 6, 2018 11:15 AM by siva Nageswara Rao

    Fix the Dimension irrespective of filter change

    siva Nageswara Rao

      Hi,

       

      I have a requirement of showing a Target line by Tenure Vs Years data by Tenure.

       

      I have plot the Line chart using the Dual axis for Target and Years data. I have a Year filter and based on the filter selection no. of lines per year will vary. I want my Target line should be fixed irrespective of Year filter selection.

      But I'm unable to achieve that.

       

      for example, If I have 45 Tenures in 2014 and Target line is plotting for 45 months, if I select only 2015 it has only 25 Tenures because of this my data got filtered and Target line is varying. can you please tell me how to fix the Tenure (months) irrespective of Year filter selection.

       

       

      Capture.JPG

      I want fix this tenure dimension/Measure fix irrespective of filter selection. Attached the sample workbook.

        1 2 Previous Next