Skip to main content
I have a custom object which holds sale information.  The problem that I have is there are times when 2 sales reps split one sale.  I need to create a report showing each sales rep getting half the credit.

 

Figuring out a field that does this is not the problem.  The problem I am having is showing the second sales rep getting credit on a report.

 

I have the following fields on the object:

 

Sold by Category: a picklist that determines if this is a split sale

 

Sold by:  the primary person who sold the business (99% of the time, there will only be one person

 

Sold by 2: if the group is being split between 2 people, this field will contain the second person that gets credit

 

(sold by and sold by 2 are lookups to the user object)

 

My problem is regarding the report.  I need to create a report that groups both "sold by" and "sold by 2" into one grouping.  So if a sales rep named Joe Smith has records where he is the "sold by" and other records where he is the "sold by 2", they all appear together and are totalled as one.

 

Does anyone know if this can be done and how? 

 

Thanks!!

 

Fred
답변 2개
  1. 2010년 6월 29일 오후 3:24
    what i meant to say was sub total by Sold by under row heading and sub total Sold by 2 under column headings