i am having some problem on calculation subtotals on percentage column in OBIEE 11g
I have a report like below, and i am doing total at product level , but the % column is not working as expected ,
as shown below: Product | Total Amount | Total Margin | Margin%(Total Margin/Total Amount 100)* P1 100 50 50% P2 300 100 33% Total 400 150 33%+(this should be 150/400 - 37.5% , but it is not doing the percentage based on totals and is picking some value from above values, either 33% or 50%)
Can some one please help me with this.
Thanks in advance...
Edited by: user8744765 on Dec 16, 2012 9:38 AM
Edited by: user8744765 on Dec 16, 2012 9:39 AM
Edited by: user8744765 on Dec 16, 2012 9:43 AM
Percentage of column is not the oprtion in your case. it is used in the single column, what is the percentage of single riw item,
do some reasearch on that, you will come to know.
You have done it correctly,
What you need do is to set the Aggreagation rule correctly.
click on the tortal amount click aggregation rule and keep SUM.
click on the tortal margin click aggregation rule and keep SUM.
click on the % margin click aggregation rule and keep default. (inside the column fx also it should be default)
it should work.
mark if works, helps,