0 Replies Latest reply: Apr 21, 2012 3:38 AM by Sonika Jain RSS

    table implementation

    Sonika Jain

      Dear all,

      I am stuck in a scenario where I have to create table looking like the one below-

       

      On the horizontal axis, I need to display quarterly divisions as well as Actual results, Trens etc, as in figure below.

       

      Please suggest any implementation ideas.


      Actual ResultsTrendActualYTD
      XPY-Q1PY-Q2PY-Q3PY-Q4CY-Q1CY-Q2CY-Q3CY-Q4Q1-CY/PYQ2-CY/PYQ3-CY/PYQ4-CY/PYCY/PY12 Month12 Month12 MonthYTD PYYTD CYYTD Change
      actualactualactual
      endingendingchange
      PYCY
      A$1,692






      -7.60%-6.40%1.30%1.60%-3.00%


      $1,619

      B$2,477






      -7.60%-5.00%3.00%1.50%-2.30%


      $2,394

      C$908






      6.90%1.30%1.70%7.00%4.10%


      $924

      D$1,002






      8.70%0.60%0.50%-3.10%1.80%


      $1,057

      E$401






      1.80%4.20%6.30%-3.30%2.40%


      $392

      F$1,476






      20.80%20.40%21.10%-5.40%14.60%


      $1,503