I have a query which has hierarchies on 3 different objects. I have these 3 objects in the rows which should be 'displayed as a hierarchy' but after that all the remaining objects shouldn't be displayed in the hierarchy.
Is this possible? Example I have Country,State,Cities which should be in the form of a hierarchy but fiscal year as a seperate object and not part of the hierarchy.
Please let me know if I have to explain further.