How To Make Multiple Name Show Up Only Once in Pivot Table?

In the attached file (xlsx) under 'Database' Tab poeple have indicated their preferences (multiple choices) for different food items "specialties". The specialties are grouped under broader buckets called "groups". The specialties are bucketed into groups in a way that people end up more than once in each specialties and groups due to their muliple selections. When we create a pivot by specialties (Pivot Specialties tab), each person appears only once for each specialty...it's great. But, when we create a "group" pivot (each group has multiple specialties), now, people appear more than once for each group. Is there a way, each person can show up only once under each group so the group count does not appear to be misleading?

I'll most sincerely apprecaite your help.

Thanks,
Excellearner90

You could introduce a further column at source utilising the XL2007 function COUNTIFS... using your sample:

Database!E4:
Heads

Database!E5:
=1/COUNTIFS($B$5:$B$19,$B5,$D$5:$D$19,$D5)

copied down to E19

Change PT source to include column E - and instead of using COUNT of Name use SUM of Heads.

Nice idea, DonkeyOte