Pivot Table Sum is Showing Zeros

Question

I created a pivot table and it is counting my items so I change the value to sum of count. Whenever I do this, it changes all my numbers to zero instead of inserting the value of those fields.&nbsp;

hansvogelaar · Answer

Nina_D1985&nbsp;
The dates and times in columns A and B of the Time Activities sheet are left-aligned, indicating that they are seen as text values by Excel.
Do the following:

Select B6:B15 on the Time Activities sheet.
On the Data tab of the ribbon, click Text to Columns, then click Finish.
The times should now be right-aligned.
Switch to Sheet5.
Click in the pivot table.
On the PivotTable Analyze tab of the ribbon, click Refresh.
Specify [h]:mm as the number format of the value field.

See the attached version.

Forum Discussion

Pivot Table Sum is Showing Zeros

1 Reply

Resources