What I did?
I had a Tableau workbook consisting of 3 measures m1,m2 and m3. Following table is generated once you aggregate the fields by year and sum them up.
| | 2017 | 2018 |
----------------------------------------
| m1 | 10 | 20 |
----------------------------------------
----------------------------------------
| m2 | 10 | 20 |
----------------------------------------
----------------------------------------
| m3 | 10 | 20 |
----------------------------------------
What I want?
I want to apply a date filter to variable m3 so that the resulting table looks similar to the one above (but in the background m3 data is filtered.)
I want something like this:
if metric == m3 then filter(year)
Does anyone know how to achieve this in Tableau?