| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show sereral columns of data field in pivot table | New Users to Excel | |||
| How do I restore original Pivot Table data? | Excel Discussion (Misc queries) | |||
| Pivot table format changes if value of source data is null | Excel Discussion (Misc queries) | |||
| Pivot table formats text data with 2 decimals | Excel Discussion (Misc queries) | |||
| Pivot table show pages but omit those without data | Excel Discussion (Misc queries) | |||
Linear Mode
