G
gao
I need to be able to get data from multiple pivot tables, and summariz
on another sheet for my employees. The issue I'm having is that
cannot seem to "nest" into the getpivotdata formula. Example: Th
format for the formula would be something like =GETPIVOTDATA(PT1,"Joh
hrs total"). What I need to do is have a list of all my employee
names so instead of having to input "John", I could tell it to go t
cell +C3 ---Looking like this now =GETPIVOTDATA(PT1,"(+C3) hr
total"). The reason is the names of the employees do change, and th
list is extensive, and I don't want to have to write their individua
names in to the formula, or have to remember to change them when the
leave. I've looked at using vlookup, but the problem is I hav
multiple rows in the pivot table per user - for example - for John
there are 3 lines of data - troubles, hours and a calculated field o
hours per trouble. HEL
on another sheet for my employees. The issue I'm having is that
cannot seem to "nest" into the getpivotdata formula. Example: Th
format for the formula would be something like =GETPIVOTDATA(PT1,"Joh
hrs total"). What I need to do is have a list of all my employee
names so instead of having to input "John", I could tell it to go t
cell +C3 ---Looking like this now =GETPIVOTDATA(PT1,"(+C3) hr
total"). The reason is the names of the employees do change, and th
list is extensive, and I don't want to have to write their individua
names in to the formula, or have to remember to change them when the
leave. I've looked at using vlookup, but the problem is I hav
multiple rows in the pivot table per user - for example - for John
there are 3 lines of data - troubles, hours and a calculated field o
hours per trouble. HEL