2 Replies Latest reply on Mar 11, 2013 9:36 AM by Michael Lance

    Second User Filter

    Michael Lance

      Hello.

       

      I have a workbook with a user filter. It works just fine. It filters by school such that only the principal of school A can see school A's data.

      However, I want to add an additional user filter for grade level so that an administrator or teacher within that building is not only filtered to only see school A data, but within school A, only grades 3 through 5, for example.

       

      I tried doing this and I granted access for the teacher-in-question to see only a specific range of grade levels (via a grade level user filter). Then, while editing that user filter, I allowed all other users (Principals) to see all grades. The result was that no one could see any data. I also tried just adjusting the filter for the teacher and the same result occurred.

       

       

      Any suggestions?

       

      Thanks,

      Michael