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

# 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?

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

Your syntax is correct. Make sure tables A and B are really not linked.

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

Or even if they're linked, make sure you clear selections first.

Try this. I loooks redundant but It has a difference.

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

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

That worked. Thanks.

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

I have a similar problem like yours. but the suggested method doesnt seem to work.

there is an additional condition for me that , one of the fields of A is linked to another table C, and its field value is also taken into consideration.

it is something like this.

B.location = A.location where  c.country = 'US'

a and c are linked tables.

so for this i just added...

Sum({\$<B.Location=, B.Location = P({\$ <C.Country = {US}>} A.Location) >} B.Amount)

but it doesnt seem to work,

could you let me know what is that ,i am not doing correct.