MDX Calculated Member Help -
11-21-2005
, 06:28 AM
I'm using the following formulas to create calculated members to show
percents of Dimension Product:
Formula 1:
[Sales Dollars] / ([Sales Dollars], [All Product])
Formula 2:
IIF(IsEmpty(([Sales Dollars], Product.Parent)), 1,
[Sales Dollars] / ([Sales Dollars], Product.Parent))
What I want to know is if it is possible to create a single formula for
all dimensions (Products, Cities, States, Countries...)
If I put dimension Product in rows it shows de percent for Products, if
a put Cities it shows the percent for Cities....
Thanks,
LCDM |