Search for courses or lessons
Redeem a coupon
Start free trial
Which is the best method to round a calculation in a Pivot Table if a new column can't be added to the source data?
Create a column beside the Pivot Table that contains a rounding formula
Create a calculated field that contains a rounding formula
Create a calculated field that divides the two items, and then format the column to hide decimals
Which is the most efficient method to modify a calculated field in a Pivot Table?
Delete the Calculated Field, and set it up as a new Calculated Field
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
Suppose you've just created two new Calculated Fields for your Pivot Table called Profit and Profit %. What steps are required for them to be added to the Pivot Table as shown here?
You need to refresh the Pivot Table first, then drag it on to the Pivot Table from the field list
You need to drag it on to the Pivot Table from the field list
No steps are required, as the new Calculated Field is added automatically
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement