PIVOT TABLES -Average Days Per Request

surkdidat

Active Member
Joined
Oct 1, 2011
Messages
361
I am trying to calculate the average amount of days a request takes.
In my raw data I have a formula which takes off the day when received, to the day which is completed.

I also have a field which determines which quarter it falls in, and a field which business area it is in.

I can get it displayed as a SUM, but when I click on average it states "Averages, standard deviations, and variances are not supported when a PivotTable Report has calculated items"

So, my question is, in the PivotTable how can I get it to calculate the average (based on number of days/number of RAISED occurrences?
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,109,521
Messages
5,529,325
Members
409,863
Latest member
stacy09
Top