5 Replies Latest reply on Oct 19, 2015 7:36 AM by Justin Thacker

    Calculate Gross Profit and EBIT in table?

    Justin Thacker

      I have a data set with an account code hierarchy that I am trying to run some trends, etc. on.  However there is also a desire to provide a table with the summary P&L on the sheet as well.  I cannot figure out how to do this with the data set I have.  The flat file I'm using does not have Gross profit, ebit, pbt flags.  I only have revenue, cogs, sg&a, etc.

       

      I want to calculate say Gross Profit and EBIT from the data set attached (small sample)

       

      GP is Group 1 = "Revenue" - Group 1 = "Cost of Revenues"

       

      and so on...  I want it to show up as a row beneath Revenue and Cost of Revenues.