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,...
I see what the problem is. In this example, columns are generated by discrete data elements (January, February...)
https://support.microsoft.com/en-us/office/overview-of-pivottables-and-pivotcharts-527c8fa3-02c0-445a-a2db-7794676bce96
https://support.microsoft.com/en-us/office/overview-of-pivottables-and-pivotcharts-527c8fa3-02c0-445a-a2db-7794676bce96
If this is the case, then the only way is to add a value field that sums the column sums.
Yes, you need calculated field or measure which sums other value. When you work with it as with any other field which you sum.
