Skip to Main Content

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!

How to count the occurance of the data entry on OBIEE answers

YalaSep 16 2009 — edited Sep 16 2009
Hello guys

I have one report that contains a column call type. In the report that I am creating, there are 200 rows in that column, but there are really just 4 types of call type; "A,B,C,D"

So in my report it looks like this

Call type other dim and fact
A
A
A
B
B
C
D
D
D
D

Now I need to add one more column said call counts, which needs to count the occurance of each call types:

Call type count others
A 3
B 2
C 1
D 4

So how would I be able to achieve this on answers? I used "count" function on "count" column, but it is counting all the rows without distinguishing the call type

Please let me know

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details