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 Antworten

what i meant to say was sub total by Sold by under row heading and sub total Sold by 2 under column headings