Sum of All Local Members

[Former Member]

Hi Experts,

Thanks for watching this thread. I want to sum all my local members.

Example:

		Flow
Company	Account
C100	1000	200
	2000	300
	Local Member 1	500(This is Sum of Account 1000+Account 2000)
C200	3000	150
	4000	160
	Local Member 2	310(This is Sum of Account 3000+ Account 4000)
	Total	810(This is SUM of Local Member 1+Sum of Local member 2)

note: Member & Sorting i performed on Entity dimension on Rows

Tested with Insert member before and after block. But no luck

Regards,

Harini.

[former_member186338]

Sorry, but what are your local member formulas? Screenshots?

[Former Member]

HI Vadim,

It is also same as Example what i mentioned.

note: Accounts will change based on user selection in Page Axis. Account Dimension maintained in Page Axis as well as (using "EPMSELECTMULTPLEID") Row Axis. In Row Axis Company Dimension is fixed.

Kindly help me on this.

Harini.

[former_member186338]

I am talking about screenshots of local member setup! Hope it's clear.

Vadim

[Former Member]

Hi Vadim,

This is the example i mentioned in Screenshot. Sorry for the inconvenience the picture was not clear , that's the reason manually i mentioned this example.

		Flow
Company	Account
C100	1000	200
	2000	300
	Local Member 1	500(This is Sum of Account 1000+Account 2000)
C200	3000	150
	4000	160
	Local Member 2	310(This is Sum of Account 3000+ Account 4000)
	Total	810(This is SUM of Local Member 1+Sum of Local member 2)

Regards,

Harini.

[former_member186338]

Unfortunately you don't understand me! What you are posting is not a screenshot! And this is not a EPM report!

You have to open "Edit Report", go to local member tab and make a screenshots...

Then make a screenshot of the real EPM report!

Vadim

[Former Member]

Thanks for the time Vadim, issue was resolved.

Regards,

Harini.