Right click on the values and select Field Settings and change the
aggregation from Count to Sum...
--
HTH...

Jim Thomlinson


"officegirl" wrote:

in my table i have the data as 1,6,5 ... when i create a pivot i need it to
sum up the numbers , the automatic function is count how do i make it add?