6 Replies Latest reply on Jul 25, 2014 12:25 PM by 1061086

    requirement to display current year and prior year and variance of curr and prior in same report

    1061086

      hello friends,

       

      i have a requirement of display current year and prior year and variance of curr and prior

      this is monthly report......like jan 2014, feb-2014 etc...

      the report format looks below:

      measure column  year      year       YOY

                                2014     2013       VAR

      X                            10       20         -10

      Y                            30       20          10

       

      filters we need to apply for this is year 2014, month jan 2014 from order table

                                                               date feb 2014 filter from ship table.date filter must be 1st day of next month her "feb 2014"..

       

      please update me as soon as possible..

       

      Thanks in advance.....