Hi SKipper,

You could record a macro that did each of your filters of the data and put a button on the sheet that called these macros individually. The record macro process has problems when the data for the pivot table gets bigger or when there are no records in the filter. Time to learn VBA?