Pivot Table Sum Columns and Rows

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

Guest

I am doing a Pivot Table importing data from Access and am trying to get sums
for both columns and rows. I can get one or the other but not both. I tried
adding a calculated field and calculated item and they do not show up, even
though I have entered a formula. If I delete the total columns and rows,
then it lets me add a calculated field or item. Any ideas?
 
You do not mention if you checked up under pivot table Options
Grand Totals for Columns
Grand Totals for Row
 
You must log in or register to reply here.

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

Pivot Table Calculated Field - Sum/count 1
How to Show SUM of field value in other column 4
Pivot Table Calculated field error 1
XL2007 - Pivot Table Limitations 2
Pivot table data layout - columns to rows 1
Average of % in pivot table 1
Pivot Table - 3
Pivot tables - adding dates, descriptions 1

Back
Top