1 Reply Latest reply: Apr 21, 2012 9:59 AM by Jonathan Dienst RSS

    pivot table with static dimensions

    Sonika Jain

      Dear all,

       

      Please help me on creating a pivot table with static fields.

       

      The table looks like the one below.  The dimensions A,B,C,D,E are calculated synthetically(We are using valuelist here)

       

      Please help


      Actual ResultsTrend
      XPY-Q1PY-Q2PY-Q3PY-Q4CY-Q1CY-Q2CY-Q3CY-Q4Q1-CY/PYQ2-CY/PYQ3-CY/PYQ4-CY/PYCY/PY
      A$1,692






      -7.60%-6.40%1.30%1.60%-3.00%
      B$2,477






      -7.60%-5.00%3.00%1.50%-2.30%
      C$908






      6.90%1.30%1.70%7.00%4.10%
      D$1,002






      8.70%0.60%0.50%-3.10%1.80%
      E$401






      1.80%4.20%6.30%-3.30%2.40%
      F$1,476






      20.80%20.40%21.10%-5.40%14.60%