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