Count of customers in each sales org.

Question: Hi ,

I need "no. of customer per each sales organization" in QUERY ..

- eg. in a transaction data target , we can many records of a each customer in a sales organization ..

Eg :

org1 c1 $100
org1 c1 $200
org1 c1 $10
org1 c2 $20
org2 c2 $5
org2 c5 $100


output should be :

org1 2 ( 2 customers c1 , c2 )
org2 1 ( 1 customer c5 )

hope i have explained clearly abt my requirement .

Appreciate ur help .

thanks

Answer:
Implement "Search SAP Portal" and "Search Sapfans Forum" in your requesting rules, and it'll work.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.


Tuly Idiot's fan club active member.
Copyright ?2007 - 2008 www.jt77.com