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

G

Guest

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?
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I use a pivot table to get an average count? 1
How to determine cursor location? 4
Pivot Table Calculation 4
Date Ranges 2
Pivot table subtotals 2
Pivot table average 1
Average of % in pivot table 1
pivot tables - totals different than the summarize function 1

Top