SOLVED

# Pivot Table Summarize Values by Average Greyed Out

Copper Contributor

# 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

4 Replies

# Re: Pivot Table Summarize Values by Average Greyed Out

The field "Time to fill" contains text elements.

Check with ISTTEXT().

# Re: Pivot Table Summarize Values by Average Greyed Out

@Detlef_Lewin what’s the solution then? I need it to say time to fill to identify what’s being calculated.

best response confirmed by klsanc (Copper Contributor)
Solution

# Re: Pivot Table Summarize Values by Average Greyed Out

The solution is to change the formula in column E into something that always results in a number.

Could be:

``=MAX(0,J2-E2)``

# Re: Pivot Table Summarize Values by Average Greyed Out

That worked! Appreciate the help.
1 best response

Accepted Solutions
best response confirmed by klsanc (Copper Contributor)
Solution

# Re: Pivot Table Summarize Values by Average Greyed Out

The solution is to change the formula in column E into something that always results in a number.

Could be:

``=MAX(0,J2-E2)``