Pivot Table Question

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.
 
K

Ken Wright

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.
 
Top