I'm trying to build a pivot table in the form of a tree structure.
I am aware of the 'Tree View' but need to explore some other options.
I'm using the Hierarchy function to build my hierarchy view as below in the code segment:
##################################################################
H1:
Hierarchy(NodeId, ParentId, NodeName, , ,NodePath,|, NodeDepth)
LOAD
Node as NodeId,
Parent as ParentId,
NodeName as NodeName,
NodeName as REP_SUB_BS_ITEM,
IS_LEAF,
PRIORITY
FROM
;
##################################################################
My question is this - assuming my maximum Nodedepth is at 8.
Based on the below code - how do I suppress the 9th column from displaying in my pivot chart.
I need to do this as I do not know how many levels I have in the unbalanced hierarchy.
Right now it is diplaying with "-" as in the the attached image.
=pick(match(NodeDepth,'1','2','3','4','5','6','7','8','9'),
null(),
null(),
null(),
null(),
null(),
null(),
null(),
null(),
NodeName9
)
