Pivot table

[glen.e.mettler]

Using 2003
Column A holds WBS codes. Column B holds WBS description. Column C
holds manhours for the selected WBS. I want to run a pivot that shows
a sum of the manhours for each WBS. When I run the pivot wizard, I get
the "number" of WBS codes that hold manhours but not a sum of the
manhours. How can I get a sum of manhours per WBS?

Glen

 

[Roger Govier]

Hi Glen

Double click on the Manhours filed, and select Sum instead of Count