Pivot Table Grand Total Average in a Formula

Hello Everyone,

I was wondering if this is possible and if possible how?, attached is a sample spreadsheet with a pivot table in it. Now is it possible to get the grand total.. just like the total in a pivot table thru a formula?

Thank you
Hudas

Hi Hudas,

Which cell in the example workbook do you want your grand totals in?