Forum Discussion
Pivot table option issues in MS office 365
I am using Microsoft Office 365 on my machine and need to use the PivotTable option to summarize the Late Hours and Extension Hours in my report. However, recently the PivotTable is not displaying th...
Hello Ravindar1,
I would first check whether Late Hours and Extension Hours are stored as numbers or as text.
If Excel treats these values as text, the PivotTable may use Count instead of Sum.
Select the source columns and check the cell values. If they are stored as text, convert them to numbers, then refresh the PivotTable.
In the PivotTable, right-click the field under Values and select Summarize Values By, then choose Sum.
If the values are already numeric but Sum still does not work, check the PivotTable source and whether it is using the Data Model.
Microsoft Support has a topic called "Sum values in a PivotTable" that covers this behavior.