Not a pivot table filter. The column I am referring to contains a status of an estimate which are won, open or lost in the main database. On the report it is obviously whatever has been selected and the ideal situation is when the new file is created and sent to the sales person the will have the same three selections to pick from a drop down menu vs having to type it in. I'm thinking it cant be done since it is a pivot table report but I am new to pivot tables.