Skip to Content
2
Former Member
Jun 27, 2007 at 05:11 AM

How to get the count of char values?

12 Views

Hi All,

I want to get the count i.e total number of customers which belongs or falls under particular category per sales org. I am giving the example:

Sales Org Category Customers

S001 BABY FOOD C001

S001 BABY FOOD C002

S001 STATIONARY C003

S001 STATIONARY C004

S001 BEAUTY CARE C005

S002 BABY FOOD C010

S002 STATIONARY C011

S002 BEAUTY CARE C012

S003 SKIN CARE C014

S003 SKIN CARE C015

S003 SKIN CARE C016

S003 BABY FOOD C016

Now the requirement is we need to count the number of customers per category under each sales org. In the above example we are having 2 customers under baby care, 2 under stationary and 1 and beauty care under sales org S001..

We need to get this result in our query.

Regards,

Zaks.