You could add another field from the source data, to distinguish between
projects. Perhaps you have a project code, or project name that you
could use.

naulerich wrote:
My pivot table is set up:

Project ID=ALL
Sum of actaul cost

WBS Task Name Actual Work Hrs Total
1000 Initiation 172 hrs $xxx
237 hrs $xxx
279 hrs $xxx

2000 Planning 173.57 hrs $xxx
188.85 hrs $xxx
344.92 hrs $xxx

3000 Execution 47 hrs $xxx
76 hrs $xxx

Notice that Execution only shows totals for 2 of the three projects, this is
because the third value is a duplicate (47). Is there a way to view this
entry?





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html