3 Replies Latest reply on Sep 19, 2018 3:50 PM by Hari Ankem

    Date Range Calculation Not Working


      Hi All,

      I have a filter which slices the data by 3 months, 6 months and 12 months.

      How ever, this filter is not acting accordingly. As you see in attached workbook,


      1. For 3 months, order date is from september 2017-November 2017 which is correct.

      2. For 6 months, order date should be from June 2017-November 2017, how ever I am getting the value only till august 2017.

      3. Similarly for 12 months.

      I want to show the data similar to what I have in workbook.

      How can I show the accurate months for 3 months, 6 months and 12 months respectively?


      It should be,


      1. For 3M- September 2017-November 2017

      2. For 6M-June 2017-November 2017

      3. For 12M- January 2017-November 2017 or December 2016-November 2017