Hi all,

I would like to create a Calculated Member which would make the SUM of:

if the dimension.member is brand1 than choose the brand measure,
if else (brand2 or highier) - choose the group measure.
the sum should calculated brand measure of brand1 + group measures
of brand2 + group measures of brand2 + group measures of brand3 +
...


Thanks.