double counting pivot table

Hi, I created a source table in which each institution has 1 or more projects, each project has an assigned number. However, the same project may spread over several rows. I now would like to create a pivot table to extract and summarize information from that source table. The problem I am facing is that general project informatoin are provided repetitively in the source table. If you have a look at the example attached, the projects 1-4 have several rows but the information provided in rows C, D and E are the same. The pivot table 1 I want to create should count the number of distinct projects per institution and summarize the volume of these projects, without counting projects and volumes several times. Is there a setting in pivot table so that these general project information are counted only once per project?

See the video about the problem with the source of pivot table.

Excel PivotTables Made Easy - And Why Things Go Wrong!