Knowee
Questions
Features
Study Tools

Change the value field settings to show the calculated values as a percentage of the Grand Total.

Question

Change the value field settings to show the calculated values as a percentage of the Grand Total.

🧐 Not the exact question you are looking for?Go ask a question

Solution

Sure, here are the steps to change the value field settings to show the calculated values as a percentage of the Grand Total:

  1. Open your Pivot Table, and click anywhere in the data.

  2. Go to the "Analyze" or "Options" tab in the Ribbon.

  3. Click on the drop-down arrow next to "Fields, Items, & Sets".

  4. Select "Calculated Field".

  5. In the "Insert Calculated Field" dialog box, select the field that you want to change in the "Name" box.

  6. In the "Formula" box, type "= 'Field Name' / Grand Total" (replace 'Field Name' with the name of your field).

  7. Click "Add" to add the calculated field to the pivot table.

  8. Click "OK" to close the dialog box.

  9. Now, go to the "Value Field Settings".

  10. In the "Value Field Settings" dialog box, select "% of Grand Total".

  11. Click "OK".

Now, your pivot table should show the calculated values as a percentage of the Grand Total.

This problem has been solved

Similar Questions

In a common-size income statement, each item on the statement is expressed as a percentage of

Which built-in Excel function is used to find the percentage of a value in relation to a total value?Review LaterPERCENTILEPERCENTRANKPERCENTAGEPERCENTAGEOF

True or False: Horizontal Analysis Results can be listed as percentages and dollar amounts as long as one or the other is consistently used.1 pointFalseTrue

Total revenue equals:Multiple choice question.price times cost.cost times output.output times quantity.price times quantity.

Include a Group Footer that displays the ‘Total of Paid Amount’ for EACH ‘Movie’ in theCurrency format. HINT: you may want to use the Group & Sort Tool.

1/1

Upgrade your grade with Knowee

Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.