ExcelBanter - Set calculation type for all value fields in a pivot table at once

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Set calculation type for all value fields in a pivot table at once (https://www.excelbanter.com/excel-discussion-misc-queries/180722-set-calculation-type-all-value-fields-pivot-table-once.html)

malcomio

Set calculation type for all value fields in a pivot table at once

I know that a pivot table value field calculation defaults to sum or count
depending on the contents and whether there are any blank cells.

What I want to do is set all the values to calculate by sum - is there a
shorter way of doing it than right-clicking every value field in turn?

All times are GMT +1. The time now is 05:14 AM.