Adding additional members to each level in item hierarchy
I have item hierarchy like: Item>>Sub Brand>>Brand>>Product Group. Here Item is at the lowest level and Product Group being at top of item hierarchy.
I want to add a new member to each level of this item hierarchy maintaing parent-child relationship. e.g. new member PG1 to product group, new member B1 to Brand, new member SB1 to Sub Brand and new member I1 to Item. This means PG1 will be parent of B1, B1 parent of SB1 and SB1 parent of I1.
Is it possible to create above mentioned members directly in a worksheet using 'create new' method.