5 Replies Latest reply on Nov 30, 2018 10:42 AM by Mikey Michaels

    Help - Only show last month

    Mikey Michaels

      Hello Tableau Community,

      I have a quick question -  with the help of this forum, I was able to create a parameter which shows each month within my fiscal year (ours starts in Oct). I use this on a ton of different workbooks so Im trying not to adjust the calculated fields and parameters I already have set.

       

      I was hoping that I could create a new calculated field that would dynamically show only the last month based off my parameter. For instance, if the parameter is set to Sept 2018 it will show data from Oct 2017 - Sept 2018. I would like to create a calculated field to only show Sept 2018. Another example, if my parameter was set to November 2018, I would only want my viz to show November 2018. I thought I could use the LAST() function however this solution doesnt seem to be dynamic.

       

      Cheers,

      Mikey