What is the best way to round a calculation in a PivotTable if you cannot add a new column to your source data?

Answer 1

Create a calculated field that contains a rounding formula

Answer 2

Create a column beside the PivotTable that contains a rounding formula

Answer 3

Create a calculated field that divides the two items, then format the column to hide decimals

Answer 4

Don’t know

Answer 5

Delete the Calculated Field, and set it up as a new Calculated Field

Answer 6

Create a new Calculated Field that refers to the original one, but modifies it to be correct

Answer 7

Go to into the Calculated Field list, select the field from the list, and click Modify

Answer 8

Don’t know

Answer 9

You need to drag it on to the PivotTable from the field list

Answer 10

None, it is added automatically

Answer 11

You need to refresh the PivotTable first, then drag it on to the PivotTable from the field list

Answer 12

Don’t know

What is the most efficient way to modify a calculated field on a PivotTable?