7 Replies Latest reply on Jul 18, 2018 4:05 PM by Shinichiro Murakami

    MTD and QTD Filter

    Tony Smith
    Tony Smith Jul 12, 2018 12:20 PM

      Hi All,

       

      Can someone please help me with the query below.

       

      I have two worksheets.  The first one gives me four months of the current year and the same period for the previous year.  On the current month of the current year and the corresponding month for the previous year, it gives me all the sales for July in 2017 and 2018.  What I want is to get sales figures for only the completed weeks on the current month for the current year and the corresponding period in the previous year.

       

      For the second worksheet I am trying to do the same thing as the first worksheet but by quarters.  The filter on this one is not working as expected.  I want the current four quarters for the current year and the corresponding four quarters for the previous year.   I will like the sales figures to show up to the completed week in the current quarter for the current year and the corresponding period for the previous year.

       

      Thanks

       

      Regards

      Tony