Understanding GetPivotTable Formula

[AthmanArumugam]

I read Chandoo blog today and I am trying to understand Excel GetPivotTable formula.
I am trying to get the Sum of Billable hours for a particular Employee.
The formula which I have used for the pivot table =GETPIVOTDATA("Sum of Billable Hours",M11,"Min of EmplID",31068). Find attached the file. It is not working. Kindly help here.

 

[Deepak]

This would be!

=GETPIVOTDATA("Billable Hours",$M$10,"Employee Name",M12)


GETPIVOTDATA(value field name, any cell reference in pivot table, [field name 1, value1, field name 2, value 2 …])

http://chandoo.org/wp/2015/08/26/getpivotdata-in-dashboards/

 

[AthmanArumugam]

Thanks Got it..