Conditional formatting in Pivot table OBIEE 11g

1256449

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)
12345	100	10	10
23456	100	10	10
56789	100	10	10

Thanks

DNK

Joel

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

Chris Arnold

(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

Hope this helps...

1256449

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

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

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.

Joel

Snap!

1256449

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

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