pivot table issue

emmykav

New Member
Joined
Jun 8, 2016
Messages
25
Hi, I am inserting a pivot table, and some values are coming through as zero, rather than the actual value. I've checked the raw data and all numbers are formatted the same. Please help?
 
Last edited:

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Derek73

New Member
Joined
Oct 25, 2016
Messages
38
First, make sure that the pivot calculation is set to what you want: if it's supposed to be SUM and it's set to MIN, that might explain it. Pivot tables are also unique in that they don't look at live data, they look at cached data (very useful for what-if scenarios). If the data that the pivot table was generated from was zero, and you changed the data, you need to refresh the pivot cache to reflect the new values (Pivot Table Tools > Options > Refresh).

Pivot tables also have a unique feature to inspect the underlying data and return only those values to a new sheet for when you don't know what's going on and want to see why: Just double click one of those "zeroes" and it will return the rows that created that data point.
 

emmykav

New Member
Joined
Jun 8, 2016
Messages
25
First, make sure that the pivot calculation is set to what you want: if it's supposed to be SUM and it's set to MIN, that might explain it. Pivot tables are also unique in that they don't look at live data, they look at cached data (very useful for what-if scenarios). If the data that the pivot table was generated from was zero, and you changed the data, you need to refresh the pivot cache to reflect the new values (Pivot Table Tools > Options > Refresh).

Pivot tables also have a unique feature to inspect the underlying data and return only those values to a new sheet for when you don't know what's going on and want to see why: Just double click one of those "zeroes" and it will return the rows that created that data point.

All settings are correct. There are values in all cells, only some pull through as zero. When I double click, it takes me to the correct row with the correct value...
 

Watch MrExcel Video

Forum statistics

Threads
1,122,809
Messages
5,598,202
Members
414,218
Latest member
speedbit

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