Hi Gurus,
i would like to know how to use selection in an hierarchy.
I have a sheet with hierarchy and would like to have the possibility to select one element of the hierearchy and display the level of the hierarchy.
I would like for e.g to select "Lisou" and get the hierarchy display as see sheet test von K3 bis P13 and showing in the table Test the values of "Lisou".
Thank you for your input.
Cheers
Bookmarks