5 Replies Latest reply on Aug 9, 2012 12:47 PM by Gabriel Gejman

    Access User Information from another datasource

    Faryal Ali



      I have developed a dashboard on single datasource. The access right for information are stored in separate excel sheet. It has usernames for customers. I want to apply this to customers in my datasource. But if i try to access it from another sheet get an error. "All fields must be constant or aggregate functions when using across table calculations or multiple datasources".


      Attached file contains two sheets. one with access rights and another with data. UserRights calculated field will be the filter with value show.

      Can anyone guide me how to implement this?