ways to restrict access to full data set

assume i have a data set that contain data for >>100 offices. The data being confidential, is there a way to setup such that the report will only show the office data that the login user is responsib...