Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
On Jun 21, 3:26 pm, boilermakers
wrote: Just created a simple 2 field pivot table which works fine other than subtotals. Each categroy that previously sorted by is nicely grouped, and "subtotal" is checked in the settings, however each subtotal cell is blank. I've looked at table options, no help. Any ideas? Not much to go on so here is a guess. Do you have 1 row field and 1 column field? Need to turn on grand totals on the table options for that. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Subtotals | Excel Discussion (Misc queries) | |||
Pivot table subtotals | Excel Discussion (Misc queries) | |||
Subtotals in a Pivot Table | Excel Discussion (Misc queries) | |||
subtotals in a pivot table | Excel Worksheet Functions | |||
Pivot Table subtotals | Excel Worksheet Functions |