Skip to Content

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

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.

capture.png (17.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 02, 2017 at 11:07 AM

    Local members work only with data presented on the report!

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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 02, 2017 at 11:26 AM

    Hi Vadim,

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


    Add comment
    10|10000 characters needed characters exceeded

    • 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 :)