I have a scenario of showing Level wise Materials in pivot table.
We have some levels defined from 1 to 12. And each material is associated with Levels. There is a hierarchy of Materials. Level 1 Material has Level 2 Material,Level 2 has Level 3 and so on. All these materials from any level are defined in the same column. To identify which material comes under which Level we have a Node and Parent value. Also we have a column that says whether material is Expanded and Leaf. If material has a child then it is given a flag as Expanded, And if there is no child then it is defined as leaf.
Please find the attached excel where we have Levels,Material,Node and Parent Value.
Here for ex, For level1 Material BA00003589668, We have Level2 Material BA00002460360 and this level2 MAterial has
Level3 material BA0000247329. Now this is identified only by matching the Parent value with the Node Value.
Like Node value of Level1 Material(BA00003589668) 83445.1 is matching with Parent value of Level2 Material(BA00002460360).
Similar way, Level2 Material (BA00002460360) Node value 0000083445.1-0000083506.12 is matching with Level3 Material(BA00002473290) parent value 0000083445.1-0000083506.12.
This is the only way to identify as which Material falls under which level Material. It also has a state column which says about expanded and leaf.
I need to show this hierarchy in pivot table as like below. But since all the Materials are in same column we are unable to get below view.
Kindly assist. Thanks in advance.