Skip to Content
0

Conditional Format: put blank if its not member

Feb 06, 2017 at 08:55 AM

80

avatar image
Former 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)
10 |10000 characters needed characters left 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?

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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

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,

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 07, 2017 at 09:37 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded