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.

      Objectives:

      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.