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