Search for courses or lessons
Redeem a coupon
Start free trial
What is the best way to round a calculation in a PivotTable if you cannot add a new column to your source data?
Create a calculated field that contains a rounding formula
Create column beside the pivot table that contains a rounding formula
Create a calculated field that divides the two items, then format the column to hide decimals
What is the most efficient way to modify a calculated field on a PivotTable?
Go to into the Calculated Field list, select the field from the list, and click Modify
Create a new Calculated Field that refers to the original one, but modifies it to be correct.
Delete the Calculated Field, and set it up as a new Calculated Field.
Assume that you have just created a new Calculated Field for your PivotTable. What steps need to be taken to actually add it to the PivotTable?
None, it is added automatically
You need to drag it on to the PivotTable from the field list
You need to refresh the PivotTable first, then drag it on to the PivotTable from the field list
Back to the top
© 2020 GoSkills Ltd.
Skills for career advancement