4 Replies Latest reply: Apr 11, 2012 10:19 PM by Leo Varughese RSS

    Indirect Set Analysis: How to filter a column based on another?

      I have two tables in my application that are not connect, they are isolated. However, they share a column with the same data: Location.

       

      I have two charts: one to show the data from table A and the other to show the data from table B.

       

      What I need is: if I select some values in A.Location, I want chart B to filter B.Location based on what was selected in A.Location.

       

      I tried the below but it did not work.

       

      Sum({$<B.Location = P({$} A.Location) >} B.Amount)

       

       

      Ideas?