How to make row number in local member dynamic

[Former Member]

I have create multiple local member and the formula I the local member is such as

=SUM(row11+row14+row16)

then I add another couple of row before row 11, now the formula should be:

=SUM(row13+row16+row18)

anybody know is there a way how to make the formula in the local member dynamic, which means that if I add rows of drop rows, the formula in local member will automatically change?

[Former Member]

Here is screen shot I am talking about:

I have two local member at row 8 and row 12, and the local for local member are listed  in column G,

Let assume that one more row is inserted at row 1 as following:

Now the logic for local member is change in column G.

In excel, row number in the formula will change automatically, but the formula in local member will not change automatically.

I am trying to use the member combination to place the local member after row for account 6,

but since the time dimension is dynamic choose by user, the member combination will not allow the dynamic value for the combination,

the member is also not a choice since the same account will used in many row.

Anybody know how to handle this situation to avoid modify the local member formula?

[former_member225135]

Hi Jian,

If you want to sum at product level, you can use this option:

This option will work in the way you want.

Regards,

Rahul

[former_member186338]

Try the following for local member formula:

=SUM(EPMSELECTEDMEMBERS(ACCOUNT))

If ACCOUNT is the name of you account dimension.

Vadim

[rishi4892]

Hi Jian,

You can create local my by "Activate Local Member Recognition", but make sure "Use Position in axis" should be unchecked.

Also make sure you have added all required Local members before any insertion of rows.

Hope this should work.

Thanks,

Rishi

[former_member186338]

Hi Jian,

Do you have some specific row axis members in row11, row14, row16 or???

Vadim

[dinesh_veluru]

Hi Jilan,

Please provide sample report screenshot and the local member formula screenshots for further analysis.

Thanks,

Dinesh.V

[Former Member]

Hi Jian,

You need to determine self reference of the cell, then use offset to find related cells.

Andy