Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to include totals in charts based on pivottables? | Charts and Charting in Excel | |||
Grand Totals | Excel Discussion (Misc queries) | |||
Pivot Totals: Group totals different from Grand totals | Excel Discussion (Misc queries) | |||
Grand Totals with Nested Sub Totals | Excel Discussion (Misc queries) | |||
grand total subtotals without hiding details | Excel Worksheet Functions |