That's just part-1. You can get to part-2 and part-3 from there.
It's easiest to settle for the technique in part-1 (in my opinion), which is probably why they made that part-1.
basically, my Grand Totals isn't summing correctly (the Goal values by Area (row and column) work correctly, but the Grand Total (Analysis Totals Show Column Grand Totals)...?
Calculated Field is: AVG([Goal ]) //that I want the Grand Total for too.
Do you have a sample workbook that we could see?
Also, do you happen to know what the Grand Total should be?