IBM Business Analytics

 View Only

How to create a filter expressed for a date with current and previous years

  • 1.  How to create a filter expressed for a date with current and previous years

    Posted Tue March 12, 2024 03:48 PM

    Hi. I need your help please. I am creating a report in that report I want to report on the current selected period and also previous years. Say for example my period filter is between '[Period]?pFromPeriod? and ?pToPeriod?' which is whatever period I select and I want it to also give me data for the perious year

    selected period 202301 - 202310

     i want to also see data for previous 2 years 202201-202212 and 202101 - 202212

    How do I go about it? do I add a data item or create a filter expresssion? (what expresion do I use?)



    ------------------------------
    Kuselwa Mkosana
    ------------------------------