Skip to Content
author's profile photo Former Member
Former Member

Formatting for Row and Column Local Member intersection

Hi BPC Friends,

I am trying to implement formatting for one our reports in v 10.0 as below ,tried several ways but not successful .

The issue is formatting H48 and I48 different to row F and G 48 . Our expected result is to hide H48 with white format and I48 as a text without percent . Columns H and I are local members and row 48 is a local member.

Right now I have given formatting on local members selecting them individually in dimension member/property formatting

May I get some suggestions for achieving this

Thanks,

Krishna

fomatting.png (23.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Nov 07, 2016 at 04:41 PM

    Sorry, but not clear!

    You can use formula in the local member for row 48 to check the column and for H column use "" and for I column - some required text...

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Vadim Kalinin

      Hi Vadim,

      I have taken a better explained screenshot now, the requirement is cell I20 should show subtracted value of Scenario(G)and Budget (H) and all other cells in this row 20 should show a divided values as in the formula. This appears to be local member limitation, I am trying several ways but the light still didnt stirke

      lm3.jpg

      lm3.jpg (160.8 kB)
  • author's profile photo Former Member
    Former Member
    Posted on Nov 08, 2016 at 06:28 AM

    Hi Krishna,

    Have you tried it this way?

    formatting-sheet-lm.png

    lm-output.png

    Regards,

    JP


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi JP,

      Thanks for the your suggestion and appreciate the effort you have taken to answer this.

      Both your and Vadim's suggestions are helpful , I have to tweak the solutions to accomplish this.

      I will get back on how I did this soon .

      Thanks,

      Krishna

  • Posted on Nov 25, 2016 at 04:40 PM

    Looks like you don't understand what I am writing!

    Your local member formula has to be something like:

    Column I is column number 9.

    =IF(COLUMN()=9,Subtract,Divide)

    Is it clear?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.