5 Replies Latest reply on Dec 8, 2016 8:07 AM by Shinichiro Murakami

    Dynamic Target Line by Filter?


      Hi Tableau experts,


      This may be a newbie question, so please bear with me.


      I have one workbook tracks the following:

      1. Actual volume by state by month
      2. Annual and monthly target


      What I want to achieve is to be able to display monthly target line for each state across multiple months. If I change from one state to another, then target line will also change to corresponding target for that state.


      I searched through forum and seemed that reference line would be logical choice, some also mentioned calculated field. However, I'm having challenges in getting it to work.


      Workbook attached below, and I'd love to hear your thoughts.