#1
|
|||
|
|||
Average over all pivot rows in excel
Say I put into pivot a number of bananas eaten by the monkey, sliced by months and days. How to add a column containing average number of bananas eaten by the monkey over all period of time?
PHP Code:
|
#2
|
|||
|
|||
Average per day? Average per month? Both? Can you just do a calculation separate from the pivot table?
|
#3
|
|||
|
|||
Per all period of time currently displayed in pivot table.
No, I want to include it into pivot table. |
Tags |
excel pivot |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Pivot - Do not display rows with zero value | patidallas22 | Excel | 1 | 03-08-2013 01:35 PM |
Is this sort of pivot possible in the Excel? | Jamal NUMAN | Excel | 4 | 02-14-2012 02:48 PM |
Excel 2010 Pivot Table Qs | SchneeBaer | Excel | 2 | 10-03-2011 08:45 PM |
Excel 2010 formula rounds - arithmetic average calculation | YooNaa Kim | Excel | 1 | 06-07-2011 08:50 PM |
Average of many rows | speedycorn1 | Excel | 1 | 10-30-2010 07:54 PM |