Go to layer category

Go to Layer Category allows you to change layers in a pivot table. This dialog box is particularly useful when there are many layers or the selected layer has many categories.

1. Activate the pivot table.
2. From the menus choose:

   Pivot > Go to Layers...

3. In the Visible Category list, select a layer dimension. The Categories list will display all categories for the selected dimension.
4. In the Categories list, select the category that you want, and then click OK or Apply.