You can group and ungroup field values to define your own clustering. Click Expand Field in the Active Field group.Īll the items of the field Region will be expanded.Click on any of the items of the field – Region.If you want to expand all the items of a field at once, do the following − Click Collapse Field in the Active Field group.Īll the items of the field Region will be collapsed.Click any of the items of the field – Region.If you want to collapse all the items of a field at once, do the following − The item East of the field Region will expand. If you want to collapse any of them, repeat the steps that you have done for East.Ĭlick on the symbol to the left of East.

The item East of the field Region will collapse.Īs you can observe, the other items - North, South and West of the field Region are not collapsed. If you have nested fields in your PivotTable, you can expand and collapse a single item or you can expand and collapse all the items of the active field.Ĭonsider the following PivotTable, wherein you have Salesperson field nested under Region field.Ĭlick the symbol to the left of East. The commands on the Ribbon of ANALYZE tab include the following − You will learn the DESIGN commands in the Chapter - Aesthetic Reports with PivotTables. You will learn the ANALYZE commands in this chapter. The DESIGN tab commands will be useful to structure the PivotTable with various report options and style options. The ANALYZE tab has several commands that will enable you to explore the data in the PivotTable. In the worksheet containing a PivotTable, the Ribbon will contain the PivotTable Tools, with ANALYZE and DESIGN Tabs.

Pivot table tool constraints