Hi Paul
If you are using Pivot Tables and you use the Filter Column as your Page field then when you select a different criteria the Pivot Table will recalculate.
Hope this helps.
Tony(OTPM)