Microsoft
70-779 · Question #14
70-779 Question #14: Real Exam Question with Answer & Explanation
The correct answer is A. Change the aggregate value function of the pivot.. Just open pivoted column step gear sign then Advanced Options then change Aggregate Value Function to "Don't aggregate".
Question
You have a workbook query that loads the following table: You pivot the table on the Key column by using Value as the values column, and you receive the results shown in the following table. You need to ensure that the data appears as shown in the following table. What should you do?
Exhibit
Options
- AChange the aggregate value function of the pivot.
- BSelect the ID column, and then click Unpivot Columns
- CChange the Data Type of the Value column.
- DDelete the Picoted Column step. Select the Key column, and the click UnpivotColumns.
Explanation
Just open pivoted column step gear sign then Advanced Options then change Aggregate Value Function to "Don't aggregate".
Community Discussion
No community discussion yet for this question.