This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

MDX: Percent of Specific Account Member

July 3 2012 at 8:53 AM
No score for this post
 
from IP address 66.199.0.164

Hi,

I am new to MDX and despite my research I'm struggling with an MDX formula. I'd like to calculate the % of lower level accounts to the sales account ("%REV"). This will be used as a member formula and will be used in the following example:

_______________JAN__________FEB
_______________ACT__%REV___ACT__%REV
ACCT-49999_____100__100%____90___100%
ACCT-60110_____60___60%_____60___67%
acct-60120______10___10%_____9___10%

Since I'm new I'm not sure if I've provided enough information to be helpful. Happy to fill in any gaps.

I'd appreciate any direction that can be provided.
Thank you.

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. Re: MDX: Percent of Specific Account Member - Gary Crisci on Jul 3, 9:29 AM
    1. Re: MDX: Percent of Specific Account Member - Rush on Jul 3, 10:24 AM
      1. Re: MDX: Percent of Specific Account Member - Gary Crisci on Jul 3, 12:56 PM
     

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.