To add a calculated field to a PIvotTable,select a cell in the pivot table,then under the PivotTable Tools tab,click the Analyze tab.In the Calculations group,click Fields,Items,& Sets,and then click Calculated Field.Enter a name for the calculated field,type a formula in the Formula box,then click Add to save the calculated field,and click Close.
Correct Answer:
Verified
Q26: Rainn wants to switch rows to column
Q26: To add fields to a PivotTable,one can
Q27: Which of the following will you select
Q30: To use more than one filters per
Q31: What will you select as X in
Q32: Which option will you click after selecting
Q34: Which of the following keys will you
Q37: Which of the following will you do
Q44: To insert a Scatter chart for a
Q50: How many items in a Pivot table
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents