Change the order of a hierarchy

[Anonymous]

Hi all, 

Is it possible to change the order of a hierarchy? I have this hierarchy with this particular order, but the users want to change some items to other levels, for example, to have an item in level 2 called Gross Customer Contribution, and to change this item to level 1 (image: example) it is possible to change the estrututura of a hierarchy? I've been searching for the PATH and PATHITEM formula, is it possible?  The problem that concerns me is also the aggregation of values ​​when changing the order of the hierarchy if the values ​​are correct.

Kind regards. 

[v-piga-msft]

Hi @Anonymous ,

By my tests and research, I'm afraid that we cannot change the specific level of the hierarchy in matrix currently.

The PATH and PATHITEM formula always help users manage data that is presented as a parent-child hierarchy in their models. 

Best  Regards,

Cherry