Hello Friends,
I have a hierarchy under which I need to restrict to just few nodes and subnodes. I don't want to see all the sub nodes under few nodes and at the same time I need to see just few nodes and not subnodes under them. When I say restrict and pull all the nodes and subnodes I need in the report it shows all the values under each of them.
How can I avoid this?
Ex:
World
...-> America
........-> NJ
........-> NY
...-> Europe
........-> Paris
........-> Germany
...-> Asia
........> India
..............-> Hyderabad.
In the above example I need to see values in my report row as:
America
Germany
Hyderabad
Any idea will be greatly appreciated.
Thanks,
Nikki