Conditional formating based on grand total in obiee — 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

Conditional formating based on grand total in obiee

Received Response
122
Views
5
Comments
s234
s234 Rank 3 - Community Apprentice
edited Aug 13, 2024 5:45PM in Oracle Analytics Cloud and Server

hi all,

I have created a report with pivot view and applied grand total (after total option).

Can we apply Conditional format based on that total.

for example total values is 3 I want to display amber and more than 3 red. Total value coming automatically when we select after total option in pivot view. I have created new measure but not working.

Pls suggest possible ways

Thanks

Sudha

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    What version of OBIEE are you talking about?

    Assuming you talk about an OBIEE analysis and not a BI Publisher report, right?

  • s234
    s234 Rank 3 - Community Apprentice

    Yes it's OBI 12c

  • Gianni Ceresa
    Gianni Ceresa Mod

    Conditional formatting do not apply to grand total, so if you wanted to format the total itself it will not work.

    If you want to apply conditional formatting on the detail (not total values) based on the value of the total you can do it by calculating in a hidden column a "flag" value (1/0, true/false) using formulas to calculate the total.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    s234 wrote:Yes it's OBI 12c

    For your future posts in here: Which one of the currently nineteen (19!) existing "OBI 12c" versions? If you post precise questions you can more easily get precise answers.

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    One way to do this is to create a "Totals" line in a union query.  The second leg of the union is identical to the first, except the records in the first are collapsed into a single record,
    by replacing "Project Number" in this example, with the word "Totals:"  Conditional formatting can be applied to "Cost" that is triggered by the "Totals:" label.
    pastedImage_0.pngpastedImage_1.pngpastedImage_3.png

    I used an added Result Column at the header level to create the condition flag used above.
    pastedImage_4.png