Forum Discussion
Solved
Pivot Table Summarize Values by Average Greyed Out
I am constructing a Recruitment Dashboard. One of the values I'm trying to include is the average for time to fill. Which is the time from the open date of a job to the close date of a job. When transferring this data over to the pivot table, it doesn't provide the option to summarize values by average. It's greyed out. The only option is count, which doesn't do me any good.
I've done about all I can think to do. And nothings helped. I'm hoping someone has the answer out there. I'm also attaching the link to my workbook. Dashboard
The solution is to change the formula in column E into something that always results in a number.
Could be:
=MAX(0,J2-E2)
4 Replies
Detlef_Lewin what’s the solution then? I need it to say time to fill to identify what’s being calculated.
The solution is to change the formula in column E into something that always results in a number.
Could be:
=MAX(0,J2-E2)
