11 Replies Latest reply on Apr 3, 2016 11:42 PM by Aishwarya Sivakumar

    How to set up parameters/filters for multi level filtering in tableau ?

    Aishwarya Sivakumar

      Hi Everyone,

       

      I am new to tableau and in learning phase. I have a requirement for which i could not find any better answer. So thought of asking help from the experts here. Below is the requirement.

       

      I have to build up a Actual Vs Target report. The table of actual and target are not related to each other. So i have made tables in two different workbooks which bring actual details from "Actual Workbook" and target details from "Target Workbook" and imported actual workbook into target workbook so that i can bring both worksheet in one dashboard.

       

      Now comes the challenge. There are columns such as "Brand" , "Mrc" and "Prod Location" in both tables. But then there is something called "Target type" in the target table. So when i select only brand the data should be filtered for the target type "1" along with the selected brand from both actual and target reports.When i select brand and prod location, it has to be filtered with target type as "3" along with selected brand and prod location. If i select, brand, prod loc and mrc from the filters  it has to be filtered with target type as "4" along with selected brand,mrc and prod location and so on. It has affect both Actual and target reports whenever the filter is made though the tables are not joined or related to each other.

       

      I tried to achieve this using parameters. But then, it is accepting only boolean values and didnt work out in my case.

       

      Can anyone help me out to achieve this with step by step process (if possible) so that i can show some progress in my demo which is supposed to be today evening or tomorrow.

       

      Thanks in Advance !!

      -Aish