I found. It's very simple see the expression as calculated member in OLAP Enterprise manager:
(100 * [Measures].[Valor] / ([Measures].[Valor], [Hierarquia].[All Hierarquia], [Periodo].[All Periodo]))
so for this measure it is the valor measure by valor measure with sets
i'm using OLAP cube and excel 2000 for pivottable. i want to create a calculated member that shows the percentual of a measure againt the total of this measure. But this value must change on the drag and drop of dimensions on pivottable report. So how this function likes in MDX, there is a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.