Inserting Calculated field

Hello Everyone.

I have been tasked with providing some data on sales year over year by month. I have the data pulled out into excel and am building a pivot table from this. I can get the numbers per month without any problem but I am having some difficulty in getting a total for the item by year. The way I have set up the pivot table, I have the years in rows and the months in columns and the total values by month. I am wanting to get a total for year as a final column. Am I trying to do something that isn't reasonable?

Thanks!

I assume adding grand totals for rows is not working for you? Can you post a workbook showing what you have currently (as an actual pivot table)?

Thanks Rory! Well, I guess by now it is obvious that I haven't done much work with Pivot Tables. Typically, I turn Grand Totals off because they get in my way.