I have a pivot table created with 'Origin' and 'Destination' in the Row Labels and 'Week' on the Labels. I then have 'count' within the value. I am trying to gather 'Average count by week'. I cannot just divide by 26 across the board because some of the 'origin'-'destination' pairs don't start until week 7 and I need this to expand each week as the year goes on.
could you post an example?
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
Here is a very quick example. I would like to pivot table to come up with those averages.
Pivot Table Average.xlsx
In Q4 put this formula and pull it down.
=M4/COUNTA(F4:L4)
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks