Apr 26 2021 01:14 PM
Apr 26 2021 01:14 PM
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, data is sheet or table, added to data model yes/no.
At first I thought I had some kind of personal option setting overriding this, but no. This could be a consequence of turning off row totals on one project, but that is not what my settings show for this sheet or my user options.
I know the two methods for turning off / on row and column totals. It doesn't matter. Windows has been rebooted day today due to forced update, so it's fresh.
Attached is the most basic form of this attempt. I know I can add a calculated field, but shouldn't have to every time I need a simple pivot table. Smells like a bug.
I wish MS would stop 'improving' Excel.
Apr 26 2021 01:39 PM
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.
Apr 26 2021 02:16 PM
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.
Apr 27 2021 05:09 AM
@Sergei BaklanI'm afraid I don't understand what you're saying. My columns are already sum fields.
Apr 27 2021 05:17 AM
@Detlef Lewin this article, and pretty much every article (and video) shows how row totals are added automatic.
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.
Apr 27 2021 05:35 AM
Apr 27 2021 05:43 AM
Apr 27 2021 09:21 AM
Yes, you need calculated field or measure which sums other value. When you work with it as with any other field which you sum.