Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Formatting custom groups

Received Response
1
Views
4
Comments
chris.du
chris.du Rank 2 - Community Beginner
edited Aug 13, 2024 5:19PM in Oracle Analytics Cloud and Server

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:

C1C2C3
test 110010
test 220010
CustomerTotal25010

That's what I want

C1C2C3
test 110010
test 220010
CustomerTotal25010

Any tipp is appreciated!

Regards

chris

________________

BI EE 12.2.1.2.0

Answers

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    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

    pastedImage_0.png

  • chris.du
    chris.du Rank 2 - Community Beginner

    Hi Jerry,

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

    C1C2C3
    test10010
    test 125010
    CustomTotal10010
    25010

    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
    Jerry Casey Rank 6 - Analytics Lead

    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
    chris.du Rank 2 - Community Beginner

    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