Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Excel workbook that contains a table named Table1. A sample of the data in Table1 is shown in the following table.
You need to create a PivotTable in PowerPivot as shown in the exhibit. (Click the Exhibit button.)
Solution: You add a PivotTable. You drag ProductCategory, ProductSubCategory, and ProductName to the Rows field. You drag Price to the Values field Does this meet the goal?
A. Yes
B. No
Hello,
the answer correct is B (No) because exist a hierarchy feature.
The concept is correct (is correct that there is a junction between ProductCategory, ProductSubCategory and ProductName), but the “hierarchy” is not created by drag directly, into the Pivot, those fields; meanwhile is more correct create a hierarchy with those fields and then add directly the hierarchy created at the Pivot table.
The Correct Answer is A (YES)