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