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 calculated field that divides the two items, and then format the column to hide decimals
Create a calculated field that contains a rounding formula
Create a column beside the Pivot Table that contains a rounding formula
Which is the most efficient method to modify a calculated field in a Pivot Table?
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 that modifies it to be correct
Delete the Calculated Field, and set it up as a new Calculated Field
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
No steps are required, as the new Calculated Field is added automatically
You need to drag it on to the Pivot Table from the field list
Back to the top
© 2020 GoSkills Ltd.
Skills for career advancement