Report using a Database view parent table count

Hi,

I have a report that pulls approvers for each Change Request using a database view, which creates a one-to-many relationship.  However, the total count includes the duplicate Change Request numbers due to multiple approvals. Is there a way to base the total count on the parent table instead?