2 Replies Latest reply: May 16, 2017 9:18 PM by Digvijay Singh RSS

    Quarterly growth in straight table

    Sri B

      I have sample data associated as below.

      DIMENSIONSEXPRESSION

      DIV

      REPORT_YEAR

      REPORT_QUARTERD_MONTHAMOUNT
      101995091995071995100
      101995091995081995150
      101995121995071995200
      101995121995081995100
      101996031996071995300
      101996031996081995350
      101996061996081995400
      101996061996091995450
      101996061996111995500
      101996091996011995550
      101996091996061995600
      101996091996081995650
      101996091996091995700
      101996091996101995750
      101996091996111995800
      101996121996081995500

       

      I want to calculate Quarterly growth AMOUNT for each quarter of 'REPORT_QUARTER' based on maximum of 'D_MONTH' for all years of 'REPORT_YEAR' based on dimensions DIV, REPORT_YEAR, REPORT_QUARTER.

       

      I want to display the result data in straight table as below. With below REPORT_YEAR, QUARTER multibox filter (sample).

                                           Output Table required

      Multibox Filter
      (For understdng, not to display in table)
              DimensionsExpression

      REPORT

      _YEAR

      REPORT

      _QUARTER

      DIVD_MONTHAMOUNT

      Quarterly

      GROWTH

      Calculation

      for understanding

      199509199510071995100     -
      199509199510081995150     -
      199512199510071995200     -
      199512199510081995100-50(100-150)
      199603199610071995300     -
      199603199610081995350250(350-100)
      199606199610081995400      -
      199606199610091995450      -
      199606199610111995500150(500-350)
      199609199610011995550      -
      199609199610061995600      -
      199609199610081995650      -
      199609199610091995700      -
      199609199610101995750      -
      199609199610111995800300(800-500)
      199612199610081995500-300(500-800)

       

      If user select year '1995', user should be able to see Quarterly GROWTH of -50 which is based on latest D_MONTH '081995' of REPORT_QUARTER's 091995 & 121995, likewise for other years.

       

      Can anybody please help. Thanks in Advance. Thanks for your time.