Pivot Table subtotals

[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?

 

[par_60056]

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.