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)).

Thanks Gebob. Yeah you're right with the Formula just that I am unable to group that into my pivot to Prepare a Chart for that. I end up using that formula and copying all other details into separate sheet manually before I can table it all for Analysis and charting.

Is there a way to put that formula in Pivot table (Can Pivot do the calculation internally so it can have separate Project Yr Field in the Pivot Field list?)
This way its grouped together in the Pivot table and easier to work with.

Any help and all help will be appreciated.

Thanks Much!!!


By the way Gebob - I notice you said I should put the formula in e2 even though the Pivot is in A1 to E5. Is this even possible? Thanks