Equivalent function to Lookup but for charts

[stascher]

Hello,

Given a table similar to the following:

location	favorite_fruit
Home	Apple
Office	Apple

I would expect to be able to use  the following expressions: 

=fieldvalue('favorite_fruit',fieldindex('location','Home')) or 

=fieldvalue('favorite_fruit',fieldindex('location','Office'))

This works fine if the favorite_fruit values are unique, but if they're the same, fieldvalue() regards favorite_fruit as having only 1 value and thus =fieldvalue('favorite_fruit',fieldindex('location','Office')) returns null. 

Is there any expression that would return the favorite_fruit value for Office regardless of non-unique values? 

Thanks,

Steve

[vinieme12]

why not use a MaxString() ??

MaxString({<location={'Office'}>}favorite_fruit)