5 Replies Latest reply: Dec 4, 2017 9:13 AM by Shraddha Gajare RSS

    Using a limitation on dimension

    Martyn Collis

      I am building my report to display data that I want to limit using a variable field.

      I have a start date field that I only want reported if the date is more than 18 months ago. in effect it will report all historic sales agents that have not made a sale in a long time or never made a sale at all.

       

      Is it possible to have calculated data as a limitation?

      I am trying to use the calculated value as: date(today()-495,'DD-MM-YYYY')