When you refer network you mean the salesman network or salesman region?
If that's the case, one way to do it is through a data reduction by login. The immediate result is that each use only see their relevant data, that means their working region, customers, etc.
If that's not the case and you still want to filter your initial data to a certain rule you can do it defining the filters to be applied when the document or each sheet is open - (Settings - Document Properties - Document Event Triggers- OnOpen - Add Action - Add- Selection (in Selection Type) - Select in Field and then Define the filter and the value to be selected). The process is more or less the same if you want to specify diferent initial selection for each sheet.
If you don't want to shash the data by login and the filtering onOpen rules doesn't apply to your requirement it might be possible to do it through a macro that filters the data by user when the document is open but that's another story and I'm not the right person to help you out.
Normal 0 false false false MicrosoftInternetExplorer4
Your second solution is working however it is applying to whole sheet but user need set the for only one measure not all.. ( i.e. the trigger selection should be applied to only Customer visits. any ides how we can restrict to only one measure.
If your users table has the same access names as the salesman you can capture the logged user to variable and then contraint the customers visits to that name as well. It is a possibility worthwhile to explore mainly if you don't want to reduce the data set by login and most important if the initial filtering shoul only apply to the customers visits and not to the entire document.
The other way is to it through a macro but I don't have enough knowledge about such aspects
