0 Replies Latest reply: Jun 10, 2013 2:28 PM by Jim Gay RSS

    Section Access - comparing one User to All Users

    Jim Gay

      I have a question about Section Access and how the expressions will work.

       

      I've successfully implemented Section Access based on NTNAME.  Each user that logs in can only see their information.  My question is this, can I do an expression that shows the average for all users compared to the one that is currently logged in.

       

      For example, lets say we have 5 users:

      JOE
      SALLY
      DON

      BOB

      BILL

       

      If Bob logs in, I would like him to see this:

      Bob's Avg Sales: $1000

      Departments Avg Sales $1250

       

      Is this possible with some kind of Set Analysis / Section Access? 

      Thanks!