Dynamic Reference line (Based Upon Filter)

[#1]

Hi All,

I am trying to create a dynamic reference line that will change position based upon the filter(s) selected.

For example, if I select the filter 'Carrot' in the group 'Fuit and Vege' the reference line should be '=10000'. If nothing is selected the reference line should be '=20000', if I Select 'Apple' and 'Carrot' (2 filters)  the reference line should be '=15000'.

I am trying to avoid having to change my actual data set to include something that will allocate Carrot to be 10,000 (for example).

Does anyone know the expression I can use within the reference line to create this reference line?

Thanks in advance for your help, and please feel free to ask any questions for clarification!

[settu_periasamy]

May be there is good suggestion.. Try this also. -> Reference lines in the Presentation Tab

=if(GetSelectedCount(Dim)=1 and WildMatch(Dim,'*Carrot*'),10000,
if(GetSelectedCount(Dim)=2 and WildMatch(Concat(DISTINCT Dim,','),'*Carrot*') and 
WildMatch(Concat(DISTINCT Dim,','),'*Apple*'),15000,20000))