Hi,

I have a pivot table that I'd like to use cascading page filters with. As an example, if I have a data file with names of fruit and vegetables, I'd like to use a page filed to select either "fruit" or "vegetables". Then, I'd like to have a 2nd page filter to just display the different types of vegies I could select from, if I selectee vegetables in the 1st filter.

I know one can do this with cascading drop down filters for raw Excel records. But, I need to have this functionality within the pivot table. Is there some sort of dynamic data validation I could put on the cell that holds the value of the 2nd filter? I know I could use VBA for this solution, but I'm not looking to go that route for this situation.

I've seen other posts that have mentioned that they would like to see this sort of functionality within the pivot tables, so I do believe that one has to resort to some clever approach to enable this functionality.

Appreciate any help.

Regards,
Scotty81