A
Ariel
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!
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!