how to calculate Weighted average in obiee in pivot table
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..