topic Re: Matrix Hierarchy in rows in Developer

Matrix Hierarchy in rows

ggmm17 — Tue, 28 Jan 2025 22:29:36 GMT

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

Re: Matrix Hierarchy in rows

Anonymous — Wed, 29 Jan 2025 06:10:13 GMT

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

Re: Matrix Hierarchy in rows

ggmm17 — Wed, 29 Jan 2025 09:27:59 GMT

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

Re: Matrix Hierarchy in rows

Anonymous — Tue, 04 Feb 2025 03:20:34 GMT

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