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:
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.
I can probably help with this, but I don't understand your example.
You show Jan Act for 49999 is 100 and %Rev is 100%, then there are other members that I assume are siblings. If you sum the siblings you get 170%. In Feb the Act number goes to 90 but still stays 100% and for 60110 the number stays 60 but the percent goes to 67%. I have no idea how the math is working here. What are your numerators and denominators?