Excel Pivot showing "sum of" instead of actual "value"

Caveman1964

Board Regular
Joined
Dec 14, 2017
Messages
108
Hi...I have played with this and researched and cannot find how to fix this.
I have many columns of data but the one column I need, it is giving me the sum of the column instead of the actual values I need to be charted.
I got rid of all blanks, I have zeros in where there would be blanks, I even moved the column.
When I go to field settings, there is no option to just simply select value.
UGH!. Not great with pivots here but spent too much time with this problem.
How do I force pivot to read the actual "value" of the cell, not "sum of"?

Thanks!
 
Last edited:

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,536
Office Version
  1. 365
Platform
  1. Windows
Pivot tables are there to do maths. If you place a field in the values area it will do maths on it. Try it in the rows area.
 

Caveman1964

Board Regular
Joined
Dec 14, 2017
Messages
108
Pivot tables are there to do maths. If you place a field in the values area it will do maths on it. Try it in the rows area.
Thank You.....I placed it in the rows field but did not chart. I will keep working with it. The values area advice helped me also....thanks.
 

Caveman1964

Board Regular
Joined
Dec 14, 2017
Messages
108
Thank You.....I placed it in the rows field but did not chart. I will keep working with it. The values area advice helped me also....thanks.
Ok...I got it.
I had to insert a column, just named it data point, started with 1 and ended with 1404. slid the data point over into the axis, and the value I wanted to chart into the values.
So it summed the one data point which is actually the value of that one data point.
Understanding what the values field did, the math, made the difference! Thanks so much for the help!
 

Forum statistics

Threads
1,136,868
Messages
5,678,226
Members
419,754
Latest member
Sallylwy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top