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!