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.