Column Lockdown

Greg Niles

I have a Sales Report that I have filtered a Column that contains the Regional Managers in this report. The Filter is so I can view the Data only for a particular Mnager and also this is what I would like them to see also is just their Sales portion and not the other Managers. When I filter for them, and share to them as a Viewer only. They can still remove the filter to see the other Managers Sales Data. Without copying each Managers Data to a separate Sheet, how can I lock down this column for each individual? Or is this possible?

Matt Hagler

Greg,

 It sounds like you may want to make a report for each manager that has parameters similar to what you have set up in your filter.  Share the report with that particular manager and you should be off to the races.