Local Member Error

[Former Member]

I have a situation where I need to show local member in column axis. So that I created local member for TOTAL EXPECTED 2015-16 with member combination of Category (EXPECTED FOR BALANCE MONTHS) and TIME (MAR-16), it displayed as TOTAL EXPECTED 2015-16 along with EXPECTED FOR BALANCE MONTHS category. Here I need to Show only TOTAL EXPECTED 2015-16 in the column axis.

Please suggest solution to achieve this issue

[former_member186338 · Accepted solution]

Hi Mahesh,

This is a standard local member behavior, the category will be inherited from previous column.

You can insert 2 row local members to work as column headers (hiding original headers). Then you can have empty cell using simple Excel formula.

Vadim

[former_member186338 · Accepted solution]

Sample:

Original headers are in rows 5 and 6. Local members 7 and 8

[Former Member · Accepted solution]

Thanks vadim,

I careated Local member as you suggested.now it is working fine

[Former Member]

Hi Mahesh,

is that just text in the top row of the highlighted section? try delete that cell and refresh.

Andy