11 Replies Latest reply on Oct 9, 2014 1:56 PM by Todd Perlmutter

    Determine which level of a hierarchy is active (expanded)

    John Liska

      Is there a way to determine which level of a hierarchy is currently active (expanded)?

       

      I have a 4-level hierarchy in my worksheet:

      Capture.PNG

       

       

      The user can expand or collapse this hierarchy as necessary, so at any point in time the lowest level of the hierarchy that is active could be hierlevelA, hierlevelB, hierlevelC, or hierlevelD. I would like to create a calculated field off of this info, basically something like this:

       

      IF [lowest level of hierarchy = "hierlevelA"] THEN

           200

      ELSEIF [lowest level of hierarchy = "hierlevelB"] THEN

           MAX(Sales)

      ELSIF [lowest level of hierarchy = "hierlevelC"] THEN

           MIN(Volume)

      ELSE

           5000

      END

       

       

      Just curious if this was possible. Thanks.

       

      JPL