Skip to Content
avatar image
Former Member

Conditional Format: put blank if its not member

Hi,

I have one scenario.

Please check the following figure

hide.png

in the left it is what is happening (standard), and right it what I want to achieve.

I want this happens only for KF QTY

logic: if the member is base (lowest level) then it show the quantity, else it show the blank.

how can I achieve this?

(Easily I can achieve in Webi using Conditional format)

Thanks.

Regards,

hide.png (16.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Wouldn't it be easier to not show the lowest level of the hierarchy than to look at conditional formatting? Or you do you have an uneven hierarchy? What is your data source?

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 07, 2017 at 05:43 AM

    Hi,

    I need to show the lowest level of the hierarchy with the value of that Key Figure, I do not want to show in parent.

    Source: BEx Query

    Q: Maybe I'm wrong the CSS only play with the colours of the Objects, or also can play with any kind of rule like:

    if member = Parent then put Colour = white.

    Cheers.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 07, 2017 at 09:37 AM

    Hi Pheno,

    It is not needed to go for CSS for your requirement.

    Hide the totals of the info object in the initial view of the data source by using right click option. It will make the datasource to display values only for lower level of expansion of hierarchy.

    Thanks,

    Poovarasan

    Add comment
    10|10000 characters needed characters exceeded