Thanks @gclampitt and @Nathan CCC. It seems the best solution is to save filters in shared folder for reuse.

@gclampitt Thank you. It works! I think I messed up the filter formula and CASE statement.

@gclampitt Thanks for your reply. 🙏 I have edited the column formula as below, however, the results shown nothing. May you please advise if I am wrong? Thanks a lot.

@Shankar-Oracle I tried to put a filter on Legal Employer Name via this path. May you please share your steps/navigation if I am wrong? Thanks a lot.

@gclampitt Thanks for your suggestion. I tried to add the column formula, but it returned error. May you please share your column formula? Thanks.

@Shankar-Oracle Thank you! I could follow the first step you provided, but I encountered some problem in step 2. I created a new analysis and added Legal Employer Name and assignment count. However, I could not find the items in filter dialog e.g. operator, saved analysis, etc. May you please show the screenshots or…