Back to lesson
1. Which is the best method to round a calculation in a PivotTable if a new column can't be added to the source data?
Create a calculated field that contains a rounding formula.
Create a column beside the PivotTable that contains a rounding formula.
Create a calculated field that divides the two items, and then format the column to hide decimals.
2. Which is the most efficient method to modify a calculated field in a PivotTable?
Create a new Calculated Field that refers to the original one but that modifies it to be correct.
Go to into the Calculated Field list, select the field from the list, and click Modify.
Delete the Calculated Field, and set it up as a new Calculated Field.
3. Suppose you've just created a new Calculated Field for your PivotTable. What steps are required for it to be added to the PivotTable?
You need to drag it on to the PivotTable from the field list.
No steps are required, as the new Calculated Field is added automatically.
You need to refresh the PivotTable first, then drag it on to the PivotTable from the field list.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement