Overlapping Local Member failing the formatting of the report

[Former Member]

Dear BPC Friends,

I have local member in Col AI and Row 58 & 69. Col AI has  formula that need to be displayed in percentage. Row 58 & 69 had  sum formula of nine rows above it.  I tried following options, but none of them worked.

Scenario-1: In the formatting sheet, I have made Row as priority and hence Cell AI58 & AI69 do not show data in percentage

Scenario-2: When I make Column as priority the color format  of row 58 & 69 (ie. gray color) do  not show up in  Col AI.

I also added local member in row format and made  row as priority. The result is same as scenario 1. I  then made the column as priority and the result is same as Scenario 2

What  I want is   percentage format and gray color in Cell AI 58 and AI 69

Kindly advice

Rahul

[Former Member · Accepted solution]

Hi Rahul,

What is row 46 with yellow headers? Rolling Total? A dimension?

Regards,

JP

[Former Member · Accepted solution]

Seems to be working in my test case:

Unless you explain your report structure also.....

Regards,

JP

[former_member186338 · Accepted solution]

Column local member required not to be gray in all cells Look on my sample!

[Former Member · Accepted solution]

Oops I missed that....In that case only NumberFormat for Column Local member as per your suggestion!

Result:

Thanks for the correction @Vadim!

Regards,

JP

[Former Member]

Hi Rahul,

Please click on "Add Member/Property" - the same way you were doing before.

In the selection window, please select the account on the row that you want to apply "grey highlighting" and click on "Add to Multiple Selection"

On the third tab (Specific Selection), please provide your local member name in the "Local Member" field and click on "Add to Multiple Selection".

Finally, go to the last tab "Multiple Selection Overview" and then click on ok.

Put in your formatting as you have done before. In this case, you would apply the grey highlighting as well as the percentages you want. You are applying your formatting to that cells that fall in the intersection of these two members.

I hope this helps!

[former_member186338]

And second - look on the "Use" column on the formatting sheet!

Has to be something like:

Result:

[former_member186338]

First - screenshots are not readable! Low resolution!