Matrix Hierarchy in rows

[ggmm17]

Hello there, 

I am using an entity hierarchy in the rows of a matrix. The current display of the hierarchy is as follows:

L9 A

 L8 A

  L7 A

   L6 A

    L5 A etc 

L9 B

 L8 B

  L7 B

   L6 B

    L5 B etc 

*Here, I would like to display Total L9 (A+B)

However, L9 is the parent and ideally would like to display it at the bottom of each level group as a subotal. How couls I achieve this?

Many thanks

[ggmm17]

thanks @Anonymous that is useful, however what im looking to do is to have L9 at the bottom of A and B sections as a subtotal of 2 hierarchy levels instead of having one L9 after A and other after B. 

Hope it makes sense? thank you

[Anonymous]

Hi @ggmm17 ,

The effect you are talking about does not seem to be achievable. This is the effect that I try my best to get close to.

As you can see, L9 (A+B).

I chose the "Outline" layout and turn on the "Repeat row headers" to implement.

Best Regards,
Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous]

Hi @ggmm17 ,

Thanks for reaching out to us.

I don't know if I truely understand your requirement. You only need to swap the hierarchical relationship to make L9 contain A and B, as shown in the following screenshots.

If you still have doubts, please provide us with more detailed information.

Best Regards,
Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly