Dear All,

my report(balance sheet) have a hierarchical structure.
The level of hierarchy differs depending on the node.

e.g
Commercials balance
Asset
fixed capital
    xxx
    bbb
current capital
    aaa
      ggg
      fff
    ccc

Initially i hide HierarchyLevel(GroupingLevel)>3

I have two groups(A and B)
Group B(Group per year/Period) show on drill down only.
My objective is that when i drill down from Group B, i showthe last level of the node
e.g show ggg if it is the last level of the node current asset

Is there a formular to help me identify the last level of a hierarchy?

Thanks in advance



Edited by TheWatt - 22 Feb 2017 at 9:24pm