title: Keeping filters in a pivot table in absence of data
body: <p>Imagine I have a quality control in a factory retrieving the state of each product
  StateId
  1 - Good
  2 - Acceptable
  3 - Subproduct
  4 - waste</p>
  
  <p>My table 'StateIdHistory' gives me the state of each ProductId at each time.
  I am creating a pivot table in which I want to filter out the StateId=3 in a specific datarange. so I filter my report selecting "3".</p>
  
  <p>Imagine I want to use this same model to other database in which there isn't any StateId=3. My data model will be destroyed. Can I somehow fix the filter to be equal to 3 in spite of having or not data? VBA? If 3 still does not exist it would retrieve me 0 or blank cells... </p>
  
  <p>Thanks in advance!!</p>