Table - show condition

[motzfeldt01]

Hi,

I have made this table:

Company	Rank	Gross Profit
A	1	100$
B	2	98$
C	3	93$
D	4	90$
E	5	87$
F	6	84$
G	7	82$
H	8	77$

And a filter called "ChosenCompany".

I would like to make a condition, thus the table are only showing:

- the three companies above the chosen company based on rank

- the three companies below the chosen company based on rank

- and the chosen company

Does anyone have an idea how to do this?

[motzfeldt01]

Still not working. Here is what I get:

The company I selected was 'Mercedes-Benz Danmark A/S, which mean the table should only give me other car companies.

I think it's because I need to relate to my variable 'vChosenCompany' in the expression. What do you think about that?

[OmarBenSalem]

Have no idea how ur data is constructed, but this works for me ; I'll attach the test application for u so that u can test it and try to adjust it :

[jyothish8807]

Thanks a lot for your explanation Learned something new