Show all data in pivot table
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? |
Show all data in pivot table
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 |
Show all data in pivot table
THANK YOU!!
"Debra Dalgleish" wrote: 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 |
All times are GMT +1. The time now is 05:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com