Formatting custom groups

Question

Hi,

I've created a custom group for my analysis  and added a format for the font to be bold. The Result is, that only the label of the group is bold, but all the values not.

I've tried to manipulate the XML in the advanced tab, but I doesn't work. So I found only the code for the cell of the group, but no place where to define the formatting of the whole row, like for Grand Totals.

Can anyone give me a hint, how to get this working?

Example of actual behavor:

C1C2C3test 110010test 220010CustomerTotal25010

That's what I want

C1C2C3test 110010test 220010CustomerTotal25010

Any tipp is appreciated!

Regards

chris

________________

BI EE 12.2.1.2.0

chris.du · Answer

Hallo Jerry,

I have changed the condition like you mentioned, and as expected all the 'default' values are bold and the custom group value is regular. Then I changed it to "not in list" expecting, that maybe the default values are regular and custom group is bold. But it doesn't work.

I'm also quite sure that I have no null value in C1, because in database it is definded as "not null".

I've never used custom grouping and condtional formatting before and I have found no good documentation, how it is working and how conditional formatting can be done.

Many thanks for your help!

Regards

Chris

Jerry Casey · Answer

It looks like you do have at least one null record in C1, but I'm not sure why that would prevent the conditional format from working.  I just went back and confirmed what I described above, so I know it works in my example.  Can you try it with a filter on C1 IN ('test', 'test1')?

chris.du · Answer

Hi Jerry,

when I put a conditional format on my second column with condition C1 is null, my table is looking like this:

C1C2C3test10010test 125010CustomTotal1001025010

When I remove the conditional format my table is looking like shown in my first post.

I don't understand why formatting affects the behaviour of the group ...

Chris