Pivot Table subtotals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
Click to expand...

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.
 
Back
Top