Forum Discussion
Pivot Table Sum is Showing Zeros
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.
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.