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.

        

      JanuaryFebruary
      Sales$870,572.74$897,633.35
      Cost of Goods Sold-$2,718.59-$2,535.23
      Payroll & Benefits-$55,102.24-$55,964.24
      Expenses-$46,262.87-$44,686.75
      Grand Total$766,489.04$794,447.13