Is there a way to add calculated row in the pivot table (OTBI Analysis)
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):
Answers
-
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.
0 -
Thanks a lot Sahithi for your attention and response on this post...It was really helpful...
0 -
Thanks for sharing. Appreciate your help.
0 -
Sahithi - Thanks for the share.
Till date, I have been achieving such requirements using the selection step feature of OTBI.
0
