Can you please explain me what you are excepting ..I have seen your sample file ,elaborate me..
I checked the workbook. it working fine. In your db shows
A location a,b,c,e
b location a
c location d,e
d location a, b
once you select the a then a will show a,b,c,e and rest will show as a b d e. because some of companies locations are same.
other then that what you r expecting.
First of all, thank you for your answers.
I think I have not explained it well, i will try it better:
When I select company a, the locations shown must be the locations in which a is working.
If I select the a company the result must be:
a, location: a, b, c, e
Rest, location: a, b, e (because c doesn't exist for Rest)
If I select the b company the result must be:
Rest, location: b
If I select the c company the result must be:
c, location:d, e
Rest, location: e
If I select the d company the result must be:
d, location: a,b
Rest, location: a,b
Thanks again for your answer.
First of all I select a company. This company has some locations. I just want to see these locations in the whole table
Thanks sankar but I would like another kind of filter.
When I select a company, this company has some locations. For example d has a & b locations. So I want to filter by the location associated to the company, in this example I just want to see for the company a, a&b and for the rest a&b.
Please, if you need more info, let me know. I don't how to filter by a field of a selected parameter.