pivot table

  • Thread starter Thread starter Daws
  • Start date Start date
D

Daws

For some reason my pivot table counts .5 as one. .5 shows
in the sheet but it is like my pivot table is counting
entries not the actual values...what am i doing wrong?

Thanks
Dean
 
Dea

In the Data section of you pivot table make sure you are returning the sum of your selected column and not the count

Regard
Rowam
 
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 filter list - listing irrelevant subcategorys 1
Pivot Tables - Count Numbers vs. Count 1
Question on the occupied field of the pivot table in excel spreadsheet 0
pivot table 1
Pivot table question 1
Counting number of items excluding duplicates. 1
Pivot table and value range 2
Pivot table questions 1

Back
Top