Hi,

I am working on summarizing data in a pivot table, but now i want grand
totals. I go to table options and make sure the box is checked, but all that
does is put the words "Grand Total" under the values in the first column. My
data will also be changing a lot, so i can't just put a sum function in.
Does anybody have ideas as to getting the pivot table to actually make Grand
Totals?

Thanks