You have a PivotTable with 2 fields in the ROWS area and you want to see only the top level of categories. How do you hide the entire second level without removing it from the ROWS area?
A) Select a field in the row headers and click Collapse Field in the Active Field Group on the Analyze tab.
B) You must move the second level out of the ROWS area.
C) Click Expand Field in the Active Field Group on the Analyze tab.
D) Click the - button to the left of the first category.
A
You might also like to view...
The penalty for violating the National Information Infrastructure Protection Act of 1996 depends on the value of the information obtained and whether the offense is judged to have been committed for one of three reasons. What are those reasons?
What will be an ideal response?
Over which right does the copyright holder not have exclusive rights? ____
A. Critique of the work B. Public performance of the work C. Distribution of the work D. Reproduction of the work