2 Replies Latest reply on Aug 23, 2018 4:35 AM by Zhouyi Zhang

    Tableau Lod


      Hi Please check below sample data ,if user select Region =A  and Country=INDIA by filter we need to show B,C total in sheet 2 (Mean need to exclude C) and same thing we need to map sheet 1

      sheet 1 is with Region =C and Sheet 2 is without Region =C Ex is below

      attached is sample excel data with same example please check


      Sheet 1 is actual data based on filtered data

      Sheet 2 is Excluding data based on filtered data


        • 1. Re: Tableau Lod
          Okechukwu Ossai

          Hi Shaik,


          One approach is to use a Country filter and a Region parameter.


          Step 1: Create parameter [Select Region]


          Step 2: Create calculated field [Region 2]

          [Select Region]


          Step 3: Create calculated field [Filter]

          [Select Region] = [Region]

          Set Filter to 'True' in Sheet 1 and 'False' in Sheet 2.



          Step 4: Add [Country] and [Select Region] to your dashboard as filters.




          Hope this helps.


          1 of 1 people found this helpful
          • 2. Re: Tableau Lod
            Zhouyi Zhang

            Hi, Shaik


            Please find my solution attached.


            Below is the screenshot of the calculation and its result



            Hope this helps



            1 of 1 people found this helpful