Show all data in pivot table

G

Guest

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?
 
D

Debra Dalgleish

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.
 
G

Guest

THANK YOU!!

Debra Dalgleish said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table Row heading appearing in duplicate in Excel 2003 1
Pivot Table 2
Sum data for weeks in a month 4
Pivot table - drag field in layout 1
add a column to a pivot table that would show the difference between 2 other Columns 7
Weekly average in pivot 6
Month Data in a Pivot Table? 3
exporting summary data for pivot table! 2

Top