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!