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.
Use this as FILTER