Can I create calculated members in levels?

I would like to group some projects into several categories. I know I can create custom calculated members for each categories. But is it possible to have them in a leveled structure? Like when I expand, a higher level sub category should up first instead of all child members right away.


There is an option to create a different hierarchy in the Project dimension. The limitation currently is that only one level can be created with this option:

For that, you need to run the additional data import and create a new property (your category or sub-category) for the project dimension.

Perhaps, then you can build aggregated members on top of this new hierarchy and build another level there:

Janis, eazyBI support

Thank you. It’s really helpful :slightly_smiling_face: