Skip to Main Content

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