Pivot tables wont sum or average fields

H

Hawko

Hi there

I have this problem with my pivot tables. When I select a few cells the
average and sum feature works fine, however if I expand the selctio to
include too many columns the sum is always '0' and the average "DIV/O". All
relevent feilds are numbers, and at any rate these feature work fine until I
extend the selection??
 
D

Debra Dalgleish

Where are you trying to create the sums and averages? With subtotals in
the pivot table? Or are you using formulas outside the pivot table?
 

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 chart 3
working with pivot tables from another worksheet 2
Average in Pivot Tables 5
Average ERROR 7
Pivot Table - problem with repeated fields 5
pivot table help 2
How to set default calculation method in pivot tables? 2
Average of % in pivot table 1

Top