I have a pivot table that only has column header and data fields - no row
area. I would like it to show totals for each column, but nothing happens
when I check Grand Totals for Columns in the table options menu?