6 Replies Latest reply: Aug 8, 2012 6:04 AM by ramkumar24 RSS

    Expression in pivot table

      In my report I am using the Pivot table to show the data, the structure is similat to below one

       

                     Dec-11                                                                Jan-12

      -----------------------------------------------------    ---------------------------------------------------------

      Amount               Diff Amount,(m-1)             Amount                   Diff Amount,(m-1)                  

      ----------------------------------------------------    ---------------------------------------------------------

      3500                         0                                     5000                         1500

       

       

       

      I am using expression to calculate the value of "Diff Amount,(m-1)" field, but somehow its not working as expected or may be i am doing something wrong.

      Please do help to get the expected result.