Conditional formating based on grand total in obiee

Question

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

Jerry Casey · Answer

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.

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

[Deleted User] · Answer

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.

Gianni Ceresa · Answer

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.