In Excel 2007, I am trying to set up four separate pivot tables. All are based on data range "AllData!Table1". This is a table of projects and the reports submitted on those projects. The reports needed to meet four separate date milestones, and I'm trying to create a separate pivot table against each milestone to show how many were late.
All pivot tables have the same basic format:
- Row labels are: ProjNum and FDate
- Report Filter is: Status ("done")
- Values is: Count of FDate
- Column Label is different: Late MS1, MS2, MS3, or MS4
Each pivot table displays with the ProjNum as a group heading, with totals across that row, and dates below with totals on each row.
I would like to filter the dates for each pivot table on one sheet as "before 1/1/2013" and then group by year.
Obviously, I'm losing!
When I set the Date filter, all my dates change to display "<1/1/2013".
Plus, making a change in one pivot table affects all four!
EDIT: Not only that, but changes affect for other pivot tables on the next sheet!!
Can someone please explain what I'm doing wrong and how to do it right?