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!

Diff calculation between 2 subtotal columns in pivot table

2717688Aug 19 2014 — edited Sep 10 2014

Hi

I'm trying to calculate the difference between 2 subtotal columns in my pivot table in OBIEE.For example (closing amount of FEB-14 - closing amount of JAN-14). I tried to do it with adding a new calculated item but i didn't have the possibility to add my calculation.

I also tried to right click on one of the subtotals and to create a calculated item from the specific column but again it didn't bring me the required result.

If someone can assist,i'll be grateful

thanks a lot


Yaron

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 23 2014
Added on Aug 19 2014
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
5 comments
1,807 views