Calculated Rows, Limit Hierarchy

[Syndicate_Admin]

Hello everyone

I have the present need,

I have a type column with 3 values: Sales, PendDispatch(+), and PendDispatch(-)

Values1, value2, value3 are calculated measures.

Now I generate an array:

But I want to see the values of PendDispatch as a static row, so that when expanding the hierarchy levels I can only see the level of detail of Sales.

[Anonymous]

Hi @Syndicate_Admin ,

Can you show your expected results in the form of pictures, thank you.

Best Regards,

Xianda Tang

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