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,...
Excel creates a grand total for a every field in the values area. You got 6 fields and 6 grand totals (Sum of ...). So everything is working fine.
To get a sum of the 6 grand totals you could unpivot your source data or add a helper column in the source data adding the 6 columns.
Detlef_Lewin this article, and pretty much every article (and video) shows how row totals are added automatic.
https://support.microsoft.com/en-us/office/show-or-hide-subtotals-and-totals-in-a-pivottable-fc4d8406-f230-4762-aa2f-310826f3e5e2
row grand totals only appear if there are row groupings. In this updated version, I added a row grouping, and still their is neither a row total or row grand total.