Suppose you try to create a pivot table from multiple tables stored in a Data Model and,when you check a particular field to be placed in the pivot table,you get a warning about a missing relationship.Which of the following does this not imply?
A)You are trying to use fields from unrelatable tables,so no matter what you do,your pivot table results will be wrong.
B)You can open the Power Pivot window,create the missing relationships,and try building the pivot table again.
C)You can click the Auto-Detect button in the PivotTable Fields pane,and the chances are that Excel will correctly create the missing relationship.
D)You can click the CREATE button in the PivotTable Fields pane,which allows you to manually create the missing relationship.

Question

Quizplus · Accepted Answer

A) implies an absolute inability to relate the tables, which is not necessarily true. Missing relationships can often be created or fixed, allowing for correct pivot table results.

Suppose You Try to Create a Pivot Table from Multiple