1 Reply Latest reply on Aug 23, 2016 2:56 PM by hannah.johnson

    Tableau- LOD Expressions- Creation of dynamic Reference Lines

    Unnikrishna Nair

      Hi all,


      I am newbie to tableau and I am facing an issue with creation of reference line that varies according to all the other filters but not product name filter in the example specified.  Here the purple line which is the reference should vary according  to the filter selections  of Category and Sub-category but not product filter where as the other blue line should vary according to all the selections including product selection.


      I tried using EXCLUDE Function but it didn't work I used it as


      {exclude [Product Name]: AVG(PROFIT)}


      Help much appreciated.


      Please find the file in attachments



      tableau doubt1.PNG