|
|
|
|
Excel 2000 with Win2k
"Debra Dalgleish" wrote:
What version of Excel are you using?
Anik wrote:
I'm sorry I didn't explain it right. In fact, A2 = "J001 : Construct Room
With Materials" because I'm using copy-paste.
Can someone help me please ?
"Debra Dalgleish" wrote:
It looks like your project name in the column area is:
J001 : Construct Room With Materials
which doesn't match the entry in cell A2 (J001 : Construct Room)
Anik wrote:
Here is my Pivot Table, starting in cell DZ3:
Sum of Time Project
Employee J001 : Construct Room With Materials J003 : Buy Materials With
Money
Frances, Mario 172.75 136
Peris, Sylvain 9 21.25
Smith, Fred 22.5
A1 = "Peris, Sylvain"
A2 = "J001 : Construct Room"
=GETPIVOTDATA($DZ$3, A1) -- returns total of Sylvain Peris Hours, which is
809.25.
=GETPIVOTDATA($DZ$3, A2) -- should return total of project J001 but I get
the N/A value.
I read all the posts and tried everything. Subtotals of each fields,
projects and people are automatic, and I can read the Grand Total in the last
column (people total hours) and last line (project total hours)
Hope you have a suggestion !
Anik
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
|