I recently read "Percentage of Parent for all dimensions" thread ...To say the least, it was eye-opening...The amount of effort and detailed explanation that Tomislav Piasevoli put in was tremendous and helpful. I'm doing the same thing for our BI requirements, and I practically copied the entire code and see that it works for dimensions that are being identified on both Axes (Column / Row). However, the code is not a perfect solution for my situation.It seems that the calculation only works for any single Dimension on each Axis.ÃÂ If I select more than one dimension onto the Colum / Row axes, the results came out incorrectly for the inner dimensions.
Note that: The possible dimensions that will be used for the "Ratio to Parent" are as follows:
View Complete Post