aggregate multiple aggregation

[Severin]

Hello community

Hope you help me on this Challenge.
I work in an active report in cognos BI 10.2.2  with dimensional model (TM1 cubes).

I have 5 data items, all set with the same logic:

Name : « ProductSet1 », Expression: 

filter ( descendants ( [SameParentMember]  ;3)   ;  [SameAttributeName] = 'Attribute1'  )

I want to aggregate the 5 data items, so I created 5 other data items with this expression:

aggregate (currentMeasure within set [ProductSet1]  )



=> The question is how to aggregate multiple aggregations in one data item?



I tried, with errors, using this expression:

aggregate (currentMeasure within set [ProductSet1], [ProductSet2], [ProductSet3], [ProductSet4], [ProductSet5])



The purpose is to use this one aggregation in series of PackedBubble visualization... so that each bubble tie in ProductSet (In total we would have always 5 specific bubbles). At the same time, this visualization would filter on another chart and crosstab according to the selected bubble.