Forum Discussion

JoãoRodrigues's avatar
JoãoRodrigues
New Contributor
5 months ago

Creating Expandable and Collapsible Columns with Text1 as an Aggregator

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 m...
Cube View
Matt-Ha's avatar
Matt-Ha
New Contributor II
5 months ago

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.