Need help on Pivot entry

[ryanjuzz]

Dear Friends,

I need help on how can I post the average of a certain column. I been using pivot to provide the count but for a certain function like getting the average of time for a certain row.

E.g.

Table used for pivot date
A B C D
Number Created Resolve Time TAT Resolution

(mins)
1 INC1231 4/11/2011 10:15AM 4/11/2011 1:15PM 180
2 INC3010 4/12/2011 9:15AM 4/12/2011 10:15PM 120

3 INC1902 4/12/2011 11:41AM 4/12/2011 1:41PM 120

4 INC1721 4/13/2011 10:15AM 4/13/2011 10:45PM 30

5 INC3261 4/15/2011 10:15AM 4/15/2011 11:15PM 60


WANTED RESULTS:

I want to get Pivot for average TAT Resolution for April. I don't have problem with the Month coz I just add Month Column example 4/12,4/13 I add column beside and give me number for month. BUt the challenge is how can I generate the ave TAT for every month in pivot. Need Help.

Just let me know if some1 can help me....

 

[GlennUK]

I don't see why you'd need an extra column for month, you can group you Created field by month and year. And you can have a field setting of Average for TAT Resolution ... shouldn't that do what you want?

 

[ryanjuzz]

So Glen for the Resolution Time column, I would just edit the field and put on value field setting instead of count i'll put average?? Is that the process you are referring to me?

 

[GlennUK]

So Glen for the Resolution Time column, I would just edit the field and put on value field setting instead of count i'll put average?? Is that the process you are referring to me?

It is indeed the process that I'm referring you to. But, if you are getting a default setting of Count, that points to there being text entries in your data, which doesn't seem right. I guess you'd better check for that before going any further.