| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Average in pivot item
Hi friends,
I need to calculate the average of a column in a pivot for eg. Jan 09 and Feb 09 so on and so forth for the whole year. Now how can i calculate the average of count of Jan 09 and Feb 09 ie. (Jan 09 + Feb 09)/2 . Data in the column just says Jan 09, feb 09 , mar 09 so I have to take their count against other columns and then take its average. I tried calculating item in the pivot but its giving error "Calculated items do not work with customs subtotal". If you can advise the above or its alternative, I'll be greatful. Regards, KD |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Time for Specific Item | Excel Discussion (Misc queries) | |||
| How do I calculate a weighted average in a pivot table? | Excel Discussion (Misc queries) | |||
| I want to us Pivot Table to calculate the % of one Item ("Yes") | Excel Worksheet Functions | |||
| Calculate Based on Drop Down Item Selected | Excel Worksheet Functions | |||
| Using a pivot to calculate an average w/o 0's | Excel Discussion (Misc queries) | |||
Threaded Mode
