For example, our data contains a Total Cost and Total amount for each order.
Add A Calculated FieldĪdding a calculated field to your pivot table is equivalent to adding a new column to your source data to perform a calculation based on the other data. This will allow you to make changes to your pivot table without the column width automatically adjusting. In the PivotTable Options window under the Layout & Format tab uncheck the Autofit column widths on update box.
