How can you create a single PivotTable to analyze data from two tables?
A) Create the PivotTable using Power Pivot.
B) Use the same name for each table.
C) Create a measure to link the tables.
D) Group the tables.

Question

Quizplus · Accepted Answer

The best way to create a single PivotTable to analyze data from two tables is to use Power Pivot. Power Pivot enables you to create a data model that can handle multiple tables and create relationships between them. This allows you to create a PivotTable that can analyze data from both tables. Using the same name for each table, creating a measure to link the tables or grouping the tables is not the best choice in this scenario.

How Can You Create a Single PivotTable to Analyze Data