1 Reply Latest reply on Mar 24, 2016 5:33 PM by John Sobczak

    Using a total as a measure

    Lindley Torbenson

      I have the following table that I would like to put in a chart.  I only want to view the information for Sales and Grand Total but I don't want the total amount to change when I remove Cost of Goods or Payroll.  Is there a way to create a calculated total that I can include in a chart while not including all of its components?  See attached workbook.


      Cost of Goods Sold-$2,718.59-$2,535.23
      Payroll & Benefits-$55,102.24-$55,964.24
      Grand Total$766,489.04$794,447.13