Jun 21 2020 10:47 AM
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
Jun 25 2020 08:48 PM
@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.
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.