Pivot Table

[Moe]

When I am tranfering data from Excel Spread sheet into the pivot table
(several dates are involved) instead of it giving me the amounts in the
rows it is giving me counts.Any suggestion? Is the option box not set
correctly?

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Debra Dalgleish]

You can't change the default settings for the data fields. If a field
contains blank cells, or cells with text, it will default to COUNT.
Otherwise, it will SUM.