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...
A layout container’s ____ property stores a list of its child elements.
a) Children b) ElementList c) FlowItems d) List
In a Gantt chart, the length of the bar corresponds to the importance of the task.
Answer the following statement true (T) or false (F)
To profit from their various criminal schemes, organized crime groups transform commodities into cash, an activity known as ________
Fill in the blank(s) with the appropriate word(s).
?Edge includes a _____, which is a streamlined and less cluttered view that allows readers to focus on the selected material
A. ?Book View B. ?NewsPrint View C. ?Reduced View D. ?Reading View