Oracle Analytics and AI

Chaima Rahali

Hello Team,

I am trying to add conditional formatting to a pivot table I have created on Excel BI Publisher :

For this table for example I have added two conditions on the data cell :

But when I published this template I can see that only the first condition is applied and so with excel conditional formatting we can only apply one condition on the same field,

Is there another way to apply multiple conditional formatting on BI Publisher Pivot table on Excel ?

Thanks,

Chaima.

Mallikarjuna Kuppauru-Oracle

Hi @Chaima Rahali

I saw you have logged an SR for the same , we checked with Dev team on this and this is an product behavior/limitation. There is no workaround available .

https://docs.oracle.com/en/middleware/bi/analytics-server/design-publish/introduction-excel-templates.html#GUID-8EECB42F-783C-4599-868B-BC1C3994B660 —> Limitations of Excel Templates

When you use an Excel template, you can't use conditional formatting based on the generated data to change the background color of a cell in the report output.

We are working internally to add the same to product documentation. i hope we have answered your question. can you pls mark it as Answered.

Regards,

Arjun