Value Filter in Pivot Table

%3CLINGO-SUB%20id%3D%22lingo-sub-1479603%22%20slang%3D%22en-US%22%3EValue%20Filter%20in%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1479603%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20my%20work%20sheet%20I%20have%20product-wise%20value%20for%202%20years.%20When%20I%20filter%20top%2010%2C%20it%20is%20picking%20up%20total%20of%20both%20years%20and%20filters%20top%2010.%20I%20want%20top%20to%20of%20year%202%20but%20year%201%20data%20for%20those%20corresponding%20products%20which%20are%20filtered%20for%26nbsp%3B%20year%202%20should%20be%20displayed%20for%20year%201.%20Pl%20suggest%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1479603%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1491155%22%20slang%3D%22en-US%22%3ERe%3A%20Value%20Filter%20in%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491155%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F706062%22%20target%3D%22_blank%22%3E%40Ganesh630501%3C%2FA%3E%26nbsp%3BTo%20filter%20an%20individual%20column%20within%20a%20PivotTable%20(PT)%20%2C%20you%20can%20select%20the%20cell%20directly%20to%20the%20right%20of%20the%20last%20column%20label%20in%20the%20PT%20(indicated%20in%20yellow%20in%20the%20attached%20example).%20Then%2C%20add%20a%20Filter.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-06-26%20at%2005.40.14.png%22%20style%3D%22width%3A%20150px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201255iA6F31A9A099B902B%2Fimage-dimensions%2F150x276%3Fv%3D1.0%22%20width%3D%22150%22%20height%3D%22276%22%20title%3D%22Screenshot%202020-06-26%20at%2005.40.14.png%22%20alt%3D%22Screenshot%202020-06-26%20at%2005.40.14.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20will%20add%20filter%20buttons%20on%20each%20of%20the%20column%20labels.%20Now%20you%20can%20apply%20the%20%22Top%20...%22%20filter%20as%20you%20describe%20on%20a%20single%20column.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-06-26%20at%2005.43.05.png%22%20style%3D%22width%3A%20223px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201256i2828DC7D8ADA4B4C%2Fimage-dimensions%2F223x98%3Fv%3D1.0%22%20width%3D%22223%22%20height%3D%2298%22%20title%3D%22Screenshot%202020-06-26%20at%2005.43.05.png%22%20alt%3D%22Screenshot%202020-06-26%20at%2005.43.05.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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