Conditional formatting in Pivot table OBIEE 11g — Oracle Analytics

Oracle Analytics Cloud and Server

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

Conditional formatting in Pivot table OBIEE 11g

Received Response
181
Views
8
Comments
1256449
1256449 Rank 2 - Community Beginner

Hello, I am creating a pivot table using union query and created a calcualted field ratio  for the pivot table ($1/$2).Now I need to apply the conditional formatting on the Only the Ratio Field something like if the ratio is <10 show the metric in red color. Please let me know how this can be achieved.

zip code
metric1
metric2
Ratio(Calculated Item($1/$2)
123451001010
234561001010
567891001010

Thanks

DNK

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Have you tried applying the conditional formatting on the result column?

  • Chris Arnold
    Chris Arnold Rank 5 - Community Champion

    (1) Go into the Column Properties of your Ratio column & go to the Conditional Format tab.

    (2) Click Add Condition and select your Ratio column.

    (3) Set Operator to is less than

    (4) Set Value to 10

    (5) This will bring you to the Edit Format box. Set your desired formatting here -- such as setting the font to RED

    CondFormatting.JPG

    Hope this helps...

  • 1256449
    1256449 Rank 2 - Community Beginner

    Hello Joel,

    Can you explain conditional formatting on the result column?? I created a calculated Item for Ratio($1/$2) I need to apply the conditional formatting for that field.

    Thanks

    DNK

  • 1256449
    1256449 Rank 2 - Community Beginner

    Hello Chris,

    I hope you did not read my question .I created a pivot table based on Union query and I want apply formatting on Calculated metric

    Thanks

    DNK

  • Chris Arnold
    Chris Arnold Rank 5 - Community Champion

    Maybe I am missing something but as far as I can tell, my advice on how to add conditional formatting to your analysis is still sound -- even when using union queries.

    You would just do as Joel Acha said and put the formatting on the Result Columns. From there, you would follow the steps that I have already provided in my last post.

    Capture1.JPG

    Capture2.JPG

    Capture3.JPG

  • Joel
    Joel Rank 8 - Analytics Strategist

    Snap!

    pastedImage_0.png

  • 1256449
    1256449 Rank 2 - Community Beginner

    Hello Joel

    Thanks for your reply. I tried this way already and I was getting all zeros for the result column and so I tried creating a calculated field in the pivot table. I have the metrics count(distinct customer),count(distinct products) for each union which I wrote in the column formuale.

    I tried to follow this blog

    OBIEE in IL: OBIEE - Calculation between results of a union

    Thanks

    DNK

  • 1256449
    1256449 Rank 2 - Community Beginner

    Thank you Chris

    Thanks for your reply. Seems like yours and joels approach are same I tried this way already and I was getting all zeros for the result column and so I tried creating a calculated field in the pivot table. I have the metrics count(distinct customer),count(distinct products) for each union which I wrote in the column formuale. Not sure why the result column shows all zeros.

    Thanks

    DNK