1 Reply Latest reply on Jul 29, 2017 7:09 AM by Jim Dehner

    current period Vs prior period

    sudhir ranajn

      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.