2 Replies Latest reply on Sep 6, 2018 10:31 AM by Joe Oppelt

    How to get "last 6 months" within a Range Date Filter

    Francesca Grisanti

      Hi everybody!

      As you can see, I have a workbook with:

      • date 1 as a single choice filter
      • date 2 as a range dates filter
      • year -> year(date 2)
      • month -> month(date 2)

       

       

      Date 1 is filtering Date 2, so Date 1 = all values in database, and Date 2 = only relevant values.

      When I select a range of dates 2 for a value of date 1 I need to see only the last 6 months of date 2 in my sheet.

       

      How can I get it?

      Please no parameters, the user needs the sheet to look like this!

       

      Thank you!!!

       

      Francesca