Value Filter in Pivot Table

Copper Contributor

In my work sheet I have product-wise value for 2 years. When I filter top 10, it is picking up total of both years and filters top 10. I want top to of year 2 but year 1 data for those corresponding products which are filtered for  year 2 should be displayed for year 1. Pl suggest

1 Reply

@Ganesh630501 To filter an individual column within a PivotTable (PT) , you can select the cell directly to the right of the last column label in the PT (indicated in yellow in the attached example). Then, add a Filter.

Screenshot 2020-06-26 at 05.40.14.png

This will add filter buttons on each of the column labels. Now you can apply the "Top ..." filter as you describe on a single column.

Screenshot 2020-06-26 at 05.43.05.png