Display Hierachy at a set level
Is it possible to restrict a query so that it only displays data from a particular level of the hierarchy. for example on our cost centre hierarchy structure I only want to see amounts for level 2 and none from above or below. Thanks.
Yes it is possible to set the level in hierarchy in report to be displayed.
In query designer select the hierarchy for that customer, select Expand to Level and there give the level like 3.