How to create current period Vs previous period comparison in tableau.
1. Current date should be the custom date with Quick filter option. When I choose a particular date from Quick date filter option, that should be my current period in the calculation. The date format should be in "March-2001,April-2001" and so on.
2. Calculation: April-2001 over March-2011 (consecutive months same year)
April-2001 over April-2000 (same month over different years)
3. Data should be changed by "sales" and "profit" metric.
4. The whole worksheet should be controlled by "category" and "sub-category" level.