cancel
Showing results for 
Search instead for 
Did you mean: 

How to get the count of char values?

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Sent a document on it.

With rgds,

Anil Kumar Sharma .P

Former Member
0 Kudos

Hi Anil & Edwin,

Thanks for your quick response. It has helped me in meeting my requirement.

Thanks & Regards,

Zaks.

0 Kudos