Start with a blank template:
Choose Google Sheets:
Add pivot table:
Modify the dimensions:
Add a Control
Make the Control set for "Full Name"
Add `full_name` field:
Bottom right-hand corner, find "Add a field":
Then "New Calculated Field" with this formula:
Final Result