Pivot Table Background — Oracle Analytics

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

Pivot Table Background

Received Response
11
Views
4
Comments
choracy69
choracy69 Rank 6 - Analytics Lead
edited Aug 13, 2024 6:09PM in Oracle Analytics Cloud and Server

Hi,

I have Pivot Table like this:

pastedImage_1.png

Person, Person Numb er, Bridge, Cost Center.

Name columns is Traning Name

Measure: POD (it has two value: GREEN and RED)

pastedImage_2.png

Now I want add background color for ma cells which have GREEN or RED value. Can someone know how I can it in simple way?

Or maybe font color will be between GREEN or RED?

When the cell is empty I don't  want any changes.

But I can't change my pivot table because with value (RED/GREEN) it's workin fine.

Any help?

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Have you tried using conditional formatting on your POD column?https://docs.oracle.com/cd/E23943_01/bi.1111/e10544/format.htm#BIEUG1173

  • Gianni Ceresa
    Gianni Ceresa Mod

    Did you try conditional formatting based on your cell value? It's in the properties of the column.

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    Hi,

    Thanks for response.

    Yes, I tried Conditional Formatting, but it doesn't work. I can use conditional formatting for my column POD but on another column (it must be in ROWS or COLUMNS and it share my records).

    For example, I have the same training name and two value in columns:

    pastedImage_0.png

    And when I use Conditional Formatting:

    pastedImage_1.png

    It's working fine, but I have two columns (green/red) and I want one columns with this values.

    But when I exclude MANDATORY column with green/red values this background colors disappear.

    When i tried HIDE this columns, this two columns stay.

    Any suggestions?

    I want something like this:

    pastedImage_3.png

    Or when I try use conditional formatting from POD column on itself it doesn't work.

  • Joel
    Joel Rank 8 - Analytics Strategist

    What is the column formula for POD? GREEN & RED aren't exactly values of a measure so this may probably be causing the issues in your pivot table.