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!

Calculating Average on a Pivot table- Not calculating correct

ThirumalApr 30 2013 — edited Apr 30 2013

Hello All BI Techie's,
I have a requirrement, which is calculating the average out of a column , this column is aggreated by sum in the rpd.

Month Year Associate Headcount Involuntary Termination Count (Associates)
2012 / 07 18878.0 55
2012 / 08 18817.0 53
2012 / 09 18770.0 63
Grand Total 18770.0 17

Now, I want calculate a column which gives the average of Associate Headcount, ( 18878+18817+18770)/3 , how I can achieve that?

I tried, using avg(associate headcount), it not returning correct average, any insight?

Please share your ideas.

Thanks,
Bala

Locked Post

New comments cannot be posted to this locked post.

Locked on May 28 2013

Added on Apr 30 2013

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

3 comments

650 views