Regarding the filter by condition option in pivot table in the excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2386014%22%20slang%3D%22en-US%22%3ERegarding%20the%20filter%20by%20condition%20option%20in%20pivot%20table%20in%20the%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2386014%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20taking%20Google%20Data%20analytics%20course%20in%20the%20coursera%2C%20there%20they%20use%20filter%20in%20the%20pivot%20table%20and%20apply%20conditions%20like%2C%20less%20than%20or%20greater%20than%2C%20they%20were%20using%20the%20Google%20sheets%2C%20and%20I%20couldn't%20find%20that%20option%20in%20the%20excel%2C%20you%20can%20select%20or%20unselect%20the%20value%20in%20the%20filter%20but%20there's%20no%20option%20to%20apply%20conditions%20like%20lesser%20than%20or%20greater%20than%20such%20value.%20Is%20there%20any%20way%20you%20guys%20know%2C%20from%20which%20you%20filter%20the%20fields%20by%20conditions%2C%20please%20let%20me%20know.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2386014%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2386139%22%20slang%3D%22en-US%22%3ERe%3A%20Regarding%20the%20filter%20by%20condition%20option%20in%20pivot%20table%20in%20the%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2386139%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1063303%22%20target%3D%22_blank%22%3E%40BHARGAV_RAM_D_R%3C%2FA%3E%26nbsp%3BI'm%20not%20familiar%20with%20Google%20sheets%2C%20but%20in%20an%20Excel%20pivot%20table%2C%20right-click%20anywhere%20on%20a%20row%20label.%20Choose%20Filter%2C%20%3CFONT%20color%3D%22%23FF0000%22%3EValue%3C%2FFONT%3E%20filters...%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-05-26%20at%2008.20.49.png%22%20style%3D%22width%3A%20267px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F283787iC9EF57EA90DCD583%2Fimage-dimensions%2F267x216%3Fv%3Dv2%22%20width%3D%22267%22%20height%3D%22216%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-05-26%20at%2008.20.49.png%22%20alt%3D%22Screenshot%202021-05-26%20at%2008.20.49.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ENo%20you%20can%20select%20the%20type%20of%20filter%20as%20you%20described%20in%20your%20question.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-05-26%20at%2008.21.08.png%22%20style%3D%22width%3A%20306px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F283789iA82822A55C59DAA1%2Fimage-dimensions%2F306x103%3Fv%3Dv2%22%20width%3D%22306%22%20height%3D%22103%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-05-26%20at%2008.21.08.png%22%20alt%3D%22Screenshot%202021-05-26%20at%2008.21.08.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I'm taking Google Data analytics course in the coursera, there they use filter in the pivot table and apply conditions like, less than or greater than, they were using the Google sheets, and I couldn't find that option in the excel, you can select or unselect the value in the filter but there's no option to apply conditions like lesser than or greater than such value. Is there any way you guys know, from which you filter the fields by conditions, please let me know.

1 Reply

@BHARGAV_RAM_D_R I'm not familiar with Google sheets, but in an Excel pivot table, right-click anywhere on a row label. Choose Filter, Value filters...

Screenshot 2021-05-26 at 08.20.49.png

No you can select the type of filter as you described in your question.

Screenshot 2021-05-26 at 08.21.08.png