Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) | |||
create pivot table from excel table | Excel Worksheet Functions | |||
Can links between Excel 2003 Pivot Charts and their pivot table b. | Charts and Charting in Excel |