1 Reply Latest reply on Oct 4, 2018 12:29 PM by Deepak Rai

    How can I keep my metrics fixed independently of the filters I use?

    Juan Pablo Trujillo

      Hello, I am relatively new in Tableau 2018.2 and I need to know how can I keep some values fixed no matter the filters I use. The following example can explain better my question.

       

      In the first row with the first column of values we can see the sum of items (87) and the sum of items excluding the "screen" column (1163).

      But when I use the filter "screen" to leave only the "screen" = "Nulo" then the sum of items excluding the "screen" column will sum just the items from the "screen"="Nulo".

       

       

      I need to calculate a sum of items that cant be affected by the filter "screen".

       

      Any suggestions would really help. Thank You.