Skip to Content
0
Former Member
Sep 17, 2014 at 03:56 PM

Distribution Ratio by using local member

19 Views

Hi experts,

I want to create the report contains distribution ratio (%) as follows:

Precise:

-Members of the combination of Parent and Children in ITEM dimension are always placed in the report.

-Of course the number of items and item groups are gradually increasing year by year.

Then I want to define "ratio" as a local member.

However, I don't know how to point the cell of aggregate value in the definition of local member such as the row number of "Item Group nn".

What I had tried is:

-use EPMPOSITION : not possible

-use OFFSET function (xls) : not possible

-etc

In this case, isn't it possible to realize the report by using local member... Please teach me how to define it.

Best regards,

Masa

Attachments

WS000001.JPG (54.9 kB)