I have a parent child hierarchy report showing the sales figures (shown in braces here) and the employee names with every employee showing their sales figures against them. This is what it looks like when expanded to the lowest level
Now by default on the dashboard the report shows with everything collapsed, like this
The issue is that there is a dashboard prompt (not hierarchical prompt) using which users can choose for which employee they want to see the sales. So for example if they choose Harry. The way they want report to come up is like this
You see that + sign in front of Harry? means they want that the report gets expanded automatically till Harry and they don't have to drill down from Bob and then Scott to reach Harry. And then they can further drill down from Harry. Similarly for other employees too. Is that possible? Can we have the parent child hierarchy report expanded automatically till the level users have selected the value from prompt?
Please let me know on this ? If there are other workaround, please do let me know too. Appreciate your help.
Thanks for the help srini, but this too doesn't solve my issue. I have a parent child hierarchy and depending upon the employee name which users will select from the prompt, the level of the hierarchy would differ. Like I have shown above,
if they select Harry it would be like this
and if they select Tom it would be
also it might change like this too where they selected Angie, a employee who isn't the descendent of Scott and is of Matt
Basically, the requirement is what ever user they select from the prompt (and this is NOT the hierarchical prompt), the hierarchy is exapanded till that level automatically. I'm really not finding any way to do this?
One thing which would solve my problem is by using the hierarchical prompt for this report and then using the presentation variable capture the employee name which users select in the normal prompt and then default the hierarchical prompt with this presentation variable.
But I guess we can't use presenatation variable in the hierarchical prompt, can you confirm this ?
If you know of any other work around, please let me know. Thanks for your help till now.