To properly combine data from the Customer, Contract, and Invoice tables, create relationships between tables as follows:

a$.$ In the Power Pivot for Excel window, create a relationship between the Customer and Contract tables using the CustomerID column to relate the tables.

b$.$ Create a relationship between the Contract and Invoice tables using the ContractNum column to relate the tables.

Shelly Cashman Excel $365/2021|$ Module $10$: SAM Project la

$11.$ Ravi wants to show invoices for security plans only and want to make the PivotTable easier to interpret. Modify the PivotTable as follows to meet Ravi's requests:

a$.$ Use Unpaid as the column heading in cell C$4.$

b$.$ Use Paid as the column heading in cell D$4.$

c$.$ Filter the PivotTable to display invoices for the Security plan and Security plan for apartment building contract types.