4 Replies Latest reply: Jul 24, 2012 8:20 AM by anamika priyadarshini RSS

    how to take difference of time period in dimension

      Hi guys,

      I am stuck at a position in my project development..I have data in the format below:-

       

       

      Quarters      A      B     C

         Q1             5      6      7

         Q2              8      9     10

          Q3            10      12   13

         Q4              0         3     0

       

       

      and i need chart and table in the format as:-

       

      Quarters       X             Y              Z

          Q2-Q1      -               -               -

           Q3-Q2     -               -               -

           Q4-Q3     -               -               -

       

      How do i solve this problem?