How to add a calculated column in OTBI Pivot Table ?

Question

Hi All,

Thank you in advance for your help and support.

I have a query regarding the OTBI pivot table. I was wondering if there is a way to add a calculated column to the table. If you have any knowledge or suggestions on this matter, I would be incredibly grateful for your insights.

Best regards,

Paul

RichardChan · Answer

Are you looking to use a fairly complex expression or just create a percentage for example

Praveen Kumar Akkala-Oracle · Answer

Hi Paul Younes,

Please review the below doc as an example.

Fusion Oracle Transactional Business Intelligence - How To Calculate Percentage In Pivot Tables (Doc ID 2342918.1).

Thanks,

Praveen

Rajasekhar Bandaru-Oracle · Answer

Hi Paul

Please refer to the given tutorial link

https://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1116/ps/ps.htm