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!

displaying totals

540494Oct 30 2006 — edited Oct 31 2006

hi all,
i want my output to be foll.format.

Type Valuetotal count
AAA 100 5
BBB 200 10

count,5 is the no.of records under type AAA
count,10 is the no.of records under type BBB
Value100 is the sum of all values under AAA(ie for 5 records)
Value200 is the sum of all values under BBB(ie for 10 records)
how can i get the ouput as above
please help..
thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 28 2006

Added on Oct 30 2006

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

5 comments

326 views