on 06-27-2007 6:11 AM
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.
Hi,
Sent a document on it.
With rgds,
Anil Kumar Sharma .P
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Zaks,
check
hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.