Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables Based on Filtered Data
Hi Folks - I created numerous pivot tables from a dataset. I now need to
create the same number of pivot tables for a filtered subset of the dataset. Is there a way to have a pivot table update based on an applied filter? If not, is there a workaround? Thanks. -- Michael |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables Based on Filtered Data
I'd add another column to the raw data.
Then I'd put something in that column that served as an indicator--a formula that emulates the filter criteria. Then use that as a page field in the pivottable. Michael wrote: Hi Folks - I created numerous pivot tables from a dataset. I now need to create the same number of pivot tables for a filtered subset of the dataset. Is there a way to have a pivot table update based on an applied filter? If not, is there a workaround? Thanks. -- Michael -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables with different groupings based on same data table | Excel Discussion (Misc queries) | |||
Pivot Tables with different groupings based on same data table | New Users to Excel | |||
Multiple pivot tables, based on same source data tab; disable refreshon 1st tab? | Excel Worksheet Functions | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
XL2003 Pivot Tables from Filtered Data... | Excel Discussion (Misc queries) |