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!

Division of two columns in pivot table_OBIEE

758754Dec 29 2010 — edited Dec 29 2010

Hi,

Can you please let me know if there is a way to divide 2 fact columns in pivot table in OBIEE?

Consider a pivot table like this

Year No of customers purchase volume No of customers/purchase volume

1983 30 17000

1985 23 8900

1986 42 21000

I need to calculate No of customers/purchase volume

I did this calculation in criteria and the results are fine but when i tried to bring this to pivot i have no luck.I tried all aggregation rules like sum,average,server complex aggregation but no luck.Is there any option to calculate this column in pivot section?

Note: 'Year' is in row section and other columns are measures in pivot.

Thanks,
Kalai

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 26 2011

Added on Dec 29 2010

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

1 comment

865 views