COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: cognos05 on 27 Dec 2018 04:02:56 PM

Title: Conditional formatting based on level value
Post by: cognos05 on 27 Dec 2018 04:02:56 PM
Hi ,

I have this as a query item

Ordinal((level(currentMember([LATAM Sales].[Items].[Items]))))  - Level

And Items in rows which is basically all members from the dimension .

Now I select Item go to conditional style and choose advanced style add the expression

Query.Level =1

Then choose appropriate back ground color .

For me there is no error , but the color is not changing for level 1 items .

Any suggestions on what might be going wrong .

Thanks,