Pivot Table Sum Columns and Rows

P

peterh

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

BrianB

You do not mention if you checked up under pivot table Options
Grand Totals for Columns
Grand Totals for Row
 
Top