1 Reply Latest reply on Jun 1, 2015 11:24 AM by Rody Zakovich

    Last months data based on the selection

    Eshwar Prasad

      Hi team

       

      how to pass the Parameter for last month date selection.

      I need to add the last months filter selection.

       

      PFA for your reference

        • 1. Re: Last months data based on the selection
          Rody Zakovich

          Hey Eshwar,

           

          Is your actual workbook have recent data?  If so, you could create a calc like this and put it into the filter shelf, and select true

           

          DATETRUNC('month', [Order Date]) >= DATETRUNC('month', DATEADD('month', -[Month], TODAY()))

           

          Where [Month] is your int parameter.

           

          If it isn't, let me know, as this can be a little trickier.

           

          Regards,

          Rody