Formatting custom groups

chris.du

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:

C1	C2	C3
test 1	100	10
test 2	200	10
CustomerTotal	250	10

That's what I want

C1	C2	C3
test 1	100	10
test 2	200	10
CustomerTotal	250	10

Any tipp is appreciated!

Regards

chris

________________

BI EE 12.2.1.2.0

Jerry Casey

Hi Chris, I adapted this from an earlier answer of mine:

Custom groups are able to accept conditional formatting.

In the pivot table below, there are two groups.  The first groups the 3 values of "Status" into a group named "Totals".  I have placed a conditional format on the measures that when "Status" is null, use a bold font with a pale gray background.  Similarly, I created a group for the 3 "Program" values, and named it "Bureau Totals". In both cases, the red format for deficits is carried into these faux subtotal and grand total lines.

Jerry

chris.du

Hi Jerry,

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

C1	C2	C3
test	100	10
test 1	250	10
CustomTotal	100	10
	250	10

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

Jerry Casey

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

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