4 Replies Latest reply on Sep 11, 2018 8:14 AM by Joe Oppelt

    Row Level Security by Dynamic Group Membership

    Joseph Hobbs

      I have sales data that I want to display to each territory sales team. I want to create only one report and then use Row Level Security to dynamically display only what each team should see. I want to do this by Group Membership

       

      So I have a table (see below) that I add to my sales data. Each Row now has Team. My calculated field is ISMEMBEROF([Team]) and I set it to TRUE.

       

      But I get an error message saying " Function requires a(n) string literal argument." Using ATTR([Team]) doesn't help, even though each row only has 1 value.

       

      How do I get around this?

       

       

       

      Customer ID

      Team

      AB123Alpha
      CD456Alpha
      EF789Hotel
      GH012Foxtrot
      IJ345Foxtrot

      KL678

      Bravo