Hi all

Firstly, many thanks to all of you for this forum - it and others are a massive help to me many times when I'm stuck on something and I know I and we all your help!

So here's my problem - I currently have my PivotTable set with two report filters ("Division" and "Username"). Everything that the table links into works perfectly but there is one small issue that's nagging me. Is there any method of having my Division name field filtered (let's say accounting, HR, training, finance) to one division, then as a byproduct having report filter 2 (e.g. Joe Smith, David Jones, Tom Thumb) drop off any values that don't appear in said department in the same way as having a standard filter on a group of data does?

Many thanks in advance!