Pivot Report/Chart Setting

  • Thread starter Thread starter Paul Axelrod
  • Start date Start date
P

Paul Axelrod

When producing a Pivot report or chart in Excel XP, currency fields
are defaulting to Count rather than Sum, which I got in Excel 97.
Does anyone know how to change this default.
Thanks
 
I just tried it with a small test. I got Sum.

Are you sure you don't have any text or empty cells in that column? I could get
Count with either of those in my data.
 

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

Changing Default Function in Pivot Tables 1
When refreshing pivot tables my pivot table chart type changes 1
How to set default calculation method in pivot tables? 2
Pivot Tables/Charts and common filter 1
Getting "Per Item" Pivot Chart Results when data rows are identica 4
Pivot Table Chart 3
Show current Report Filtered in Pivot Chart 5
switch off pivot chart report 1

Back
Top