$8.$ Go to the Customers by Plan worksheet, which contains a PivotTable showing the payments, customers, and lines for each plan. Marina does not need to display the number of lines, but does want to show subtotals in a different layout since Eastern Mobile is running a special on unlimited plans with three or more lines. Marina wants to know where the current customers of these plans reside so that she can encourage sales representatives to promote the plans in those states.

Modify the PivotTable for Marina as follows:

a$.$ Remove the Sum of # of Lines field from the Values area.

b$.$ Change the report layout to Tabular Form.