View Single Post
 
Old 05-07-2014, 08:13 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

I know there are grouping functions that others more versed in pivots can tell you about. Not sure if they will address this issue. Otherwise, you could create another column next to 2014 to calculate the projected annual amounts.

So if the pivot is in a1:e5, then the equation in e2 (projected annual for food) would be:
=12*d2/(month(now)).
Reply With Quote