Display Hierachy at a set level

[Former Member]

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.

[Former Member · Accepted solution]

Hi Joel,

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.

REDDY

[Former Member · Accepted solution]

Thank you for your reply. Quick question though - does this not restrict the level of the hierarchy to which the Query can expand. For example if I set the diplay hierarchy setting to 3 it shows me the first 3 levels of the hierarchy? I want the hierarchy to be displayed from a set level and not before e.g. from level 3 and not before.