Displaying a reference Line in a chart when name selected

[Brip51]

Hi,

I am creating a chart that tracks revenue amounts by a particular person,.  I want to create a reference line for a quota for each person, but only display the reference line for the person when that person is selected.

I can get as far as selecting ANY of the names with -

=if(substringcount(getcurrentselections(),'FeildMarketName')>0,70000000,0).

I want somthing like -

=if(substringcount(getcurrentselections(),'FeildMarketName') = 'jay',70000000,0) ... That does not work.

I need to get to-

If the value selected for FeildMarketName = A then display the reference line at B value.  I know I need some set analysis, but I cant figure out the syntax

Any suggestions or help would be greatly appreciated

Brian

[MK_QSL · Accepted solution]

UPDATED:

=IF(SubStringCount(CONCAT(GetFieldSelections(FeildMarketName) ,'|'),'jay'),70000000,0)

[Brip51]

Hi Manish,

Perfect.  Thank you.  It seems so simple NOW!!!!

Brian