Pivot Table Question

  • Thread starter Thread starter Lynn L
  • Start date Start date
L

Lynn L

I have all the data I want in a pivot table in an Excel
Spreadsheet. I've got the columns and rows all set, but
I'm having a problem with the data. Instead of
displaying the data I want to see, it's counting it. Is
there anyway to just display the data? This is the first
time I'm trying to use a pivot table.
 
Right click on the values you are seeing, click on field settings and then
choose SUM on the left as opposed to COUNT. This usually happens when you have
blanks in your data, so if you select all your source data beforehand, do Edit /
Go To / Special / Blanks, then type 0 and hit CTRL+ENTER, this will populate
every blank cell with a 0, and your data should then default to SUM. This
assumes though, that 0s in your blank cells is a viable option.
 
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
Question on the occupied field of the pivot table in excel spreadsheet 0
pivot table space question 1
re-using pivot table layout 1
pivot table data 2
Pivot tables - memory issues - please help 2
Data Lookup Question 1
Access #Error & Excel Pivot 0

Back
Top