pivot formula

  • Thread starter Thread starter officegirl
  • Start date Start date
O

officegirl

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?
 
Right click on the values and select Field Settings and change the
aggregation from Count to Sum...
 
Back
Top