Pivot table in Excel 2007

  • Thread starter Thread starter Dinesh
  • Start date Start date
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
 
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

Similar Threads

sum by rows in Pivot 1
Average of Subtotals in Pivot Table 0
grand totals in pivot table rows 5
Pivot Excel 2007 2
Pivot Table Row Totals 6
How to ignore a column of numbers in Grand Total for rows 1
Pivot Table - copy specified Grand Totals 1
Extract value from Specific Cell 6

Back
Top