Skip to Content
Menu
This question has been flagged
1 Reply
2879 Views

Right now in the sales pivot table report, I can group sales by partner or commercial entity and it will total everything by the partner/company for reporting.  This works well, but it will only display the client company name like "ABC Co." or "XYZ Inc.".  How can I also show more contact fields of the partner, something like "ABC Co. - 1500 Main St, New York, NY 10001 (212) 555-6000"?

Avatar
Discard
Best Answer

Hello,

Add a computed string field with 'search' (Note: store is to be false for this computed field) for ABC Co. - 1500 Main St, New York, NY 10001 (212) 555-6000". It will be displayed over there.

Avatar
Discard
Author

Ok, so I guess the computed field should be made for sale.report model? How can I add to pivot report once the field is created?