Prompt values in header when rows use Descendents of Prompt value
Is it possible to setup a report to display the selected Member (Department/sub-division/division/executive level) when the report rows are based on the descendents of the Prompt value?
I've tried the suggested solution of adding it to a hidden row, but I keep getting the first row of data in the header, not the value that was selected in the prompt.
Is there another way to reference prompts to include them in the header information?
New to financial reporting studio, so I've only been playing around with things for a couple weeks.
Thanks,
Chris