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 colum headers of Month, Date, Weekday,
Time and the transaction data. I would like to see the average number of transaction 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?
Hi, Jeff.
I am interested in a solution to a similar problem. My PT: RowFields: = "Customer" ColumnFields: = "Date" (grouped by Month and Year) PivotFields: = "Quantity" I would like to have a column in place of the "Grand Totals" column which will display "Monthly Average of Quantity" for each "Customer" over the entire range of "Date." Something like "= quantity / ((max(date) - min(date)) * 30)" I have perused Debra Dalgliesh's site and found many good ideas, but nothing that helps with this problem. Maybe someone can help us both. Regards /s/ te "Jeff Azano" wrote: I have a list of transactions with colum headers of Month, Date, Weekday, Time and the transaction data. I would like to see the average number of transaction 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) | |||
How do I use a pivot table to get an average count? | 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 | |||
How do I get a pivot table to sum instead of giving me a count? | Excel Worksheet Functions |