Hi,

I need to creat a calaulated expresion with sum( ) as following:

the hirarchy is brand and the children is brand_1, brand_2, brand_3...
and I have 2 measures, one called "brand ftd" and the other "group tfd".

if the dimension is brand.brand_1 than choose the "brand ftd" measure.
if else (brand_2, brand_3... ) than choose the "group tfd" measure.

so the sum( ) will be as ( "brand ftd" measure of brand_1 + "group tfd" measure of brand_2 + "group tfd" measure of brand_3...

Thanks.