Hi Everyone,
I am looking for some assistance here!
On the attached spreadsheet, under "Driver Productivity", I have a pivot table on the left. Under columns I to L, I am using averageif formula to get the results I am looking for, but when the pivot table expands, I have to change the range.
Under columns N to Q I wish to use the getpivtodata function to get the same results and plus add in the date within cell B1.
I hope this makes sense!
Thanks
No attached spreadsheet??? (you seem to have to press an extra upload button)
Sorry, I thought I added.
Hi James
Why don't you drop the Hrs/Load field into the Values area and Summarize Values By Average?
It will give you the same answer as your AVERAGEIF formula plus you don't have to worry about the expanding/contracting Pivot Table.
Sunny Kow
Hi Sunny Kow,
Thanks for the reply. This has helped me get the results I needed, plus I have worked out the second part of the getpivotdata formula to include the date.
Thanks again!!
