Please help. Filtered pivot table changing when source values

Hi,

I have a pivot table that has 2 filters. These work with my original data set but when I use this as a template and refresh to use on a reduced dataset (some of which has absent values for my filter variables), the pivot doesn't show any data. How would I correct this? Thank you very much in advance for your help!!!!

Lacey

In your template check that the source data of your pivot table is selecting your correct set of data.

Pivottable Tools - > Analyze -> Change Data Source