Local member issue on row axis with option zero values removed?

[former_member247531]

Hi Experts,

I have a profit center and account in row axis and time in column axis.

I have used remove empty and zero values on row axis .

I want to use local member on row axis for some calculation but it does not work when there is no specified account .

Can some one help me on how to achieve this? Thanks.

[former_member247531]

Hi Vadim,

Thanks for your reply, Is there any workaround for this other than dimension member formula?

[former_member186338]

No workaround!

If there is no cell on the report that is used in local member calculation then local member will be invalid.

And with remove zero and empty record any line can be removed, even account 4 🙂

[former_member186338]

Local members work only with data presented on the report!

In this case you have to create new member with dimension member formula!