2 Replies Latest reply on Nov 25, 2018 1:41 AM by bo.langvad

    Filter on any value in hierarchy, set filter value as top level and get all sub nodes

    bo.langvad

      I am struggling a bit with a workbook and hope to find some help in here.

       

      In the attached workbook I have a small sample of a larger table that defineres a hierarchy from our ERP system.

       

      I want:

      - to be apple to filter on a node id and having the node (as top node) and all the subnodes below

      - have the selected filter value (node value) as the first level

      - the user must be able to filter on any value

       

      Example:

      If I filter on "A-Lund" which is a level 05 value I want to leave out level 1-4 + A-Gen, A-Xel. "A-Lund" has three levels (level 05, level 06 and level 07).

      If I filter on "A-West" which is a level 06 value I want to leave out level 1-5. "A-West" has two levels (level 06 and level 07)

       

      Hope someone can help me on my way.