How Dynamic column selection in one Table will filter data in for a particular column another table

tableaucommunity@tableau.com — Sun, 22 Apr 2012 01:57:13 GMT

Summary Table
Product	Channel1	Channel2	Channel3	Channel4	Channel5
P1	SP1	SP12	SP121	SP1411	SP14111
		SP13	SP122
		SP14	SP141
		SP15



Detail Table			Detail Table
Product	Sub Product		Product	Sub Product
SP1	SP12		SP141	SP1411
	SP13
	SP14
	SP15

As shown in above Figure , We have a Summary report where we are displaying all the sub products of different Channel for a particular product.

Now the requirement is if we select any particular sub product like SP1, then in detail report it should show all the Sub product of next channel like Channel2 as shown above.

If we select SP141 which is in channel4 then in detail report it should show sub products of channel5.

Using filter action we are able to do for any particular fixed channel like for channel 1 or channel2 or channel 3.

But not for any dynamic channel .

So that in what ever channel we will select sub product in detail report we will get sub product of next channel.

As per my findings we can apply filter only to a particular column not for multiple columns which will filter data in another table.

Is there any way to achive this.

Content in Tableau Community Forums

How Dynamic column selection in one Table will filter data in for a particular column another table