Enterprise Contracts - Show Supplier Name in one column along with all parties in another column

Lindsay Starkey

Hello,

I'm trying to build a "Contract Expiry" analysis for an end user using the "Enterprise Contracts - Contracts Real Time" SA.

The user wants a column called "Supplier" so they can quickly filter the report by Supplier Name, and then see our company contacts/owners of that contract, as well as contacts from the supplier. However, I can't find a way to achieve this, since the "Role" attribute seems to have My Company and Supplier. If I filter the analysis to only show where Role = Supplier, then I lose my company contacts/owners on that contract. Here's a screenshot mockup of what I'm trying to achieve (thinking I might have to make a custom column/formula to only show the supplier name for the entire contract"

(I did notice that there is a folder/field in the Subject Area called "Supplier Party"."Party Name" but looks like that is not a required field in the front end, so it's unfortunately empty in most of my data set.)

Thanks in advance for any help!