Is there a way to add calculated row in the pivot table (OTBI Analysis)

Dharmendra Shukla

Summary:

Is there a way to add calculated row in the pivot table (OTBI Analysis)

Content (required):

I am trying to create an analysis like below using pivot table functionality in OTBI analysis. In this I want to add a row. Values of the columns in these rows are calculated based on other rows of the pivot table.

Is there any way to add a calculated row like this? I tried using Create Group but I cannot write formula there...

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Sahithi Kolasani-Oracle

Hi Dharmendra Shukla

We need to create separate metrics in the analysis tab itself. For example create 3 metrics like Sales, Cogs, Gross Income (which is a calculated column Sales - Cogs), etc. and use formatting of a cell to highlight Gross Income in a different color.

Sample OTBI xml attached. You need to create a new report in OTBI, go to Advanced Tab -> Paste the xml given in the attachment and then click on Apply XML. Please change the formulas as per your requirement.

sample_xml.txt

Dharmendra Shukla

Thanks a lot Sahithi for your attention and response on this post...It was really helpful...

Bhaskar Konar

Thanks for sharing. Appreciate your help.

Sahil Makhiza

Sahithi - Thanks for the share.

Till date, I have been achieving such requirements using the selection step feature of OTBI.