1 Reply Latest reply on May 2, 2018 5:52 PM by Shinichiro Murakami

    Filter by a field not exists in secondary datasource

    Admin BI

      Hi,

      Hope you can help me with a solution. (don´t know if it is posible)

      I have two datasources; both are linked/share fields [T.I]., [ID] and [IdClient]

      I want to filter secondary datasource using a field is not in it.

      My first datasource have the field category, allie and sales. (beside the linked fields)

      My secondary datasorce have the field magazine. (beside the linked fields)

      At the end what I want to know is if i select a category which clients have sales on that category and in the second view the magazines associated to those clients filtered in the first view.

      Let me know please.

      **twbx attached.

       

      2DSFILTER.PNG

      Thanks in advance.