Using attribute filters from one data set to another data set

[#1]

Hi,

I have two datasets in QV and I join them using the columns A & B. The first table is used to build a summary view and the 2nd table is used to build a detailed view. Columns C & D are used as dimensions on the summary view and I want to use the C & D column filters to apply to detailed view using columns E and F as the data values in these columns match.

Should I be building a column mapping table of some sort?

[ecolomer]

see this example

[#3]

Enrique,

This looks very close to what I am trying to do but in my case the two tables are also joined together using columns A and B. I'll try and see if a variation would work in my case.

Also the detailed view is a straight table where columns from table 2 have been added as dimensions.

[Anonymous]

If the tables are joined shouldn't C and D already be associated with E and F?

[#5]

Michael,

They are but the join is on A and B but we need filters on the values from columns C and D to be available for values from columns E and F.