Pivot table in Excel 2007

D

Dinesh

Hi,

Somehow my Pivot table do not sums up by rows.
Boxes are checked for both columns and rows for Grand total under options,
Tools and Filter.

Dinesh
 
D

Debra Dalgleish

You'll only see row totals if you have fields in the Columns area of the
pivot table. The row totals would be a sum of those values.

If you have multiple fields in the Values area, they won't be summed in
the row totals.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top