Conditional Format: put blank if its not member

[former_member229754]

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,

[TammyPowlas]

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?

[former_member265529]

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

[former_member229754]

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,