This content has been marked as final. Show 4 replies
If the column set to prompt no matters what (column is present,or not, excluded or hidden) the prompt should work.
Check it again something might gone wrong.
If it is helpful, please mark as correct or helpful
"Should" is the right word. But it does not. At least not in 188.8.131.52. Hierarchy prompt only works when the hierarchy column is visible
Edited by: user1104578 on Jul 2, 2012 10:16 AM
Venkatesh, user1104578, did you find a workaround for this? I really don't want to include the hierarchy column in my report and putting it in the Excluded section causes the filter to not work anymore...
Don't put it in the excluded section. Instead mark the column as hidden in the criteria and make sure the column is included in the report. If the column is in the excluded section, you are right, it would not filter.