Each member from entities hierachy has a value for Text1 member.
In the report, I use this member to get the columns needed.
It looks like this
Is there a way to make that Text1 (SSC) into an aggregator, from wich I could expand, or collapse, the columns, like a tree?
I haven't found a way out of the box to do it.
Like Jon G said one way would be to use attributes.
Another option would be to create a UD8 hierarchy with the members as the Text2 values you'd like to aggregate by. So in your case, one member would be SSC. Those U8s would be set as dynamic calcs, and in the calc you could calculate the sums in memory. So if you pulled E#Tot_MainEntity:U8#SSC, on runtime the calc would pull the base members of Tot_MainEntity and loop over those to get you a total to return.
I think you'd have to create alternate hierarchies of the Entities grouped by Text1 although this would create maintenance and require an additional Consolidation/Aggregation.
Another way would be to setup the Text properties as an attribute dimension and then link those members to the Entity Text 1.
