Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

custom formula for Total in pivot table

Oana SudituAug 12 2015 — edited Aug 17 2015

Hello,

I have a pivot table based on a combined SQL query and need to have a line for a total with a custom formula.

The pivot table looks as shown below:

I need to calculate the row %= Category 4/ Total. The column Total is precalculated in the script.

pastedImage_1.png

Could you please let me know if this is something which can be achieved in a pivot table based on data from a combined SQL query?

Thank you.

Regards,

Oana
This post has been answered by Felipe_Idalgo on Aug 14 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 14 2015
Added on Aug 12 2015
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-standard-edition-one, #obiee
12 comments
6,422 views