2 Replies Latest reply on Oct 3, 2016 8:30 AM by Ashleigh Hawkins

    How to show Prior Month Data when month filter applied?

    Ashleigh Hawkins

      Hi

       

      New to Tableau and wondering if someone can help me. Below is an example of data:

       

      DateDept IDValue
      01/08/1610001
      01/08/1620001
      01/08/1620001
      01/09/1620001
      01/09/1610001
      01/10/1640001
      01/10/1610001
      01/10/1620001
      01/10/1630001
      01/10/1610001

       

      I have a Month Filter on the worksheet and want to get a table that shows the count of distinct departments in the current and previous month in the same table. So if October filter is selected I would like to see the following table:

       

      Thanks

       

      Current Month Number of Distinct Departments (Oct)     4
      Previous Month Number of Distinct Departments (Sep)

            2