We have downloaded government contract data into Excel and uploaded to Qlik Sense. It shows contract information. Each row shows information to an update to an existing contract. For example, 5 consecutive rows can show 6 annual updates for 1 contract (see highlighted rows in attached)
Our goal is to count the “Contract Office Name” only once per specific contract “Contract ID”. We want to have a pie graph representing the percentage of each Contracting Office Name but can't figure out how to use the functions to not double count with respect to the contract updates.