I'd like to use a custom summary formula in an opportunity report that references a user in a user lookup field on the opportunity, but not the opportunity owner themselves. Is this possible?

Currently when I create the formula, I'm able to access the opportunity owner fields and pull in the field I want, but I want to access a different user who is inside a user lookup field on the opportunity.

Any guidance is appreciated -- thanks!

  • I think you will need a Custom Report Type (base object = Opportunity) that exposes the User fields for your custom lookup field.
    – cropredy
    Aug 5, 2016 at 22:25
  • @cropredy I tried that and didn't see User as a related object I could bring in for the report type. Am I missing something?
    – Matt
    Aug 6, 2016 at 0:08
  • 1
    Choose Custom Report Type with base object = Opportunity, then Edit Layout - then add fields via Lookup (in right hand side of screen)
    – cropredy
    Aug 6, 2016 at 0:21
  • @cropredy that did it -- not sure how I overlooked that initially. Thanks!
    – Matt
    Aug 6, 2016 at 17:19

1 Answer 1


OOB reports on Opportunity will not make lookup records other than Account and Owner (User) available.

To get lookup fields for a custom lookup to User,

  • create a custom report type on Opportunity
  • click edit layout
  • add via lookup fields ( right hand side of edit layout screen)

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .