1 Reply Latest reply on Sep 8, 2016 11:16 AM by Andrew Watson

    How to define Reporting Period Range

    Sambit Kumar Mishra

      Hi Team,

       

      I have a requirement where I have to report the sales based on the selection of "Reporting Period". Please refer to the sample below :

       

       

       

      However, I am not getting the Reporting Period as a Data base column from the underlying source system. Therefore, I need to create a parameter (May be) and derive calculated field so that based on each reporting period selection, Sales measure will shown in the report.

       

      I have created a Start Date and End Date parameter and currently created a calculated field for Sales Measure and based on the start and end date range selection, My Sales is aggregated and show in the report. Below is the sample :

       

      But in the above approach, I am only able to see sales as a Sum of Sales between <Start Date> and <End Date>.

       

      Question :

      >> How to create a parameter similar to "Reporting Period" and how to use it inside the calculation. (Let's Say - Sales Date between <<Begin Date of Reporting Period>> and <<End Date of Reporting Period.

       

      Thanks for your help!

       

      Best,

      Sambit