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|