Grand Totals in Pivottables with details
 

I created a pivottable with five columns (1 to 5) that are each split i
current week or peak week (total of 10 columns). My problem is that
would like to add a grand total column that are also split in curren
week and peak week.

But it keeps on adding all the 10 columns together in one Grand Tota
column.

Does anybody know how to fix this?

Pete

--
Message posted from http://www.ExcelForum.com

Grand Totals in Pivottables with details
 

Put formulas in columns to the right of the pivot tables.

--
Regards,
Tom Ogilvy


"Pedo00ab " wrote in message
...
I created a pivottable with five columns (1 to 5) that are each split in
current week or peak week (total of 10 columns). My problem is that I
would like to add a grand total column that are also split in current
week and peak week.

But it keeps on adding all the 10 columns together in one Grand Total
column.

Does anybody know how to fix this?

Peter


---
Message posted from http://www.ExcelForum.com/