1 Reply Latest reply on Dec 15, 2016 9:57 PM by Prasanna Nandakumar

    All using related data sources - option

    Prasanna Nandakumar

      Hi,

       

      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 CodeScheme CodeScheme Spend
      EJhaJam109944143145.519
      EJhaRan130338543142.571

       

      Sheet1_Tableau.png

      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

      Sheet2_Tableau.png

       

      My Desired Output is: (we should not introduce any filter in customer code specifically, as it varies depends on Scheme selection).

       

      Scheme codeCustomer CodeScheme Spend
      0EJhaJam10994410
      EJhaRan13033850
      4314EJhaJam10994415.519
      EJhaRan13033852.571
      4315EJhaRan13033852.45
      4316EJhaJam10994416
      EJhaRan13033852.1

       

      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)