The following section describes how to manage the Records you see in a Pivot Table using Categories on your Dimensions so as to view a specific group of information.
How to view or hide specific categories in a Pivot Table
Navigate to the Pivot Table you want to work with.
Follow the steps for viewing a Report if you are not sure where to find the Pivot Table.
Hide Categories
- Select the Category which you want to hide from the Pivot Table.
- Right click on the cell that contains it and click on "Hide this category".
![](https://www.activityinfo.org/support/screenshot/cym692tls6bfvp41o.png)
![](https://www.activityinfo.org/support/screenshot/cdqjlrwls6bfw7i1p.png)
You can repeat this for as many Categories as you want.
![](https://www.activityinfo.org/support/screenshot/ccyca32ls6bfwot1q.png)
- The Categories you selected are hidden.
Unhide Categories
- To see which categories have been hidden, click on the "Show hidden" button.
![](https://www.activityinfo.org/support/screenshot/cjscng1ls6bfwt71r.png)
- The hidden Categories will appear grayed out. To hide them again click on "Don't show hidden".
![](https://www.activityinfo.org/support/screenshot/c924npjls6bfx7z1s.png)
- To unhide a specific Category, right click on the category you want and click on "Unhide this category".
- To unhide all hidden Categories, right click on a cell and click on "Unhide all categories".
- To show only one specific Category, right click on the Category you want and click on "Show only this category".
![](https://www.activityinfo.org/support/screenshot/cqxifxwls6bfxlt1t.png)