6 Replies Latest reply on Jul 12, 2018 11:26 PM by Ruchi Deshpande

    Add a Reference Line - Using dimension

    Ruchi Deshpande

      Hello,

       

      I have a data on health indicators. I want to create a reference line which will be dynamic using a dimension "Period". This reference line should change with "Program" used in the attached workbook as a filter. The dimension value is "Endline Target" which is under "Period" dimension.

      I tried using "sets" but when I add a reference line it does not show in the "value" field.

      Is there another way to do it.?  I have multiple measures and I would like to plot graphs for each of the measures using "Endline Target" as reference line for both programs "A", and "B".

      Please help.

       

      Regards,

      Ruchi