Tags: average, column, date, excel, headers, microsoft, msdn, number, pivot, software, table, time, transaction, transactions, weekday

How do I use a pivot table to get an average count?

On Microsoft » Microsoft Excel

889 words with 1 Comments; publish: Thu, 22 May 2008 20:42:00 GMT; (30678.13, « »)

I have a list of transactions with column headers of Month, Date, Weekday,

Time and the transaction data. I would like to see the average number of

transactions per hour per day. Can this be done in a pivot table?

All Comments

Leave a comment...

  • 1 Comments
    • Yeah, Pivot table can show you averages. You might need to add a column in

      your data to group them by hour by day.

      Or you might use the group feature of pivot table. Right click on the field

      which has date/time.

      Group and Show detail -> Group ->.....

      Then in the data field, right click and then ->field settings, show average

      instead of sum or count or anything else.

      "Jeff Azano" wrote:

      > I have a list of transactions with column headers of Month, Date, Weekday,

      > Time and the transaction data. I would like to see the average number of

      > transactions per hour per day. Can this be done in a pivot table?

      #1; Thu, 22 May 2008 20:44:00 GMT