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

    Subtraction in pivot table or straight table



      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.