Forum Discussion
Excel 2019 - no row grand total in pivot table since update
I had a forced update to v. 16.013901.20366 64bit today. Now no row grand total shows in a pivot table, no matter what I do. Doesn't matter whether it's via Power Pivot / plain old Insert>PivotTable,...
To sum by rows you need to have sum fields in Columns (check right pane for PivotTable), otherwise it's nothing to sum.
Alternatively you may create measure or calculated field to sum all other fields (which are in Rows part now) and add it as separate column to PivotTable.
SergeiBaklanI'm afraid I don't understand what you're saying. My columns are already sum fields.
