Hello excel experts:

I would like to use the fields in the Report Filter area to filter my Pivot Table. I have Mrkt Segment Group, Mrkt Segment SubGroup and Material fields in this area. I would like the users to be able to choose a particular Mktg Segment Group and then have the Mrkt Segment SubGroup and Material filtered down to only those which are in the Mrkt Segment Group they picked. It seems as though each field in the Report Filter area is independent of the other. Here is an example:
Mrkt Segment Mrkt Segment SubGroup Material
1 a 100
1 b 200
2 c 300
3 d 400

If they choose Mrkt Segment 1 in the first field of the Report Filter, I want the Mrkt Segment SubGroup field to only show the choices of "a" and "b" and the Material to only show the choices of "100" and "200". Then if they further filter by choosing Mrkt Segment Subgroup of "a", then the Material would only have a choice of "100". This is a very normal activity for slicing/dicing and analyzing data.

Does anyone know how to do this?

Thanks.
Andrea