I have attached a sample file that has a database in sheet2 and a pivot table in sheet1. The database has additional information when the purpose of the visit is "Sales Call". I would like the pivot table to only show the detail for "Sales calls". I apologise if this is vague but the attachedment should clarify my problem.
Thanks in advance
Bookmarks