There are multiple pathway fields which can be selected (REPKPIData_Pathway) and the data will change on the chart. I need to show different reference lines on the chart, depending on what the user selects using the above pathway field. So, if user selects '2WW' I need it to show a reference line at 90%. If they select 'CT & MRI OP' I need it to show a reference line at 75%...and so on.
I've used the following formula, but it doesn't seem to work. Any ideas?