Register
Log In
Unanswered
Home
October 25, 2013
Offline
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
Dashboards
Power BI
Power Query
April 21, 2015
Offline
No attached spreadsheet??? (you seem to have to press an extra upload button)
October 25, 2013
Offline
Sorry, I thought I added.
Dashboards
June 25, 2016
Offline
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
Most Users Ever Online: 57
Currently Online:
1 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Susan Booze
Rita Hrez
David Innes
preeti bhulabhai
Charles Klasek
Patrick Isedu
Emma Hayward
Vamseedhar G
NA NA
Max Neumann
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
