4 Replies Latest reply on Jul 6, 2016 6:46 AM by Marie-claire Fournier

    Action filter on table calculation not possible

    Marie-claire Fournier

      Hello community !

       

      Tableau file is attached for better understanding, but hopefully the screenshots will help too.

       

      I’m trying to create a drill down hierarchy limited to the top 10 and others.

       

      Data :

       

      Context filters (structure can’t be changed) :

       

       

       

      Objectives

       

      1- display list of top 10 & other level 1

      (details on how I get the graph below)

      2 - display list of top 10 & other level 2

      (details on how I get the graph below)

      3 - add action filter

      Click on level 1 and update level 2

      Problem :

      When selecting Level 1 OTHER, I would like to filter on all level 1 that do not belong to the top10.

      At the moment, it filters only the last level one

      currently :

       

      expecting:

      Level 2 : exclude level1 which are part of the top 10

       

       

      Details on how I display list of top 10 & other level 1

       

      List of Top 10 and Others
      Calculation if Top 10 or Other
      Filter to display top 10 and "only one other"
      Rank : used to sort the list

      Result

      Why filter is required

       

       

      Problem details

       

      Select Other

      By removing the filter and displaying index & level 1, select other equals to select level p

      action filter currently in place

      Ideal world : target filters would be field :"L1 Top 10 & Other". But the option is not there.

       

      Any idea how I can do this ?

       

      I would really appreciate help as I am stuck on that one.

      Thanks very much !

       

      Marie-Claire