3 Replies Latest reply: Sep 7, 2017 4:45 AM by Shinya Suzuki RSS

    Data reduction/omit combination?

      I have a table of data, with one sensitive column ,where some users must not see those values where their department does not match, but i do NOT want the entire row hidden.

       

      For example

      Employee A works in Finance

      Employee B works in HR

       

      My table consist of 4 columns.

      ClientName, EmailAddress, Department, SensitiveNotes

       

      where Department is either HR or Finance

       

      Therefore I need both employees to ALWAYS to be able to see the data in the first 3 columns. BUT i only want them to be able to see SensitiveNotes where their departments match.

       

      It seems the OMIT function removes the entire column from view, which is not what I want.

      Using a Reduction field removes the entire row from view, which again is not what I want.

       

      So i sort of need a combination of these two functions.

       

      Please help!