-
calculated measure
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|