Question: How do I fix prior submission section? Create a PivotTable to show the 1 0 states in which the insurance companies are making the best

How do I fix prior submission section?
Create a PivotTable to show the 10 states in which the insurance companies are making the best ROI.
Place the PivotTable on the BestROI worksheet.
Use a calculated field named "BestInsROI"(without the quotes) Hint: ROI is 1 minus the ratio of insurances losses to premiums. The ratio is calculated as Insurance companies losses divided by Car Insurance Premiums. Note that the Car Insurance Premiums ($) field contains the average premium for all customers in each state.
Display the values as a percentage with one decimal place.
Show the 10 states where insurance companies are making the best ROI.
Sort the PivotTable from largest to smallest.
15
Prior submission results:
[-3] The Values fields for the BestROI PivotTable does not contain BestInsROI
[-undefined] Full Credit
[-undefined] Full Credit
[-3.5] The PivotTable is not showing the correct set of states.
[-4.5] The BestROI PivotTable does not contain the correct values
 How do I fix prior submission section? Create a PivotTable to

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!