View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fill-in Form General Questions Fill-in Form General Questions is offline
external usenet poster
 
Posts: 5
Default Pivot Table Question - HELP!

I need a table that shows me the project#, project name and the total spent
by each team (t1,t2,..). I add the project# and proj name and team to the row
field.
Then I added the time to data area, but when I add time2, it only gives me
the count it does not add up time1 and time2. Help!!!


project # proj name Team memb time memb time
1 AAA t1 john 1
1 AAA t2 mary 3 kate 2
2 BBB t1 chris 2
2 BBB t2 kate 5
2 BBB t3 lisa 1
3 CCC t1 john 3 bob 4
4 DDD t1 bob 5
4 DDD t2 mary 2
4 DDD t3 dana 3 lisa 3
4 DDD t4 mike 2