0 Replies Latest reply on Jan 30, 2014 3:14 AM by Ofer Yardeni

    How To keep Table Calculation from one table two another using Rank function?

    Ofer Yardeni

      Hi Tableau People,

      This is A Generalization of a dashboard I wish to build on Tableau.

      The Dashboard should consist of two Tables : Table A and Table B . Table B is a filter to Table A.


      The tables are connected to a data source that has two numeric fields and company names (text).

      There are bins field based on the values of the numeric fields.

      In this example a the Table A is filtered by [Field 1 bin] and [Field 2 bin] and the [rank field] is calculated by some function.



      Table A

           

      Field 1 bin Field 2 binRank fieldField 1field 2Company
      0-500-5011223A
      0-500-5022321B
      0-500-5033455C

       

       

       

      Table B should display for every combination of [field 1 bin] and [field 2 bin] the company with [rank field] = 1.

      Table B

           

      Field 2 bin
      0-5050-100
      Field 1 bin 0-50AB
      50-100CA


      Table B Should Filter Table A

      Table A is Working for me OK.

      I am Troubling to build Table B correctly


      Thank you

      Tableau Version: 8.1

      Data warehouse : Redshift