1 Reply Latest reply on Oct 15, 2018 7:39 PM by lei.chen.0

    previous year values as along with current year based on paramter selection

    rao marapatla

      Hi all ,

       

      I am looking for a solution .

       

      I have a yearly sales based on sales type.( by default all the sales types are coming from the DB) ,I have to calculate Previous Year act and name it as PY .

      sales type I am using in parameter when ever I select year = 2018 and sales type as PY report should show 2017 Act in undeser sales _Value column.

       

      Please find attached workbook

       

      thanks in advance

       

      version 10.5