Forum Discussion
Re: Excel 2019 - no row grand total in pivot table since update
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
2 Replies
- 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.
