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?
ammu
Highly Voted 5 years, 8 months agoHiJaak
5 years, 8 months agoimran
5 years, 8 months agoAurelkb
Highly Voted 5 years, 8 months agoCDL
Most Recent 4 years, 8 months agoNasheM
4 years, 11 months agoCibrevN
5 years agoSachin08
5 years agoWyman
5 years, 1 month agowudixh
5 years, 2 months agoamar111
5 years, 2 months agoclaudia_learner
5 years, 2 months agolecp1530
5 years, 2 months agosiline
4 years, 5 months agoJrestrepo
5 years, 3 months agoAngee
5 years, 4 months agolozqt
5 years, 3 months agoCABREU
5 years, 4 months agoWouter_Venter
5 years, 5 months agotho
5 years, 7 months ago