3 Replies Latest reply on Sep 19, 2016 8:44 AM by David Li

    Filter by Last Month, YTD & Prev 12 Months

    Wayne Dickinson

      Hi,

       

      I am a new to Tableau and am trying to develop a report that analyzes "market share".  The data reports the mid-month of the month following (i.e., Aug '16 data is reported about Sep '16).  What I want to do is be able to filter the data by:

      • The "Last Month" in the date range
      • The "Year to Date" (Jan through the last month in the date range)
      • Previous 12 months

      It would be really great if this would update the time periods as new data is added.

       

      I have found some post regarding similar question, but all of the answers have the "TODAY" function in them.

       

      Can anyone point me in the right directions?

       

      Thanks!

       

      Wayne