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...
 
You must log in or register to reply here.

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 table questions 1
Pivot Tables - Count Numbers vs. Count 1
Pivot table filter list - listing irrelevant subcategorys 1
Formula fields in Pivot Tables? 1
Summing Formula fields in Pivot Tables? 3
Formula fields in Pivot table reports? 2
about pivot table 1
Changing Default Function in Pivot Tables 1

Back
Top