this can be accomplished by setting up filters on specific columns.

Our primary ERP database has business data for all locations.

We have many sites.

Each site is a different branch plant.

When replicating, we filter on the branch plant to determine who gets what.