Hi ,
I have 2 member. And I want to make them one item and calculate measures according to it. Please look at the image which is attached .
You could try this expression for your C element.
aggregate ( currentMeasure within set set ( [A], ) )
Hello Ersin.gulbahar,
You can use this expression to create a member..I have used A,B and C as members in your screenshot..
member(
<Measure item that you need to total>,
'C',
'C',
<HIERARCHY FOR MEMBERS A AND B>
)
Then add the set of member A and B i.e. SET([A],) in your slicer for the query.
Hope it helps,
-Cognos810