2 Replies Latest reply on Mar 5, 2017 5:02 PM by mafalda.santos

    Conditional Filter

    mafalda.santos

      Hi all,

       

      I need help on this.

       

      My datasource is an SQL Table with 3 dimensions (Service, Camp, KPI) and a measure (KPI Value).

      My dimension [Service] has 2 values : Voice and Data.

      My dimension  [Camp.] has 2 values: Fix. and Mo.

       

      I need to create a table like  the one on the picture on Tableau but the only problem is that I need to use my [Camp.] as filter on my Dashboard. But when I select Fix. for example instead of Calculating my Camp. for one service it calculates for 2 Services: Voice and Data.

       

      Is there a way to do this ? Create two filters : one for Camp. SERVICEVoice and another for Camp. SERVICEData ?

       

       

       

       

       

       

      Thanks in advance

       

      Mafalda