Pivot Tables
 

Is it possible to filter a Pivot table based on the contents of a particular cell?
I am trying to pivot out only data from yesterday and automate it. Without going through the filters each time and choosing a day manually.