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!

how to calculate Weighted average in obiee in pivot table

user9057272Mar 9 2010 — edited Oct 22 2010
In the table view i have the following report.

gpid mv yield
1 10 20
1 20 30
1 30 40

in pivot table i want to show
gpid mv yield
1 10 20
1 20 30
1 30 40
grandtotal sum(mv) sum(mv*yield)/sum(mv)

how to show this..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 19 2010
Added on Mar 9 2010
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
6 comments
3,312 views