Hi$.$ I am having trouble adding the formula to part B in the calculated field.

$4\mathrm{.}3$ Create a PivotTable to show

the $10$ states in which the insurance

companies are making the best ROI.

a$.$ Place the PivotTable on the

BestROI worksheet.

b$.$ 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.

c$.$ Display the values as a

percentage with one decimal

place.

d$.$ Show the $10$ states where

insurance companies are making

the best ROI.

e$.$ Sort the PivotTable from largest to

smallest.