How to restrict a characteristic without affecting the entire report?

Hi,

I am relatively new to reports in C4C. I have a requirement.

In an Opportunity Detail report, I need to bring in "Sales Employe" column.

I was able to find the Party Role characteristic in Opportunity Involved Parties which is a code list of many roles including "Sales Employee".

So what I am doing is joining Opportunity header with Opportunity Involved Parties and make a report out of it.And I am restricting the Party role characteristic to Sales Employee using Fixed Value Selection and is showing party characteristic as Sales Employee.

But the problem is that the opportunities for which no sales employee is maintained,is not displayed in the report,as the restriction gets rid of those opportunities.But those opportunities should also be displayed with an empty Sales Employee column So can anyone please suggest any solution or workaround for this.I am running on a tight deadline.Please help.

Thanks in advance 😊,

Vishnu