Filtering the pivot table now is very easy with Slicer in Excel

To make this direct spin table, do the following:

Select the information index (click on any cell in the information index and press [Ctrl]+[Shift]+8)
Press the Insert tab.
Adjust dynamic table in the collection of tables and adjust OK.
Drag the Category field to the Row Tags list.
Drag the Units field in order to the list of values.
With a quick glance, you can find out what classes have units on demand and what number of. You can channel this program by checking and unchecking things in the Labels drop-down menu of the rows. It's simple enough, but for the untrained customer it can be confusing. In addition, it carries no less than four ticks.