3 Replies Latest reply: Oct 8, 2012 4:41 AM by Rahul Lakhina RSS

    Subtraction in pivot table or straight table

      Hi,

       

      In my report, one of the field is getting calculated based on the subtraction of two fields. Please check the attached screen shot "PnLExp", here i want to calculate "Gross margin".

      Formula is  Gross margin = Total Direct Labor Cost - Total Other Direct Cost

       

      How i can achieve this, in pivot or straight table; pls. help.

      PnLExp.png