| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I use a pivot table to get an average count?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I use a pivot table to get an average count?
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
| Count unique values - Pivot Table | Charts and Charting in Excel | |||
| Pivot Table -- Add column to average Grand Total | Excel Worksheet Functions | |||
| Pivot table formatting | Excel Discussion (Misc queries) | |||
| How do I get a pivot table to sum instead of giving me a count? | Excel Worksheet Functions | |||
Linear Mode
