Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-23-2014, 05:51 AM
Andrey Andrey is offline Average over all pivot rows in excel Windows 7 64bit Average over all pivot rows in excel Office 2010 64bit
Novice
Average over all pivot rows in excel
 
Join Date: Jul 2014
Posts: 2
Andrey is on a distinguished road
Default 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:
                bananasavg |
  
month |  day|        |     |
    
May |  05 |      |  10 |  
    
May |  06 |      |  10 |


    
May |  07 |      |  10 |
    
May |  08 |      |  10 |
    
May |  09 |      |  10 
Sure I can get it by collapsing all months and days - but that's not a solution for me as I need to include into pivot some more values with formula based on this average and individual value.
Reply With Quote
  #2  
Old 07-23-2014, 06:27 AM
gebobs gebobs is offline Average over all pivot rows in excel Windows 7 64bit Average over all pivot rows in excel Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Average per day? Average per month? Both? Can you just do a calculation separate from the pivot table?
Reply With Quote
  #3  
Old 07-23-2014, 07:51 AM
Andrey Andrey is offline Average over all pivot rows in excel Windows 7 64bit Average over all pivot rows in excel Office 2010 64bit
Novice
Average over all pivot rows in excel
 
Join Date: Jul 2014
Posts: 2
Andrey is on a distinguished road
Default

Per all period of time currently displayed in pivot table.
No, I want to include it into pivot table.
Reply With Quote
Reply

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
Average over all pivot rows in excel Is this sort of pivot possible in the Excel? Jamal NUMAN Excel 4 02-14-2012 02:48 PM
Average over all pivot rows in excel Excel 2010 Pivot Table Qs SchneeBaer Excel 2 10-03-2011 08:45 PM
Average over all pivot rows in excel Excel 2010 formula rounds - arithmetic average calculation YooNaa Kim Excel 1 06-07-2011 08:50 PM
Average over all pivot rows in excel Average of many rows speedycorn1 Excel 1 10-30-2010 07:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:13 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft