I have a data source (two in fact, both are same data extract - one acting as primary in One Sheet and in the next sheet the other one acts as primary).
Below is the sheet 1 of my workbook. I have selected 4314 as scheme code in Filter and i get the result with two Customer Code:
|Customer Code||Scheme Code||Scheme Spend|
Now since for the above selection i made - i got 2 customer code - now in the second sheet , i should see for all the scheme code (not the only one i selected in first worksheet, need all scheme code ) but with only 2 customer code (which was got from filter in sheet one) aginst all scheme code,
Curently my sheet 2 is
My Desired Output is: (we should not introduce any filter in customer code specifically, as it varies depends on Scheme selection).
|Scheme code||Customer Code||Scheme Spend|
I tried this in tableau 10 - new feature Apply this to worksheet -> "All using related data sources"
for Scheme Code field in Sheet 1 (4314 aas my selection), but the output gave only one scheme code in sheet2. But i need all scheme code against only 2 customer code selected in sheet 1 (Scheme code 4314)
Can somebody help on this. Am i missing a simple logic?