How can I filter various data into 1 category using filter mode

%3CLINGO-SUB%20id%3D%22lingo-sub-1727408%22%20slang%3D%22en-US%22%3EHow%20can%20I%20filter%20various%20data%20into%201%20category%20using%20filter%20mode%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1727408%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20filter%20various%20data%20to%20fall%20into%201%20category.%3C%2FP%3E%3CP%3EPlease%20see%20an%20example%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ray_Luke_0-1601439928555.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F222971iE1EE5B1E9850365A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Ray_Luke_0-1601439928555.png%22%20alt%3D%22Ray_Luke_0-1601439928555.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20filter%20the%20entity%20to%20'aimi'%20then%20only%20'ray'%20will%20be%20filtered%20while%20'arif'%20and%20'mikael'%20will%20not%20be%20filtered.%3C%2FP%3E%3CP%3EReally%20appreciate%20if%20someone%20can%20assist%20me%20on%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20You.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1727408%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-1727446%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20filter%20various%20data%20into%201%20category%20using%20filter%20mode%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1727446%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F814286%22%20target%3D%22_blank%22%3E%40Ray_Luke%3C%2FA%3E%26nbsp%3BYou%20have%20used%20merged%20cells.%20Look%20at%20the%20reference%20for%20the%20cell%20that%20has%20%22aimi%22.%20It's%20row%20number%20is%20the%20same%20as%20the%20one%20where%20you%20find%20%22Ray%22.%20The%20filter%20will%20only%20pick-up%20what's%20on%20row%202.%20If%20both%20Ray%20and%20Arif%20share%20the%20same%20entity%2C%20you%20should%20enter%20the%20entity%20for%20both%20for%20the%20filter%20to%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi All,

 

I would like to filter various data to fall into 1 category.

Please see an example below:

 

Ray_Luke_0-1601439928555.png

 

If I filter the entity to 'aimi' then only 'ray' will be filtered while 'arif' and 'mikael' will not be filtered.

Really appreciate if someone can assist me on this.

 

Thank You.

1 Reply
Highlighted

@Ray_Luke You have used merged cells. Look at the reference for the cell that has "aimi". It's row number is the same as the one where you find "Ray". The filter will only pick-up what's on row 2. If both Ray and Arif share the same entity, you should un-merge the cells and enter the entity for both for the filter to work.