Excel Pivot Table
 

I'd like to create a Pivot Table where I can filter in the Page Date section
data by category / sub category.

My problem is that each category (Let's say A & B) has different
sub-categories (A has 1, 2 and 3; B has 4, 5 and 6). I'd like the filter to
be smart enough to know that if I select Category A, show only Sub-cats 1, 2
or 3).

Can it be done via Pivot? If not, how?

Thanks!

--
Ariel