Skip to Main Content
Forums

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!

Counts.

443297Sep 3 2009 — edited Sep 4 2009
Fairly novice user here

How do I get a report in Discoverer that just gives me counts.

For example, the calculation countdistinct(invioce numbers) returns this

Vendor ID Vendor Name Count
222000 ABC Company 1
ABC Company 1
ABC Company 1
ABC Company 1
ABC Company 1

How do I get it to just give me

222000 ABC Company 5

I can't just do an all row count as each invoice number has multiple lines, and therefore could be listed multiple times.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 2 2009
Added on Sep 3 2009
#business-intelligence-applications, #business-intelligence-foundation, #discoverer
2 comments
582 views