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

[Ray_Luke]

Hi All,

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

Please see an example below:

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.

[#2]

@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.