Yes, you can do this! At least what I think you are trying to achieve.
Navigate to Options tab > Advanced filter or sort.
Add the Table: Worker, Field: Record-ID, Criteria: (HcmWorkerLookup::currentWorker())

You can then publish it for other users. The grid is then filtered to only show sales orders created by that user.