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!

Count Distinct in Pivot table totals? OBIEE 11.1.1.5

872653Jun 22 2012 — edited Jun 25 2012

Hi,

I have got a column that counts distinct customers per each month of the year and at the end of the analysis, it should show distinct customer count of the year as TOTAL. How can it be achieved? Is it possible to customize pivot table totals?

Example:
Month Customers
Jan          10
Feb          20 (10 new customers)
Mar           15  (5 new customers)

TOTAL: 25 (distinct values --> 10+10+5)

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 23 2012

Added on Jun 22 2012

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

4 comments

1,203 views