5 Replies Latest reply on Jan 14, 2016 9:51 AM by Tina Hauser

    Calculated Field for FYTD and previous full month

    Melinda Thompson

      First, let me start off by saying that I am a relatively new user to Tableau and need help with what appears to be a pretty complex requirement.


      First, our client's fiscal year is set to July - June and not the calendar year. Originally, they wanted to see their sales total by FYTD, and so I created this calculated measure:



      Now, they would also like to see their sales total by FYTD for the previous full month, so today (1/13/16) would only show total sales for 7/1/15 - 12/31/15.


      How do I achieve this result?


      Thank you in advance to all!