Take the right value on my table

[#1]

Hi guys,

I'm in trouble and I need help.

I have imported a table with n fields:

Area

District

Name

Money

....

If I select a Name from a listbox, I'd like to have the corresponding Area.

I've tried to use FieldValue and FieldIndex  functions but unfortunately there's no correspondence with FieldIndex and the correct record on my table.

For instance:

If I select "John" from my listbox, the FieldIndex functions give me as result for John 10 (FieldIndex('Name','John')) , but if I try to do FieldValue('Area',10) I don't receive the correct Area.

Do you know how to solve this problem.

Thanks in advance

Regards

Giampiero

[Gysbert_Wassenaar]

Can't you just use the fieldname Area as dimension in your table? If you select a value in a listbox then the records in your charts and tables will be filtered on that value. The associated values in the other fields will be shown in the dimensions in your charts and tables.

[#3]

Hi Gysbert,

Thank you so much.

Unfortunately I can't do that but maybe I found a way to solve the problem.

I found a thread that helped me.

Using this expression

=MaxString({$<Name={'John'}>} Area)

It seems to work fine but I go on with my test to be sure.

Thank you so much

Regards

Giampiero