Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

percent of parent

Status
Not open for further replies.

jiuba

Programmer
Jun 21, 2003
3
ES
Hello. I have a problem with the calculated members.
When I have to calculate the total percent for two or more dimension I put this code

([Measures].[Part]/([Measures].[Part ],[Country].[All Country],[Product].[All Product]))

and its ok but the problem if a have to calculate the percent of a ancestor or a parent of two dimensions. If I put this code

([Measures].[Part]/([Measures].[Part],[Country].parent),[Product].Parent)

the result is always bad but if I put this code(the same but only for one dimension)

([Measures].[Part]/([Measures].[Part],[Country].parent))

its ok.

Can you help me please. Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top