Please do the following steps:
1. Lists > Search > Saved Searches > New > Customer.
2. Results:
Field: Sales Rep
Summary Type: Group
Field: Internal ID
Summary Type: Count
Field: Formula (Numeric)
Summary Type: Sum
Formula: case when {isperson} = 'T' then 1 else 0 end
Custom Label: # of Individuals
Field: Formula (Numeric)
Summary Type: Sum
Formula: case when {isperson} = 'F' then 1 else 0 end
Custom Label: # of Companies
3. Provide name for the search.
4. Save & Run.
No comments:
Post a Comment