What should you do before you create the report?

You have a Microsoft Excel 2016 workbook that has Power Pivot model. The model contains the following tables:

The model has the following relationships:

You create a new Power 61 file and import the Power Pivot model.

You need to ensure that you can generate a report that displays the count of products sold by each salesperson.

What should you do before you create the report?
A . Create a many-to-one relationship between Product and Salesperson
B . For each relationship, change the Cardinality to One to One (1:1)
C . Create a one-to-one relationship between Product and Salesperson.
D . For each relationship, change the Cross fitter direction to Both

View Answer

Answer: A