1. Consider the hierarchy Yr->HalfYr->Qtr->Mnth which are string fields. After selecting a year it should display previous 4 years.’
2. When going for HY level it should display previous 4 Half year from the selected Year and HY.
3. Same is the case for Qtr and month
For e.g. IF selecting Year-2015-2016 and Hy-H2 then it should give me previous 4 Hy.
If I am selecting Jan 2015-2016 it should give me Jan16, dec-15, nov-15,Oct-15
Have you tried a context filter like the one described here:
Context Filter vs Only Relevant Values
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...