How to restrict MDX to calculate only at level 0 and not TOP level
SummaryHow to restrict MDX to calculate only at level 0 and not TOP level
I am facing an issue whicle creating a MDX script. I have written an MDX for one of the account members , for e.g.Mem1
MDX on MEM1.
When IsLevel([Period].currentmember,0) Then /* I tried using Islevel and ISLEAF functions */
for the above script when I look data for Mem1 at level 0 for an other dimension (for e.g DIm1) , it is doing the math correctly , but when I look at any of the parent levels for other dimension it is not showing me a sum of all its lev 0 members for Mem1 instead its doing the math as per above script for members at top level across other dimension.