how to make a Tree view listbox to be expanded always.

[shree909]

Hi,

I need some help from the community where i want to make my hierarchy for the list box to be expanded always.

I have two filter

1)Company

2)Hierarchy

First  when the user selects the company the hierarchy to be expanded and it should should show only the related hierarchy to that company.

used  =Aggr(Only({<Hierarchy=>}Hierarchy),Hierarchy) for the  hierarchy to be changed with the company selection.

when he selects the other company then the hierarchy is changing but its not expanding.

I have around 20 companies,  so what would be the best solution..

Helpful answers are appreciated.

Thanks

sree