Forum Discussion
jshirk
Apr 26, 2021Copper Contributor
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,...
jshirk
Apr 27, 2021Copper Contributor
If this is the case, then the only way is to add a value field that sums the column sums.
SergeiBaklan
Apr 27, 2021Diamond Contributor
Yes, you need calculated field or measure which sums other value. When you work with it as with any other field which you sum.