Forum Discussion
Pivot Table needs Grand Total of non-calculated field
Excel on a Mac. I have a spreadsheet of customers with multiple payments (checks) and each payment (check) is paying multiple invoices. I only have the total amount of each check, but a list of ...
Subtotals and Grand Total uses calculated filed formula as well, i.e. MAX() in your case. Since Excel on a Mac doesn't support data model, the workaround could be to calculate Grand Total outside the PivotTable, see for example
excel - Correct Grand Total in Pivot Using Calculated Field - Stack Overflow
How to Add and Use an Excel Pivot Table Calculated Field (trumpexcel.com)