In one of the charts there is a cyclic drill through which has 1. Parent Company 2. 'Child ID-Child Name'.
When Parent Company is shown as the dimension in the chart, the search box also shows Parent Company. I have a requirement from the users that when users drill through(/down) to the Child Level the Search box should show ONLY the child level i.e. basically a third search box should replace the 1st one
Thanks for your response. I tried using =GetCurrentField([Cyclic Group]) in a text box and it shows me my current selection from the drill through. But I'm having issues being able to incorporate this function in my conditional show /hide expression. If you could help me perfect that I would be extremely grateful.
Currently my expression which is not working as expected is: